点菜--数据库设计.doc下载

weixin_39822095 2023-01-23 16:30:21
角色表:T_ROLE "字段名称 "字段代码 "数据类型 "约束 "说明 " "角色ID "ID "INTEGER "主键 "自增列 " "角色名称 "NAME "VARCHAR(100) "非空 " " 员工表:T_EMPLOYEE "字段名称 "字段代码 "数据类型 "约束 "说明 " "员工ID "ID "INTEGER "主键 " 自增列 " "帐号 "CODE "CHAR(6) " " 不能为null,长度固定6位, " " " " " "纯数字 " "密码 "PWD "VARCHAR(20) " " " " " " " "不能为null,长度必须大于等于" " " " " "6位 " "姓名 "USERNAME "VARCHAR(100) " " 不能为null, " "角色ID "ROLE_ID "INTEGER "外键 " 不能为null,引用 T_ROLE表 " " " " " "的ID字段 " 桌台规格:T_TABLE_SIZE "字段名称 "字段代码"数据类型 "约束 "说明 " "桌台规格ID "ID "INTEGER "主键 "自增列 " "桌台规格 "SIZE "INTEGER " "不能为null,最多可坐几个人 " 桌台信息:T_TABLE_INFO "字段名称 "字段代码 "数据类型 "约束 "说明 " "桌台ID "ID "INTEGER "主键 "自增列 " "桌台号 "NO "INTEGER " "不能为null,不能重复(唯一约 " " " " " "束) " "桌台规格 "SIZE_ID "INTEGER "外键 "不能为null,引用 " " " " " "T_TABLE_SIZE表的ID字段 " "桌台状态 "STATE "INTEGER " "引用T_DATA_DICTIONARY表的ID " " " " " "字段 " "桌台位置说明"DESCRIBE "VARCHAR(200)" "说明桌台位于哪里(东、西、南 " " " " " "、北) " 数据字典类别:T_DATA_DICTIONARY_TYPE "字段名称 "字段代码 "数据类型 "约束 "说明 " "类别ID "ID "INTEGER "主键 "自增列 " "类别名称 "NAME "VARCHAR(100)" "数据字典的类别(如:货币、桌 " " " " " "台状态、性别) " 数据字典表:T_DATA_DICTIONARY "字段名称 "字段代码 "数据类型 "约束 "说明 " "流水ID "ID "INTEGER "主键 "自增列 " "代码 "CODE "VARCHAR(50) " "不能为null " "名称 "NAME "VARCHAR(50) " "不能为null " "类别 "TYPE "INTEGER " "不能为null,引用 " " " " " "T_DATA_DICTIONARY_TYPE表的ID" " " " " "字段 " 菜品信息:T_DISH_INFO "字段名称 "字段代码 "数据类型 "约束 "说明 " "菜品ID "ID "INTEGER "主键 "自增列 " "菜品名称 "NAME "VARCHAR(100) " "不能为null " "所属菜系 "DISH_TYPE "INTEGER " "不能为null,引用T_DATA_DICTI" " " " " "ONARY表的ID字段(如:闽菜、川" " " " " "菜等) " "菜品单价 "PRICE "FLOAT " "不能为null " "货币类型 "CURRENCY_TYPE"INTEGER " "不能为null,引用T_DATA_DICTI" " " " " "ONARY表的ID字段(如:元、美元" " " " " "等) " "菜品单位 "UNIT "INTEGER " "不能为null,引用T_DATA_DICTI" " " " " "ONARY表的ID字段(如:份、盅等" " " " " ") " "图片路径 "PHOTO "VARCHAR(200) " "不能为null,保存的是菜品图片" " " " " "的路径 " 订单表:T_ORDER "字段名称 "字段代码 "数据类型 "约束 "说明 " "订单ID "ID "INTEGER "主键 "自增列 " "桌台ID "TABLE_INFO_ID "INTEGER " "不能为null,引用T_ " " " " " "TABLE_INFO表的ID字段,也 " " " " " "就是这是哪一桌的订单 " "服务员 "WAITER_ID "INTEGER " "不能为null,引用T_EMPLOYE" " " " " "E表的ID字段,就是开桌的服" " " , 相关下载链接:https://download.csdn.net/download/qq_43966957/87372775?utm_source=bbsseo
...全文
浏览 回复 打赏 收藏 举报
写回复
回复
切换为时间正序
请发表友善的回复…
发表回复
发帖
下载资源悬赏专区

1.1w+

社区成员

CSDN 下载资源悬赏专区
其他 技术论坛(原bbs)
社区管理员
  • 下载资源悬赏专区社区
加入社区
帖子事件
创建了帖子
2023-01-23 16:30
社区公告
暂无公告