采购销数据库设计

采购销数据库设计数据库设计用户名称：自己的拼音名称项目名称：shoppingUtf-8Struts2spring2.5hibernate3.2Jgb机构表字段名中文名类型长度备注ididintkeyKeyfid父关键字varchar4xsmc显示名称varchar50Bmmc部门名称varchar50Gnbh功能编号varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注Varchar50Bz4备注varchar50Bmb部门表ht1字段名中文名类型长度备注ididintKeybmbh部门编号varchar30bmmc部门名称varchar30zjm助记码varchar15Bz1备注varchar50是否选中Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gwb岗位表ht2字段名中文名类型长度备注ididintKeygwbh岗位编号varchar30gwmc岗位名称varchar30zjm助记码varchar15Bz1备注varchar50是否选Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ryb人员表ht3字段名中文名类型长度备注ididNumber\varcharKeyrybh人员编号varchar30rymc人员名称varchar30zjm助记码varchar15mm密码varchar30Bmmc部门名称varchar50Gwmc岗位名称varchar50Sfxz是否选中varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Lsh流水表字段名中文名类型长度备注ididNumber\varcharKeylsh流水号varchar10rq日期varchar30gnflag功能标识varchar10bz备注标识varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gnqxb功能权限表字段名中文名类型长度备注ididintKeyRymc人员名称varchar10Gnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Xmgnb项目功能表字段名中文名类型长度备注ididintKeygnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50项目种类Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品表spb1字段名中文名类型长度备注ididNumber\varcharKeyspbh商品编号varchar50pmgg品名规格varchar50zjm助记码varchar25xh型号varchar20dw单位varchar20ph批次号varchar50txm条形码varchar50yxq有效期varchar10kc库存number保留小数2位sb商标varchar20cd产地varchar100kcsx库存上限numeric保留小数2位kcxx库存下限numeric保留小数2位lsj零售价numeric保留小数2位pfj批发价numeric保留小数2位Pfj1批发价numeric保留小数2位Pfj2批发价numeric保留小数2位Pfj3批发价numeric保留小数2位bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ksb客商表2字段名中文名类型长度备注ididintKeyKsbh客商编号varchar50Ksmc客商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银行账户varchar100sh税号varchar50khyh开户银行varchar100bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gysb供应商表3字段名中文名类型长度备注ididintKeyKsbh供应商编号varchar50Ksmc供应商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银行账户varchar100sh税号varchar50khyh开户银行varchar100bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Kfb库房表字段名中文名类型长度备注ididintKeykfbh库房编号varchar50kfmc库房名称varchar50zjm助记码varchar20Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品进货单spjhd 4字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30gys供应商varchar100fph发票号varchar50kf库房varchar50zt状态varchar10Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品进货明细表spjhmxb  5字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品退货单spthd  6字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30gys供应商varchar100fph发票号varchar50kf库房varchar50zt状态varchar10thyy退货原因varchar100Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品退货明细表spthmxb  7字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销售单spxsd   8字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30ksmc客商名称varchar100fph发票号varchar50kf库房varchar50zt状态varchar10Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销售明细单spxsmxd   9字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销退单spxtd    1 0字 个人自传范文3000字为中华之崛起而读书的故事100字新时代好少年事迹1500字绑架的故事5000字个人自传范文2000字 段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30ksmc客商名称varchar100fph发票号varchar50kf库房varchar50zt状态varchar10xtyy销退原因varchar100Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销退明细单spxtmxd 11字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报益单byd 12字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30kfmc库房名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报益单明细bydmx 13字段名中文名类型长度备注ididintKeyglid关联idintpmgg品名规格varchar100dw单位varchar20xh型号varchar20bysl报益数量numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报损单bsd  14字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30kfmc库房名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报损单明细bsdmx  15字段名中文名类型长度备注ididintKeyglid关联idintpmgg品名规格varchar100dw单位varchar20xh型号varchar20bssl报损数量numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50帐套表ztb字段名中文名类型长度备注ididintKeyzt状态varchar10Ztmc帐套名称varchar50cjr创建人varchar10cjrq创建日期varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50状态表zhtb字段名中文名类型长度备注ididintKeyMc名称varchar20zt状态varchar10Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50价格跟踪表jggzb字段名中文名类型长度备注ididintKeypmgg品名规格varchar100shmc商户名称varchar100dj单价numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50