能耗数据库设计资料.doc下载

weixin_39821746 2023-01-24 11:00:40
能耗数据库设计 1 数据表及字段前缀说明 T_*_**:T-Table(数据库表) F-Field(数据表字段) T_DC_**:DC-Data Center(数据中心) T_BD_**:BD-Building(建筑) T_DT_**:DT-Dictionary(字典) T_EC_**:EC-Energy Consumption(能耗) T_ST_**:ST-Setting(设计安装) T_OV_**:OV-Original Value(原始值) T_IV_**:IV-Increase Value(增量值) 2 基本字典 1 建筑类别表T_DT_BuildingType "序号"字段名 "推荐数据类型"NULL及"字段中文名 "描述 " " " " "默认值" " " " "BuildingTypeID "Int " "建筑类别ID "主键, IDENTITY(1,1) " " "BuildingTypeName "Varchar(30) " "建筑类别 " " " "BuildingTypeCode "Char(1) " "建筑类别编码"办公建筑 A " " " " " " "商场建筑 B " " " " " " "宾馆饭店建筑C " " " " " " "文化教育建筑D " " " " " " "医疗卫生建筑E " " " " " " "体育建筑 F " " " " " " "综合建筑 G " " " " " " "其它建筑 H " 2 能耗分类表T_DT_EnergyType "序号 "字段名 "推荐数据类型"NULL及"字段中文名 "描述 " " " " "默认值" " " " "EnergyTypeID "Int " "能耗分类ID "主键, IDENTITY(1,1) " " "EnergyTypeName "Varchar(30) " "能耗分类 " " " "EnergyTypeCode "Char(2) " "能耗分类编码"电 01 " " " " " " "水 02 " " " " " " "燃气(天然气或煤气)03" " " " " " "集中供热量 04 " " " " " " "集中供冷量 05 " " " " " " "其它能源 06 " " " " " " "煤 07 " " " " " " "液化石油气 08 " " " " " " "人工煤气 09 " " " " " " "汽油 10 " " " " " " "煤油 11 " " " " " " "柴油 12 " " " " " " "可再生能源 13 " 3 能耗分项表T_DT_EnergySubItem "序号"字段名 "推荐数据类型"NULL及"字段中文名 "描述 " " " " "默认值" " " " "EnergyItemID "Int " "能耗分项ID "主键, IDENTITY(1,1) " " "EnergyItemName "Varchar(30) " "能耗分项 " " " "EnergyItemClass "Int " "能耗分项等级 "0:分项 " " " " " " "1:一级子项 " " " " " " "2:二级子项 " " "ItemParentID "Int " "上级能耗分项I" " " " " " "D " " " "EnergyItemCode "Char(1) " "能耗分项编码 " " " "EnergyTypeCode "Char(2) " "所属能耗分类 "目前只考虑电能分项和子" " " " " "编码 "项 " 电能分项: "分项能耗 "编码 " "照明插座用电 "A " "空调用电 "B " "动力用电 "C " "特殊用电 "D " 一级子项: "分项能耗 "分项能耗编码 "一级子项 "一级子项编码 " "照明插座用电 "A "照明与插座 "1 " " " "走廊与应急 "2 " " " "室外景观照明 "3 " "空调用电 "B "冷热站 "1 " " " "空调末端 "2 " "动力用电 "C "电梯 "1 " " " "水泵 "2 " " " "通风机 "3 " "特殊用电 "D "信息中心 "1 " " " "洗衣房 "2 " " " "厨房餐厅 "3 " " " "游泳池 "4 " " " "健身房 "5 " " " "其它 "6 " 冷热站二级子项: "二级子项 "二级子项编码 " "冷冻泵 "A " "冷却泵 "B " "冷机 "C " "冷塔 "D " "热水循环泵 "E " "电锅炉 "F " 4 仪表类型信息表T_DT_MeterType "序 "字段名 "主、外"字段中文名 "推荐数据类型"描述 " "号 " "键 " " " " " "MeterTypeCode , 相关下载链接:https://download.csdn.net/download/qq_43966957/87372849?utm_source=bbsseo
...全文
浏览 回复 打赏 收藏 举报
写回复
回复
切换为时间正序
请发表友善的回复…
发表回复
发帖
下载资源悬赏专区

1.1w+

社区成员

CSDN 下载资源悬赏专区
其他 技术论坛(原bbs)
社区管理员
  • 下载资源悬赏专区社区
加入社区
帖子事件
创建了帖子
2023-01-24 11:00
社区公告
暂无公告