数据库设计表设计说明.doc下载

[weixin_39820835]

入库资料表结构说明 一、考证资料库 测站标题表 测站标题表用来描述每个测站的基本信息。这些信息一般不随时间的变化而变化。在整 个数据库的生命周期中，测站标题表的内容基本保持不变。但该表中的数据需要逐条的 录入。 表标识: ST_STINF_B 表编号: 101 "字 段 名 "标 识 符 "类型及 "有无 "单 位 "主"索引 " " " "长度 "空值 " "键"序号 " "测站编码 "STCD "C(8) "无 " "Y "1 " "报汛站码 "STCDT "C(5) "无 " " " " "站名 "STNM "C(20) "无 " " " " "河名 "RVNM "C(20) " " " " " "经度 "ESLO "N(7) " "度分秒 " " " "纬度 "NTLA "N(6) " "度分秒 " " " "行政代码 "ADCD "N(6) "无 " " " " "基准高程 "BASE "N(6,2) " "米 " " " "修正参数 "MDPR "N(4,2) " " " " " "站类 "STTP "C(1) " " " " " "拍报项目 "ITEM "C(14) " " " " " "始报年月 "FNYM "C(6) " " " " " "结束年月 "ENDYM "C(6) " " " " " 二、实时水雨情库 时段降水量表 时段降水量表用来记录时段降水量和日降水量以及积雪深度和密度。该表中的数据可以 使用相应的信息处理系统自动将报汛资料写入数据库中。 表标识: ST_RNFL_R 表编号: 201 "字 段 名 "标 识 符 "类型及 "有无 "单 位 "主"索引 " " " "长度 "空值 " "键"序号 " "测站编码 "STCD "C(8) "无 " "Y "2 " "年月日时分 "YMDHM "T "无 " "Y "1 " "时段降水量 "DTRN "N(5,1) " "毫米 " " " "降水历时 "RNTM "N(3,1) " "分钟 " " " "日降水量 "DYRN "N(5,1) " "毫米 " " " "积雪深度 "SDP "N(3) " "毫米 " " " "积雪密度 "SDN "N(3,2) " "克立方厘米 " " " "时段天气 "WTHDT "C(1) " " " " " "日天气 "WTHDAY "C(1) " " " " " "降水量类型 "RNTYPE "C(1) " " " " " 河道水情表 河道水情表用来记录河道水文（水位）站测报的河道水情信息，如水位和流量等。该表 中的数据可以使用相应的信息处理系统自动将报汛资料写入数据库中。 表标识: ST_RIVER_R 表编号: 203 "字 段 名 "标 识 符 "类型及 "有无 "单 位 "主"索引 " " " "长度 "空值 " "键"序号 " "测站编码 "STCD "C(8) "无 " "Y "2 " "年月日时分 "YMDHM "T "无 " "Y "1 " "水位 "ZR "N(7,3) " "米 " " " "流量 "Q "N(9,3) " "立方米每秒 " " " "测流面积 "XSA "N(9,3) " "平方米 " " " "河水特征 "ZRCHAR "C(1) "无 " " " " "水势 "ZRTEND "C(1) " " " " " "测流方法 "QMES "C(1) " " " " " "测积方法 "XMES "C(1) " " " " " 闸坝水情表 闸坝水情表用来记录河道上闸坝站测报的水情信息。该表中的数据可以使用相应的信息 处理系统自动将报汛资料写入数据库中。 表标识: ST_DAM_R 表编号: 204 "字 段 名 "标 识 符 "类型及 "有无 "单 位 "主"索引 " " " "长度 "空值 " "键"序号 " "测站编码 "STCD "C(8) "无 " "Y "2 " "年月日时分 "YMDHM "T "无 " "Y "1 " "闸上水位 "ZU "N(7,3) " "米 " " " "闸下水位 "ZD "N(7,3) " "米 " " " "闸水特征 "ZUCHAR "C(1) "无 " " " " "闸上水势 "ZUTEND "C(1) " " " " " "闸下水势 "ZDTEND "C(1) " " " " " 湖库水情表 湖库水情表用来记录湖库站测报的水库水情信息。该表中的数据可以使用相应的信息处 理系统自动将报汛资料写入数据库中。 表标识: ST_RSVR_R 表编号: 205 "字 段 名 "标 识 符 "类型及 "有无 "单 位 "主"索引 " " " "长度 "空值 " "键"序号 " "测站编码 "STCD "C(8) "无 " "Y "2 " "年月日时分 , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372641?utm_source=bbsseo