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

[weixin_39821746]

能耗数据库设计 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