商品商品号char13co
strai
t商品_primprimarykey名称char10进价smallmo
ey基础售价smallmo
ey保质期smalldatetime生产日期smalldatetime仓库号char10co
strai
t仓库_商品_foreforeig
keyrefere
ces仓库仓库号存量char10
f
createtable员工员工号char13co
strai
t员工_primprimarykey姓名char10性别char2co
strai
t员工_性别_chkcheck性别男or性别女职称char10年龄char2co
strai
t员工_年龄_chkcheck年龄16a
d年龄60工资smallmo
ey电话char11
createtable会员会员号char13co
strai
t会员_primprimarykey姓名char10身份证号char18积分i
t消费金额smallmo
ey余额smallmo
ey
createtable供应商品号char13co
strai
t商品_供应_foreforeig
keyrefere
ces商品商品号供应商号char20co
strai
t供应商_供应_foreforeig
keyrefere
ces供应商供应商
号数量i
t单价smallmo
ey日期smalldatetime员工号char13co
strai
t员工_供应_foreforeig
keyrefere
ces员工员工号co
strai
t供应_primprimarykey商品号员工号
createtable销售商品号char13co
strai
t商品_销售_foreforeig
keyrefere
ces商品商品号收银台号char10co
strai
t收银台_销售_foreforeig
keyrefere
ces收银台收银台
号日期smalldatetime数量i
t会员号char13co
strai
t会员号_销售_foreforeig
keyrefere
ces
会员会员号co
strai
t销售_primprimarykey商品号收银台号

fcreatetable摆放商品号char13co
strai
t商品_摆放_foreforeig
keyrefere
ces商品商品号货架号char8co
strai
t货架_摆放_foreforeig
keyrefere
ces货架货架号数量i
tco
strai
t摆放_primprimarykey商品号货架号
createtable打折商品号char13co
strai
t商品_打折_foreforeig
keyrefere
ces商品商品号折扣号char8co
strai
t折扣_打折_foreforeig
keyrefere
ces折扣折扣号售价smallmo
eyco
strai
t打折_primprimarykey商品号折扣号
createtable值守员工号char13co
strai
t员工_值守_foreforeig
keyrefere
ces员工员工号收银台号char10co
strai
t收银台_值守_foreforeig
keyrefere
ces收银台收银台
号时间段char20co
strai
t值守_primprimarykey员工号收银台号
createtable供应商供应商号char20co
strai
t供应商_primprimarykey供应商名称char20电话char11
createtable货架货架号char8co
strai
t货架_primprimarykey地址char20员工号char13co
strai
t员工_货架_foreforeig
keyrefere
ces员工员工号
createtable仓库
仓库号char10co
strai
t仓库_primprimarykey地址char20员工号char13co
strai
t员工_仓库_foreforeig
keyrefere
ces员工员工号
createtable收银台收银台号char10co
strair