高校数据管理信息标准(数据模式)设计说明书-15.doc资源-CSDN文库

版权申诉

5星 · 超过95%的资源 80 浏览量 2022-07-13 08:03:54 上传评论收藏 6.18MB DOC 举报

资源推荐

资源详情

资源评论

高校管理信息标准

数据模式

设计说明书

高校管理信息标准数据模式设计说明书

2 / 191

1 前言-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------21

2 设计说明 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------21

2.1 分类策略 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------21

2.2 表命名规则 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------23

2.3 升级策略 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------24

2.4 集成策略 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------25

2.5 字段标准 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------25

2.5.1

通用日期时间标准

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------25

2.5.2

通用字段长度标准

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------27

2.6 主键说明 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------27

2.7 表附加字段信息 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------28

3 模式：对象类 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------29

3.1 逻辑对象子类---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------29

3.1.1 T_XX(

学校基本信息

) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------29

高校管理信息标准数据模式设计说明书

3 / 191

3.1.2 T_XX_XL (

校历

) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------30

3.1.3 T_XQ(

校区基本信息

) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------30

3.1.4 T_DW(

单位基本信息

) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------31

3.1.5 T_DW_TX(

单位通讯信息

)-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------31

3.1.6 T_XKD(

学科点基本信息

) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------32

3.2 实体对象子类---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------33

3.2.1 T_ZP (

照片

) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------33

3.2.2

学生

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------33

3.2.2.1 T_YJS (研究生基本信息) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------33

3.2.2.2 T_BZKS (本专科生基本信息)-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------36

3.2.2.3 T_QTXS (其他学生基本信息)-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------39

3.2.2.4 T_JXJYXS (继续教育学生基本信息) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------42

3.2.3

教职工

3.2.3.1 T_JZG(普通教职工基本信息) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------44

3.2.3.2 T_JZG_QT(其他人员基本信息)----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------47

3.2.4

资产

高校管理信息标准数据模式设计说明书

4 / 191

3.2.4.1 地产房产-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------50

3.2.4.1.1 T_TD(土地使用基本信息)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------50

3.2.4.1.2 T_JZW (建筑物基本信息) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------50

3.2.4.1.3 T_FJ(房间基本信息) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------51

3.2.4.1.4 T_JS(教室基本信息)----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------52

3.2.4.1.5 T_SYS (实验室基本信息)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------52

3.2.4.1.6 T_SSL (宿舍楼基本信息)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------53

3.2.4.1.7 T_SS(宿舍基本信息) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------53

3.2.4.2 仪器设备-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------54

3.2.4.2.1 T_YQSB(仪器设备基本信息) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------54

3.2.4.3 家俱 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------55

3.2.4.3.1 T_JJ(家俱基本信息)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------55

3.2.4.4 图书 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------57

3.2.4.4.1 T_TS(图书基本信息) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------57

3.2.4.5 设施 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------58

3.2.4.5.1 T_SHS(设施基本信息)-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------58

高校管理信息标准数据模式设计说明书

5 / 191

4 模式：活动类 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------59

4.3 对象管理活动子类 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------59

4.3.1

学生工作管理

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------59

4.3.1.1 招生 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------59

4.3.1.1.1 T_BZKS_GK(本专科生招生基本信息)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------59

4.3.1.1.2 T_BZKS_GKZF(本专科生高考总分) -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------60

4.3.1.1.3 T_BZKS_GKKMCJ(本专科生高考科目成绩)------------------------------------------------------------------------------------------------------------------------------------------------------------------60

4.3.1.1.4 T_YJS_ZS(研究生招生基本信息)----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------61

4.3.1.1.5 T_YJS_RXKSCJ(研究生入学考试成绩) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------62

4.3.1.2 入学 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------63

4.3.1.2.1 家庭和通讯 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------63

4.3.1.2.1.1 T_BZKS_TX(本专科生通讯信息)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------63

4.3.1.2.1.2 T_BZKS_JTCY(本专科生家庭成员信息)-----------------------------------------------------------------------------------------------------------------------------------------------------------------64

4.3.1.2.1.3 T_YJS_TX(研究生通讯信息) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------64

4.3.1.2.1.4 T_YJS_JTCY(研究生家庭成员信息) -----------------------------------------------------------------------------------------------------------------------------------------------------------------------65

4.3.1.2.2 背景和经历 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------65