OA数据库设计.doc下载

[weixin_39821260]

SoFar OA数据表 用户信息表（TB_ User） "字段名 "数据类型 "是否为空（Y / "主外键关系、 "说明 " " " "N） "约束 " " "U_ID "Int "N "Primary key "用户编号（自 " " " " " "动增长） " "U _Name "Varchar(20) "N " "用户名 " "U _Pwd "Varchar(20) "N " "密码(加密) " "U_CH_Name "Varchar(50) "N " "中文名 " "U_EN_Name "Varchar(50) "Y " "英文名 " "U_Sex "Char(2) "N " "员工性别，男/" " " " " "女,默认为男 " "U_Born "Varchar(30) "N " "出生日期 " "U_Email "Varchar(50) "N " "邮件地址 " "U_Phone "Varchar(20) "N " "电话 " "U_Xueli "Varchar(10) "N " "学历 " "U_Card "Varchar(18) "N " "身份证 " "U_Date "Varchar(30) "N " "入职日期 " "U_Address "Varchar(200)"N " "地址 " "U_Native "Varchar(20) "N " "籍贯 " "R_ID "int "N "Forgin key "角色名称 " "U_ Dept "Varchar(20) "N " "部门 " "U_Dupt "Varchar(30) "N " "职位 " "U_Remark "Varchar(200)"Y " "备注 " "U_UpdateTime"datetime "N " "更新时间 " 目录树表（TB_Tree） "字段名 "数据类型 "是否为空（Y / "主外键关系、 "说明 " " " "N） "约束 " " "T_ID "Int "N "Unique " " "T_ParentId "Int "N " "上级节点编号(" " " " " "根节点为0，指" " " " " "向本表ID) " "T_Title "Varchar(80) "Y "Foreign key "节点的显示文 " " " " " "本 " "T_Url "Varchar(200)"Y " "链接地址 " "T_OPRank "Varchar(50) "Y " "默认功能权限 " "T_ "datetime "N " "更新时间 " "UpdateTime " " " " " 角色表(TB_Roles) "字段名 "数据类型 "是否为空（Y / "主外键关系、 "说明 " " " "N） "约束 " " "R_ID "Int "N "Primary key "编号,自动增长" "R_Name "Varchar(20) "N " "角色名称 " "R_Remark "Varchar(200)"Y " "备注 " 角色权限表(TB_Rank) "字段名 "数据类型 "是否为空（Y / "主外键关系、 "说明 " " " "N） "约束 " " "R_ID "Int "N "Primary key "编号,自动增长" "T_ID "Int "N "Foreign key "节点ID " "R_Rank "Varchar(50) "N " "操作权限 " "R_Name "Varchar(20) "N " "角色名称 " "R_Remark "Varchar(200)"Y " "备注 " "R_UpdateTime"datetime "N " "更新时间 " 生产计划表(TB_Products) "字段名 "数据类型 "是否为空（Y / "主外键关系、 "说明 " " " "N） "约束 " " "P_ID "Int "N "Primary key "编号,自动增长" "P_ Car "Varchar(20) "N " "车台型号 " "P_Number "Int "N " "生产数量 " "C_ID "Int "N "Foreign key "客户名称 " "P_ PlanTime "Varchar(200)"N " "计划完成时间 " "P_ PlanMan "Bool "N " "计划提出人是 " " " " " "否签字 " "P_DGM "Bool "N " "副总经理是否 " " " " " "签字 " "P_GM "Bool "N " "总经理是否签 " " " " " "字 " "P_Finance "Bool "N " "财务部是否签 " " " " " "字 " "P_Chairman "Bool "N " "董事长是否签 , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372023?utm_source=bbsseo