项目名称： 重庆大学虎溪校区后勤项目 系统名称： 虎溪校区后勤管理系统 文件名称： 概要设计说明书 寝室信息表 岗位信息表 工程信息表 床位信息表 房产信息表 房产框架 房产类别 房间信息表 房间物品信息表 房间状态表 房间类别表 日常记录 日常调度 日期信息表 月运行记录 植物信息表 植物类别信息表 植被区域信息表 法人信息表 物业人员信息表 租赁记录表 纠纷记录 组织 组织类别 经营范围 维修状态信息表 维修类型信息表 网上报修信息表 职位信息表 能源指数记录表 能源类别 设备信息表 课程信息表 调度表 负荷性质 资产报废单 资产状态表 车辆台帐 车队信息表 车队营业额 食堂信息表
ECE_LMIS_DOMITORY ECE_LMIS_POST ECE_LMIS_PROJECT ECE_LMIS_BED ECE_LMIS_HOUSE_PROPERTY ECE_LMIS_FRAMEWORK ECE_LMIS_HOUSE_TYPE ECE_LMIS_ROOM ECE_LMIS_ROOM_PROPERTY ECE_LMIS_ROOM_STATE ECE_LMIS_ROOM_TYPE ECE_LMIS_DAILY_RECORD ECE_LMIS_DAILY_DISPATCH ECE_LMIS_DATE_TABLE ECE_LMIS_MONTHLY_DIRVE ECE_LMIS_PLANT ECE_LMIS_PLANT_TYPE ECE_LMIS_AREA ECE_LMIS_LEGAL ECE_LMIS_ESTATE_MAN_PER ECE_LMIS_RENT_RECORD ECE_LMIS_DISPUTE TE_UUP_ORG TB_UUP_ORG_TYPE ECE_LMIS_SHOP_CONCEPT ECE_LMIS_MAT_STATE ECE_LMIS_MAT_TYPE ECE_LMIS_MAINTAIN ECE_LMIS_POSITION ECE_LMIS_SOURCE_RECORD ECE_LMIS_SOURCE_TYPE ECE_LMIS__EQUIPMENT ECE_LMIS_COURSE ECE_LMIS_DISPATCH ECE_LMIS_WORKLOAD ECE_LMIS_PRO_DECLARE ECE_LMIS_PRO_STATE ECE_LMIS_BUS ECE_LMIS_FLEET_INFOR ECE_LMIS_FLEET_TURNOVER ECE_LMIS_CANTEEN 第 41 页 共 66 页
项目名称： 重庆大学虎溪校区后勤项目 系统名称： 虎溪校区后勤管理系统 文件名称： 概要设计说明书 食堂营业额 ECE_LMIS_CANTEEN_TURNOVER 4.3数据结构与系统元素的关系
实体关系图：
职位信息表车队信息表车队编号Variable characters (10)车队公司名称Variable characters (50)运营车数Integer车队负责人姓名Variable characters (20)车队营业额编号Long integer车队负责人联系方式Variable characters (20)车队月份Integer车队负责人身份证号Variable characters (20)车队年Integer车队负责人住址Variable characters (100)车队营业额Float (8)Fleet_FleetTurnover车队合同的编号Variable characters (20)车队营业额备注Variable characters (50)车队合同的开始时间Date车队合同的结束时间Date车队营业额编号车队合同的签订时间Date车队备注Variable characters (50)车队编号车队营业额Fleet_Bus车辆台帐车辆编号Variable characters (20)车辆牌照Variable characters (20)驾驶员姓名Variable characters (20)运营记录编号Long integer驾驶员身份证号Variable characters (20)运行月份IntegerBus_Drive年审时间Date运行年Integer保养时间Date月运行公里Float (8)总运行公里数Float (8)运行备注Variable characters (20)有无违章Boolean运营记录编号录入时间Date车辆备注Variable characters (50)车辆编号月运行记录Bus_Dispute纠纷记录临时调度临时调度编号Long integer临时调度名称Variable characters (10)临时调度原因Variable characters (50)调用车辆数量Integer临时调度时间Date临时调度备注Variable characters (50)临时调度编号纠纷编号纠纷名称纠纷内容对方姓名对方电话纠纷处理人纠纷发生时间纠纷处理结果纠纷处理时间纠纷备注纠纷编号Variable characters (10)Variable characters (20)Variable characters (20)Variable characters (20)Variable characters (20)Variable characters (20)DateVariable characters (50)DateVariable characters (50)网上报修信息表维修状态信息表物业人员工号物业人员身份证物业人员姓名物业年龄物业性别出生日期学历民族政治面貌现居住地物业人员联系方式籍贯参加工作时间婚姻状况物业人员备注物业人员工号...职位编号Long integer职位名称Variable characters (10)Variable characters (10)职位备注Variable characters (20)Variable characters (20)Position_EstMngVariable characters (20)职位编号IntegerVariable characters (10)Date日常记录Variable characters (20)事项编号Variable characters (10)Variable characters (10)事项名称Variable characters (20)Variable characters (10)事项内容Variable characters (100)Variable characters (50)事发地点Variable characters (20)Variable characters (20)EstMng_DailyRecord处理结果Variable characters (50)Variable characters (10)事发时间DateDate相关人员Variable characters (20)Boolean事项处理人Variable characters (20)Variable characters (20)事项处理时间Date事项备注Variable characters (20)事项编号EstMng_Change物业人员信息表食堂信息表食堂编号Variable characters (10)食堂名称Variable characters (20)食堂经营单位Variable characters (20)食堂员工数量Integer食堂负责人的姓名Variable characters (10)食堂负责人的联系方式Variable characters (20)食堂负责人的身份证号Variable characters (20)食堂负责人的住址Variable characters (20)食堂合同地编号Variable characters (40)食堂合同地开始时间Date食堂合同地结束时间Date食堂合同地签订时间Date食堂备注Variable characters (50)食堂编号Canteen_CanteenTurnover食堂营业额食堂营业额编号Long integer食堂营业额Float (8)食堂营业额月份Integer食堂气费Float (8)食堂营业额年Integer食堂营业额房屋及设备折旧费Float (8)食堂营业额是否免租Boolean食堂营业额免租原因Variable characters (100)食堂营业额编号人事变动记录变动编号变动原因入岗时间离岗时间人事经办人人事办理时间人事变动备注变动编号岗位信息表Variable characters (10)岗位编号Variable characters (10)Variable characters (20)岗位名称Variable characters (20)Date所属部门Variable characters (20)DatePost_ChangeRecord岗位负责人Variable characters (20)Variable characters (10)岗位负责人电话Variable characters (20)DateVariable characters (50)岗位编号植被区域信息表区域编号区域名称养护单位区域状态区域面积大小区域备注区域编号Variable characters (10)Variable characters (20)Variable characters (10)Variable characters (10)Float (4)Variable characters (50)场地使用表场地使用编号场地使用申请人场地使用用途场地使用申请时间场地使用起始时间场地使用终止时间场地使用费用场地使用收款人场地使用备注场地使用编号Variable characters (10)Variable characters (10)Variable characters (20)DateDateDate & TimeFloat (8)Variable characters (10)Variable characters (20)维修状态编号Variable characters (10)维修单编号Variable characters (10)维修状态Variable characters (10)MatState_Maintain维修地点Variable characters (20)维修状态备注Variable characters (20)维修时间Date维修状态编号维修申请人Variable characters (10)维修申请人电话Variable characters (20)问题描述Variable characters (100)维修人员Variable characters (20)维修类型信息表维修经办人Variable characters (10)维修经办时间Date维修类型编号Long integerMatType_Maintain维修单备注Variable characters (50)维修类型Variable characters (20)维修单编号维修类型编号Area_ValuePlantArea_Plant植物信息表日常调度日常调度编号日常调度名称日常调度执行时间日常调度结束时间日常调度编号调度表Long integerTimeTimeTimeTimeTime工程编号工程名称维修面积工程施工单位工程施工原因工程施工地点工程施工时间工程完工时间工程合同金额报审金额工程审计金额付款日期工程审计人工程报审时间审计返回时间工程经办人工程备注工程编号工程信息表Variable characters (10)Variable characters (20)Float (8)Variable characters (20)Variable characters (100)Variable characters (50)DateDateFloat (8)Float (8)Float (8)DateVariable characters (10)DateDateVariable characters (10)Variable characters (50)名贵植物列表名贵编号名贵植物名称名贵植物价值胸径冠幅株高单位名贵植物状态编制备注栽植时间名贵编号Variable characters (10)Variable characters (20)Float (4)Float (8)Float (8)Float (8)Variable characters (10)BooleanVariable characters (20)Date植物编号植物名称植物数量植物价值植物备注植物栽植时间植物编号Variable characters (10)Variable characters (20)IntegerFloat (4)Variable characters (50)DateLong integer调度编号Variable characters (20)A区后门TmpDispatch_DispatchDateA区大门DateB区主席像C区大门虎溪校区调度编号Place_PlaceUsed场地信息表PlantType_Plant植物类别信息表植物类别编号Variable characters (10)植物类别名称Variable characters (10)植物类别备注Variable characters (20)植物类别编号场地编号Variable characters (10)场地名称Variable characters (20)场地状态Boolean场地类型Variable characters (20)场地备注Variable characters (20)场地编号Place_Course课程信息表负荷性质负荷性质编号Variable characters (10)负荷性质Variable characters (20)负荷性质单价Float (8)负荷备注Variable characters (20)负荷性质编号Workload_Circuit回路信息表能源类别回路编号Variable characters (10)能源记录编号Long integer回路名称Variable characters (20)SouceType_Circuit能源类别编号Variable characters (10)指数Float (8)倍率Float (8)能源类别名称Variable characters (10)录入时间DateCircuit_SouceRecord每月指标Integer能源类别编号能源指数备注Variable characters (20)回路备注Variable characters (20)能源记录编号回路编号...HouseProperty_Circuit房产信息表房产类别商铺租金信息表房产编号Variable characters (10)房产类别编号Variable characters (10)租金编号Long integer房产名称Variable characters (20)房产类别名称Variable characters (20)HouseType_HouseProperty租金月份Integer房产使用面积Float (8)房产类别备注Variable characters (20)租金年Integer房产价值Float (10)房产类别编号是否免租Boolean层数Integer免租原因Variable characters (30)房产建筑面积Float (8)应缴金额Float (8)拆迁Float (8)房产框架缴纳滞纳金Float (8)扩建Float (8)框架编号Variable characters (10)最后期限Date装修或扩建增值Float (8)框架名称Variable characters (20)缴费时间Date房产备注Variable characters (20)Framework_HouseProperty框架备注Variable characters (20)缴费状态Boolean所属校区Variable characters (16)租金备注Variable characters (50)框架编号房产编号租金编号HouseProperty_Room房间状态表房间信息表RoomState_Room房间状态编号Long integerShop_Rental房间状态Variable characters (10)房间编号Variable characters (10)租赁记录表商铺信息表房间实际编号Variable characters (10)房间状态编号合同编号Variable characters (10)房间面积Variable characters (20)商铺编号Variable characters (10)Room_Shop合同开始时间Date钥匙数量Integer商铺经营者Variable characters (30)Legal_RentRecord合同结束时间DateShop_RentRecord房间容量Integer寝室信息表商铺备注Variable characters (20)合同签订时间Date房间用途Variable characters (10)寝室编号Long integer租赁备注Variable characters (20)商铺编号房间备注Variable characters (20)Room_Dormitary床位数量床位编号Integer合同编号床位实际编号房间编号宿舍类别Variable characters (10)Dormitary_BedShopConcept_Shop床位状态住宿标准Float (8)床位备注寝室电话Variable characters (10)寝室状态Boolean经营范围床位编号Room_TmpDormitary范围编号Variable characters (10)RoomType_Room寝室编号范围名称Variable characters (10)Room_RoomProperty范围备注Variable characters (20)临时员工宿舍范围编号能源指数记录表临时员工宿舍编号Long integer临时员工宿舍状态Boolean临时员工月租金Float (8)临时员工宿舍编号TmpDormitary_LiveRecord临时员工入住记录临时入住编号Long integer临时入住时间Date临时离开时间Date临时总额Float (10)临时支付方式Variable characters (10)临时备注Variable characters (20)临时入住编号TmpWorker_LiveRecord临时员工信息表临时员工身份证Variable characters (20)临时员工姓名Variable characters (10)临时员工联系方式Variable characters (20)临时员工身份证临时员工收费表临时员工收费编号Variable characters (10)临时员工缴费年Integer临时员工缴费月Integer临时员工缴费金额Float (8)临时员工缴费人Variable characters (10)临时员工缴费时间Date临时员工缴费状态Boolean临时员工缴费备注Variable characters (30)临时员工收费编号TmpWorker_TmpRent房间类别表房间类别编号Variable characters (10)房间类别Variable characters (20)房间类别备注Variable characters (20)房间类别编号上课时间Variable characters (20)课程信息编号Long integer课程信息编号Date_Course日期信息表日期Date年度Integer学期Variable characters (10)周数Integer周几Integer日期法人信息表法人编号法人姓名法人身份证号法人联系电话法人联系地址法人编号Long integerVariable characters (8)Variable characters (20)Variable characters (15)Variable characters (20)床位信息表入住记录入住记录编号Long integerVariable characters (10)寝室入住时间DateBed_LiveRecordInteger寝室离开时间DateBoolean寝室离开原因Variable characters (20)Variable characters (50)寝室经办人Variable characters (10)寝室办理时间Date入住记录编号Student_LiveRecord学生信息表房间物品信息表物品编号Long integer物品名称Variable characters (10)物品数量Integer物品单价Float (8)物品状态Variable characters (10)物品编号用户IDNumber (19,0)用户编码Variable characters (32)姓名Variable characters (256)性别Number (1,0)政治面貌Variable characters (32)密码Variable characters (256)用户电话Variable characters (32)学生类型用户昵称Variable characters (256)用户地址Variable characters (512)学生类型编号Long integer用户身份证号Number (19,0)学生类型Variable characters (10)StudentType_Student是否在线Number (1,0)学生类型编号籍贯Variable characters (32)年级Variable characters (16)用户创建日期Date用户最后修改日期Date用户创建人IDNumber (19,0)用户最后修改人IDNumber (19,0)用户IDFK_EUOR_ID组织组织类别组织IDNumber (19,0)上级组织IDNumber (19,0)组织编码Variable characters (32)组织名称Variable characters (256)描述Variable characters (512)电话Variable characters (32)备注Variable characters (1024)组织创建日期时间Date组织最后修改日期时间Date组织创建人IDNumber (19,0)组织最后修改人IDNumber (19,0)组织IDORG_EquipmentInfor资产状态表资产状态编号
