收银系统数据库设计.doc下载

weixin_39821228 2023-01-23 13:30:11
KFC收银系统数据表 一 项目名称:KFC收银管理系统 二 数据库名称:KFCManagement 三 详细分析 ( 共10张表) 1.员工信息表(EmployeeInfo) ——记录所有员工信息 "字段名 "数据类型 "长度 "键情况 "说明 " "EmpId "Varchar "10 "主键 "员工编号 " "EmpName "varchar "20 "Not null "员工姓名 " "EmpPass "Varchar "6 "Not null "密码 " "EmpSex "varchar "2 "Not null "性别 " "EmpBirthday "Datetime " " "出生日期 " "EmpPosition "Varchar "20 "Not null "职位 " "EmpTel "Varchar "15 "Not null "电话 " "EmpAddress "Varchar "50 " "地址 " "EmpStatus "Varchar "4 "Not "在职状态 " " " " "null(在/离/休) " " "EmpInTime "dateTime " "Not null "入职日期 " "EmpOutTime "dateTime " "null "离职日期 " 2.优惠类型表(SaleType) ——记录所有的优惠类型 "字段名 "数据类型 "长度 "键情况 "说明 " "SalId "int "10 "主键(identity) "类型编号,自增1 " "SalName "varchar "20 "Not null "类型名称 " "SalRemark "Varchar "200 " "备注 " 3.商品信息表(ProductInfo) ——记录所有商品以及套餐的详细信息 "字段名 "数据类型 "长度 "键情况 "说明 " "ProId "int " "主键(自动生成) "商品编号,自增1" "ProName "Varchar "50 " "名称 " "ProUnitId "Varchar "10 " "计量单位 " "ProPrice "Money " " "价格 " "ProSalType "Int " "外键SaleType(SalId) "优惠类型编号 " "ProStartTime "Datetime " " "开始使用时间 " "ProEndTime "DateTime " " "结束时间 " "ProRemark "Varchar "200 " "备注 " 4.商品清单表(ProductList) ——记录所有商品的详细信息 "字段名 "数据类型 "长度 "键情况 "说明 " "PrLId "int " "主键(identity) "商品编号,自增1" "PrLName "Varchar "50 " "名称 " "PrLUnitId "Varchar "10 " "计量单位 " "PrLPrice "Money " " "价格 " "PrLType "Varchar "20 "主食/配餐/小食/冷热饮/"产品类型 " " " " "甜品 " " "PrLRemark "Varchar "200 " "备注 " 5.登录信息表(LoginInfo) ——记录系统的登入,登出信息 "字段名 "数据类型 "长度 "键情况 "说明 " "LogId "int " "主键(identity) "主键编号,自 " " " " " "增1 " "LogEmpId "Varchar "10 "外键EmployeeInfo(EmpId)"员工编号 " "LogInTime "DateTime " "Not null "登入时间 " "LogOutTime "DateTime " " "退出时间 " "LogLptNo "Varchar "10 "Not null "端口号 " "LogInMoney "Money " "Not null "登入时金额 " "LogOutMoney "Money " " "退出时金额 " 6.销售单单据记录表(SaleRecordInfo) ——记录已做销售的单据信息 "字段名 "数据类 "长度 "键情况 "说明 " " "型 " " " " "SaRId "Varchar"15 "主键 "销售单号 " "SaRSaFTime "DateTim" " "销售时间 " " "e " " " " "SaRTotalMoney "Money " " "总金额 " "SaRPayMoney "Money " " "实收金额 " "SaRReturnMoney"Money " " "找零 " "SaRLogId "Varchar"10 "外键LoginInfo(LogId) " , 相关下载链接:https://download.csdn.net/download/qq_43966957/87372367?utm_source=bbsseo
...全文
浏览 回复 打赏 收藏 举报
写回复
回复
切换为时间正序
请发表友善的回复…
发表回复
发帖
下载资源悬赏专区

1.1w+

社区成员

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