详细设计说明书(超市进销存管理系统)(3)

Characters (50)Characters (20)Characters (100)Characters (8)Characters (8)Date

Characters (8)Characters (200)

采购单明细

办理进货

采购单明细商品库存

#oooooooooo

kcId

kcGoodsNamekcNum

kcGoodsUnitkcWareNamekcAlarmNumkcDate

kcGoodsPricekcSellPricekcEmpkcRemark...

Characters (50)Characters (50)Integer

Characters (20)Characters (20)IntegerDate

Characters (8)Characters (8)Characters (50)Characters (200)

退货单明细

退货单明细

kcIdCharacters (50)thGoodsIdCharacters (50)thGoodsNameCharacters (50)thGoodsNumInteger

thGoodsPriceCharacters (8)thGoodsTotalCharacters (8)...

盘点记录

#

*<fi1>*<fi2>ooooo

pdIdkcIdempId

pdShouldNumpdActualNumpdBalancepdDatepdRemark...

Characters (50)Characters (50)Characters (20)IntegerIntegerIntegerDate

Characters (200)

#*<fi>ooooooo

盘点盈亏明细

办理盘点

员工

empIdCharacters (20)deptIdCharacters (20)empNameCharacters (20)pwdCharacters (20)empSexCharacters (4)empBirthdayDateempPostCharacters (20)empTeleCharacters (20)empAdressCharacters (200)...

部门

属于

#deptIdCharacters (20)odNameCharacters (20)oempNumInteger...

退货单

#*<fi>ooooo

thGoodsIdempId

thGoodsDatethNeedPaythHasPaythBalancethReason...

Characters (50)Characters (20)Date

Characters (8)Characters (8)Characters (8)Characters (200)

销售单明细

##oooo

退货单明细

办理退货

##oooo

销售单明细

sellIdCharacters (50)kcIdCharacters (50)sellGoodsNameCharacters (50)sellGoodsNumInteger

sellGoodsPriceCharacters (8)sellGoodsTotalCharacters (8)...

销售单明细

#*<fi>ooooo

销售单

sellIdCharacters (50)empIdCharacters (20)sellGoodsDateDatesellNeedPayCharacters (8)sellHasPayCharacters (8)sellBalanceCharacters (8)sellRemarkCharacters (200)...

办理销售

4.2 数据结构

4.2.1 部门表(Department)：

超市进销存管理系统的详细说明书

4.2.2 员工表(Employee)：

4.2.3 库存商品表(KcGoods)：

4.2.4 采购单表(JhGoodsInfo)：