档案管理系统数据库设计.doc下载

[weixin_39821051]

档案管理系统数据库设计 1、用户信息表(基础)JC_YHXXB "Name "Code "Data Type "P "F "M " "1 "用户编码 "YH_BM "VARCHAR2(10) " " " " "2 "用户名称 "YH_MC "VARCHAR2(20) " " " " "3 "密码 "YH_MM "VARCHAR2(20) " " " " "4 "性别 "YH_XB "VARCHAR2(10) " " " " "5 "部门 "YH_BM "VARCHAR2(20) " " " " "6 "电话 "YH_DH "VARCHAR2(20) " " " " "7 "用户角色 "YH_YHJS "VARCHAR2(20) " " " " "2、项目阶段表（基础）JC_JDB "Name "Code "Data Type "P "F "M " "2 "阶段编码 "JD_BM "VARCHAR2(20) " " " " "3 "阶段名称 "JD_MC "VARCHAR2(20) " " " " "3、权限表（基础）JC_QXB "Name "Code "Data Type "P "F "M " "2 "权限编码 "QX_BM "VARCHAR2(20) " " " " "3 "权限名称 "QX_MC "VARCHAR2(20) " " " " " 4、项目信息表 DA_XMXXB "Name "Code "Data Type "P "F "M " "1 "项目ID "XM_ID "INTEGER(8) " " " " " "项目子ID "XMZ_ID "VARCHAR2(20)) " " " " "2 "项目编号 "XM_BH "VARCHAR2(20) " " " " "3 "项目名称 " XM_MC "VARCHAR2(20) " " " " "4 "项目负责人 "XM_FZR "VARCHAR2(10) " " " " "5 " 设计单位 " XM_SJDW "VARCHAR2(20) " " " " "6 "设计负责人 "XM_SJFZR "VARCHAR2(20) " " " " "7 "监理单位 "XM_JLDW "VARCHAR2(20) " " " " "8 "监理负责人 "XM_JLFZR "VARCHAR2(20) " " " " "9 "施工单位 "XM_SGDW "VARCHAR2(20) " " " " "10 "施工负责人 "XM_SGFZR "VARCHAR2(20) " " " " "11 "承包单位 "XM_CBDW "VARCHAR2(20) " " " " "12 "承包负责人 "XM_CBFZR "VARCHAR2(20) " " " " "13 "开始日期 "XM_KSRQ "DATE " " " " "14 "结束日期 "XM_JSRQ "DATE " " " " " 5、项目信息子表DA_XMXXZB "Name "Code "Data Type "P "F "M " " "阶段ID "JD_ID "INTEGER(10) " " " " "1 "项目子ID "XMZ_ID "INTEGER(10) " " " " "3 "阶段名称 " JD_MC "VARCHAR2(20) " " " " "5.1项目资料权限表DA_RYQXB "Name "Code "Data Type "P "F "M " " "ID "QX_ID "INTEGER(10) " " " " "1 "阶段ID "JD_ID "INTEGER(10) " " " " "3 " 参与人员名称 " YH_MC "VARCHAR2(20) " " " " " "权限名称 " QX_MC "VARCHAR2(20) " " " " " //5、项目参与人员表 DA_CYRYB "Name "Code "Data Type "P "F "M " " "人员ID "RY_ID "INTEGER(10) " " " " "1 "项目子ID "JD_ID "INTEGER(10) " " " " "3 "人员姓名 " RY_XM "VARCHAR2(20) " " " " "//6、人员权限表 DA_RYQXB "Name "Code "Data Type "P "F "M " " "权限ID "QX_ID "INTEGER(10) " " " " "1 "人员ID "RY_ID "INTEGER(10) " " " " " "阶段ID "JD_ID "INTEGER(10) " " " " "3 "人员权限 " QX_MC "VARCHAR2(20) " " " " " ----------------------- 档案 , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372752?utm_source=bbsseo