安行物流管理系统 数据库设计 任道软件 2015-10-18 目录 1 公共类 1 1.1 sys_base基础信息表 1 1.2 sys_user用户信息表 1 1.3 sys_order订单信息表 1 1.4 sys_models车型信息表 2 1.5 sys_integral积分交易表 2 1.6 sys_message消息信息表 2 1.7 sys_review评价信息表 2 1.8 sys_role角色信息表 3 1.9 sys_menu菜单信息表 3 1.10 sys_permit菜单信息表 3 1.11 sys_dictionaries字典信息表 3 1.12 sys_files附件信息表 4 1 公共类 lms_member会员信息表 字段名称 "字段描述 "数据类型 "可为空 "默认值 "主键 "关联表 " "memberid "会员编号 "varchar(50) "N " "Y " " "telphone "手机号 "varchar(20) "N " " " " "password "密码 "varchar(30) "N " " " " "regtime "注册时间 "varchar(100) "N " " " " "lastlogin "最后登录时间 "varchar(100) "N " " " " "status "状态(默认为0货主,1为车主,2为企业会员) "varchar(20) "N " " " " "lms_detail详细信息表 字段名称 "字段描述 "数据类型 "可为空 "默认值 "主键 "关联表 " "detailid "详细编号 "varchar(50) "N " "Y " " "memberid "用户编号 "varchar(50) "N " " "lms_member " "username "用户名 "varchar(30) "Y " " " " "realname "真实姓名 "varchar(30) "N " " " " "photos "头像 "varchar(100) "N " " " " "email "电子邮件 "varchar(50) "Y " " " " "sex "性别 "varchar(20) "N " " " " "area "常住区域 "varchar(50) "Y " " " " "models "车型 "varchar(20) "Y " " " " "license "车牌号码 "varchar(30) "Y " " " " "idcard "身份证照片 "varchar(100) "Y " " " " "driving "驾驶证照片 "varchar(100) "Y " " " " "registration "行驶证照片 "varchar(100) "Y " " " " "lasttime "最后更新时间 "varchar(30) "N " " " " "integral "积分总数 "varchar(20) "Y " " " " "lms_order订单信息表 字段名称 "字段描述 "数据类型 "可为空 "默认值 "主键 "关联表 " "orderid "订单编号 "varchar(50) "N " "Y " " "orderno "订单号 "varchar(50) "N " " " " "memberid "会员编号 "varchar(50) "N " " " lms_member " "appointment "是否预约发货 "varchar(20) " " " " " "deliverytime "发货时间 "varchar(20) " " " " " "deliveryplace "发货地 "varchar(50) " " " " " "deliverylng "发货地经度 "varchar(20) " " " " " "deliverylat "发货地纬度 "varchar(20) " " " " " "receivingland "收货地 "varchar(50) " " " " " "receivinglng "收货地经度 "varchar(20) " " " " " "receivinglat "收货地纬度 "varchar(20) " " " " " "receivingtel "收货方电话 "varchar(30) " " " " " "range "行驶里程 "varchar(20) " " " " " "cost "费用 "varchar(20) " " " " " "modelsid "车型编号 "varchar(30) " " " " " "carry "是否搬运 "varchar(20) " " "
, 相关下载链接:
https://download.csdn.net/download/qq_43966957/87372814?utm_source=bbsseo