报修系统数据库设计.doc
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
文档编号:DB001 版本号: 1.0 报修系统 数 据 库 设 计 开发单位: 开发负责人: 二〇一五年十一月十二日 目 录 1、 super_user_info(超级管理用户信息数据表) 2 2、 super_ log_info(超级管理员日志信息数据表) 2 3、 staff_info(员工信息数据表) 3 4、 repair_info(维修信息数据表) 3 5、 staff_repair_info(员工维修信息数据表) 4 super_user_info(超级管理用户信息数据表) "编号 "字段名 "类型 "字段意义 "备注 " "1 "id "int " " " "2 "name "varchar(64) "管理用户名 " " "3 "password "varchar(64) "管理用户口令 " " "4 "times "int(2) "登录次数 "0:默认 " "5 "last_time "datetime "最后登陆时间 " " "6 "last_ip "varchar(64) "最后登录IP " " "7 "last_op_time "int "最后操作时间 "记录Unix时间戳 " "8 "tag "int(2) "类型标志位 "1:超级管理员 " " " " " "2:超级权限管理员 " "9 "add_time "datetime "添加时间 " " "10 "add_user "varchar(32) "添加人 " " "备注 " " super_ log_info(超级管理员日志信息数据表) "编号 "字段名 "类型 "字段意义 "备注 " "1 "id "int " " " "2 "user "varchar(64) "用户名 "人物 " "3 "time "datetime "时间 "时间 " "4 "ip "varchar(64) "IP地址 "地点 " "5 "action "varchar(256) "动作 "事件 " "6 "sql_cont "text "所执行的SQL语句 " " " " " "内容 " " "7 "level "Int(2) "日志级别 "0:默认,未知用户级别 " " " " " "1:数据插入 " " " " " "2:数据更新 " " " " " "3:数据检索 " "8 "bz "text "备注 " " "备注 " " staff_info(员工信息数据表) "编号 "字段名 "类型 "字段意义 "备注 " "1 "id "int " " " "2 "show_order "int(2) "显示序号 " " "3 "name "varchar(64) "员工姓名 " " "4 "tel "varchar(32) "员工电话 " " "5 "sex "int(2) "员工性别 "默认为0 " " " " " "0:男1:女 " "6 "age "varchar(16) "员工年龄 " " "7 "pic "varchar(128) "头像照片 "*非必须填写 " "8 "add_time "datetime "添加时间 " " "9 "add_user "varchar(64) "添加人 " " "备注 " " repair_info(维修信息数据表) "编号 "字段名 "类型 "字段意义 "备注 " "1 "id "int " " " "2 "name "varchar(32) "报修人姓名 " " "3 "tel "varchar(32) "报修电话 " " "4 "title "varchar(128) "报修标题 " " "5 "cont "text "报修内容 " " "6 "address "varchar(255) "报修地址 " " "7 "pic "varchar(128) "照片 "*非必须填写 " "8 "check_pw "varchar(32) "查看及评价密码 "报修人自己设定,必须 " "9 "add_time "datetime "报修时间 "自动记录 " "10 "show_tag "int(2) "审核标志位 "默认0:不显示 " " " " " "1:显示 " "11 "state_tag "int(2) "状态标志位 "默认0:报修 " " " " " "1:接收 " " " " " "2:派工 " " " " " "3:维修中 " " " " " "4:维修完毕 " "12 "number "varchar(32) "报修单编号 "默认为空,不生成; " " " " " "当zt_tag为1,同时生成 " "13 "print_tag "int(2) "派工单打印标志位"默认:0,未打印 " " " " " "1:已
- 粉丝: 92
- 资源: 9356
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助