D10固定资产管理系统数据库设计.doc下载

[weixin_39821526]

用户表 tbl_user： "字段名 "列名 "数据类型 "是否允许为空 "是否为主键 "备注 " "主键 "use_id "Int "N "Y "自动增长 " "用户编号 "use _no "Int "N "N "自动增长，唯 " " " " " " "一性 " "用户名 "use _name "Varchar(20) "N "N " " "用户密码 "use _password "Varchar(20) "N "N " " 人员信息表：tbl_person "字段名 "列名 "数据类型 "是否允许为空 "是否主键 "备注 " "主键 "p_id "int "N "Y "自动增长 " "工号 "p_no "int "N "N "自动增长 唯一性" "部门主键 "dep_ id "int "N "N "与tbl_departmen" " " " " " "t中的dep_ id关 " " " " " " "联 " "职位主键 "pos_ id "int "N "N "与tbl_position " " " " " " "的pos_ id关联 " "姓名 "p_name "varchar (40) "N "N " " "性别 "p_sex "Char(2) "N "N "只能输入男或女 " "出生日期 "p_birthday "datetime "N "N " " "身份证号 "p_ic "varchar(20) "N "N " " "联系电话 "p_cellphone "varchar(40) "N "N " " "邮箱 "p_email "varchar(40) "N "N " " 部门管理表： tbl_department "字段名 "列名 "数据类型 "是否允许为空"是否主键 "备注 " "主键 "dep_ id "int "N "Y "自动增长 " "部门编号 "dep_no "int "N "N "自动增长 唯一性 " "部门名称 "dep_name "varchar(40) "N "N " " "上级ID "up_id "int "Y "N "与tbl_department" " " " " " "的ID关联当上级ID" " " " " " "设置为NULL时就是" " " " " " "最上级· " "备注 "dep_remark "varchar(200) "Y "N " " 职位管理表： tbl_position "字段名 "列名 "数据类型 "是否允许为空"是否主键 "备注 " "主键 "pos_ id "int "N "Y "自动增长 " "职位编号 "pos_no "int "N "N "自动增长 " " " " " " "数据唯一 " "职位名称 "pos_name "varchar(40) "N "N " " "备注 "pos_remark "varchar(200) "Y "N " " 类别表：tbl_category "字段名 "列名 "类型 "是否主键 "是否为空 "备注 " "主键 "cate_id "int "Y "N "自动增长 " "类别编号 "cate _no "int "N "N "自动增长 " " " " " " "唯一性 " "类别名称 "cate _name "varchar(50) "N "N " " "添加时间 "cate _date "Datetime "N " " " 资产状态表：tbl_status "字段名 "列名 "数据类型 "是否为空 "是否为主键 "备注 " "主键 "sta _id "Int "N "Y "自动增长 " "状态编号 "sta _st_no "Int "N "N "自动增长，唯 " " " " " " "一 " "状态名 "sta _st_name "Varchar(20) "N "N " " 注：状态表内容不允许操作。 资产信息表：tbl_property "字段名 "列名 "数据类型 "是否为空 "是否为主键 "备注 " "主键 "pro_id "Int "N "Y "自动增长 " "资产编号 "pro _no "Int "N "N "自动增长,唯一" "资产名称 "pro _name "Varchar(50) "N "N " " "资产价格 "pro _price "money "N "N " " "类别编号 "pro _id "Int "N "N "与tbl_categor" " " " " " "y中的cate_no " " " " " " "关联 " "状态编号 "pro _st_no "Int "N "N "与Tbl_status " " " " " " "表中的sta_st_" " " " " " "No关联 " "入库时间 " , 相关下载链接：https://download.csdn.net/download/qq_43966957/87371994?utm_source=bbsseo