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

[weixin_39821228]

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