夜猫商务会所运营管理平台数据库结构说明书要点

1、数据库结构说明书夜猫商务会所运营管理平台数据库结构说明书文件状态：文件标识 草稿当前版本1.0.0V 正式发布作者:宇祥科技 正在修改完成日期2014-08-25目 录1. 版本历史32. 逻辑设计4II数据库结构说明书1.版本历史版本/状态修订人修改日期备注1.0.0宇祥科 技2014-08-25创建文档3数据库结构说明书2.逻辑设计数据库物理结构图Departme ntsDepIdDepNameUpDepIdDepPyDepWbReMarkVisits-.V_： .7-JCardsCardIDMemberNoCardSendDateParametersUsersUserId"j

2、VisitNoCardIdCardValidDateCardPwdParaNoParaNameParaValueParaRemarkUserIdVisitTimeVisitFeedbackVisitRemarkCardBalanceCardStateCardDepositCardSendUserCardOperTimeCardSerialNumberCardRemarkWorkU nitsUnitNoUnitNameUnitPyUnitWbUnitTelphoneUnitPersonCountUnitPostUnitAddressReMarkCatIdCatCodeCatNameParentC

3、atCodeCatCodeLevelCatCodeStateCatCodePyCatCodeWbRemarkUserNameUserPyUserWbCardRecordsUserPwdIdUserRoleCardIDDepIdMembersTradingTypeUserRemarkMemberNoTradingMoneyHeadSculptureMemberFamilyNameTradingDateMemberGenderSerialNumberMemBerBirthdayMemberMobileMemberLevelMemberUnitNoDeliveriesDeliveryNo.1Orde

4、rNoOrderDetailsUserIdGoodIdDeliveryTimeOrderDetailNoGoodCategoryDeliveryAddressOrderNoGoodBarDeliverySignInGoodNoGoodStandardDeliverySignTimeGoodNameDeliveryStateGoodAlcoholicOrderDetailGoodNameDeliveryRemarkGoodNetcontentOrderDetailBarGoodPriceOrderDetailStandardGoodVipPriceOrderDetailQuantityGoodI

5、ntegralOrderDetailPriceOrderDetailVipPriceOrderDetailAlcoholicOrderDetailNetcontentOrderMemberNoOrderDetailIntegralOrderJineSupplierNo2iOrderDetailSumOrderIntegralSupplierNameOrderOperatorSupplierTelphoneOrderOperatorTimeSupplierAddressOrderStateSupplierLinkmanOrderRecipientSupplierWbOrderAddressVal

6、ueV OrderNoCategoryNameSupplierNameGoodsCategoriesOrdersSuppliersOrderDetails_IDr ValueGoods_IDvalueReports_IDDeliveries_IDI | ValueVisits_IDValueMembers_IDvalueOrders_IDValue数据库结构说明书表设计:表名功能说明1、CardRecords会员卡充值记录表2、Cards会员卡表3、Categories商品分类表4、Deliveries配送信息表5、Deliveries。配送信息序号表6、Departments部门表7、Goo

7、ds商品表8、Goods_ID商品序号表9、Members会员表10、Members_ID会员序号表11、OrderDetails订单详细信息表12、OrderDetails ID订单详细信息序号表13、Orders订单表14、Orders_ID订单序号表15、Parameters参数表16、ReportCategory报表分类表17、Reports报表信息表18、Suppliers供应商表19、Users用户表20、Visits拜访记录表21、Visits ID拜访记录编号表22、WorkUnits配送表表详细设计：表名：CardRecords序号列名数据类型长度小数位标识主键外键允许空默认

8、值说明1Idint是否编号2CardIDvarchar(20)是卡编号3TradingTypeint是交易类型4TradingMoneydecimal(18,4)是交易金额5TradingDatedatetime是交易时间6SerialNumbervarchar(200)是序列号表名：Cards序号列名数据类型长度小数位标识主键外键允许空默认值说明1CardIDvarchar(20)是否编号2MemberNovarchar(20)是会员编号3CardSendDatedatetime是发卡日期4CardValidDatedatetime是有效日期5CardPwdvarchar(50)是密码6Ca

9、rdBalancedecimal(18,4)是金额7CardStateint是状态8CardDepositdecimal(18,4)是消费金额9CardSendUservarchar(20)是发卡人10CardOperTimedatetime是开卡日期11CardSerialNumbervarchar(200)是卡序列号12CardRemarkvarchar(500)是备注表名：Categories序号列名数据类型长度小数位标识主键外键允许空默认值说明1CatIdint40是否编号2CatCodevarchar(20)500是类别编号3CatNamevarchar(50)40是类别名称5Par

10、entCatCodevarchar(20)40是父类别编号6CatCodeLevelint2550是类别等级7CatCodeStateint是类别状态8CatCodePyvarchar(50)是类别拼音9CatCodeWbvarchar(50)是类别五笔表名： Deliveries序号列名数据类型长度小数位标识主键外键允许空默认值说明1DeliveryNovarchar(20)0是否配送编号2OrderNovarchar(20)0是订单编号3Useridvarchar(20)4是用户编号4DeliveryTimedatetime4是配送时间5DeliveryAddressvarchar(20)

11、是配送地址6DeliverySignInvarchar(50)是签收7DeliverySignTimedatetime是签收日期8DeliveryStateint是配送状态9DeliveryRemarkvarchar(50)是备注表名：Deliveries。序号列名数据类型长度小数位标识主键外键允许空默认值说明1Valuebigint0是否计数器表名：Departme nts序号列名数据类型长度小数位标识主键外键允许空默认值说明1DepIdvarchar(20)是否部门编号2DepNamevarchar(50)是部门名称3UpDepIdnchar(10)是上级部门4DepPyvarchar(5

12、0)是部门拼音5DepWbvarchar(50)是部门五笔6ReMarkvarchar(50)是备注表名：Goods序号列名数据类型长度小数位标识主键外键允许空默认值说明1GoodIdvarchar(20)是否商品编号2GoodCategoryvarchar(20)是商品分类3GoodBarvarchar(50)是商品条形码4GoodStandardvarchar(20)是商品规格5GoodNamevarchar(50)是商品名称6GoodAlcoholicdecimal(18,4)是商品酒精度7GoodNetcontentvarchar(50)是商品净含量8GoodPricedecimal(

13、18,是商品单价4)9GoodVipPricedecimal(18,4)是商品会员价10Goodintegraldecimal(18,0)是兑换积分11GoodSuppliervarchar(20)是供货商12GoodStockint是库存13Remarkvarchar(50)是备注表名：Goods ID序号列名数据类型长度小数位标识主键外键允许空默认值说明1valuebigint是否计数器表名：Members序号列名数据类型长度小数位标识主键外键允许空默认值说明1MemberNoMemberNo是否会员编号2MemberFamilyNameMemberFamilyName是姓名3Member

14、GenderMemberGender是性别4MemBerBirthdayMemBerBirthday是岀生日期5MemberMobileMemberMobile是手机号6MemberLevelMemberLevel是等级7MemberUnitNoMemberUnitNo是区号8MemberAddressMemberAddress是地址9MemberRemarkMemberRemark是备注表名：Members ID序号列名数据类型长度小数位标识主键外键允许空默认值说明1valuebigint是否计数器表名：OrderDetails序号列名数据类型长度小数位标识主键外键允许空默认值说明1Orde

15、rDetailNovarchar(20)是否订单明细编号2OrderNovarchar(20)是订单号3GoodNovarchar(20)是商品编号4CategoryNamevarchar(50)是类别名称5SupplierNamevarchar(50)是提供商6OrderDetailGoodNamevarchar(50)是商品名称7OrderDetailBarvarchar(50)是条码8OrderDetailStandardvarchar(20)是规格9OrderDetailQuantityint是数量10OrderDetailPricedecimal(18, 2)价格11OrderDet

16、ailVipPricedecimal(18, 4)会员价格12OrderDetailAlcoholicdecimal(18, 4)酒精度13OrderDetailNetcontentvarchar(50)净含量14OrderDetailIntegraldecimal(18, 0)积分15OrderDetailSumdecimal(18, 4)小计16OrderDetailOperatorvarchar(50)操作人17OrderDetailOperatorTimedatetime操作日期18OrderDetailRemarkvarchar(500)备注表名：OrderDetails ID序号列

17、名数据类型长度小数位标识主键外键允许空默认值说明1Valuebigint是否计数器表名：Orders序号列名数据类型长度小数位标识主键外键允许空默认值说明1OrderNovarchar(20)是否订单编号2OrderMemberNovarchar(20)是会员编号3OrderJinedecimal(18, 4)是金额4OrderIntegraldecimal(18, 4)是积分5OrderOperatorvarchar(50)是操作人6OrderOperatorTimedatetime是操作日期7OrderStateint是状态8OrderRecipientvarchar(50)是收件人9Or

18、derAddressvarchar(50)是地址10OrderRecPhonevarchar(50)是电话11OrderDeliveryManvarchar(50)是接收人12OrderRemarkvarchar(50)是备注表名：Orders_ID序号列名数据类型长度小数位标识主键外键允许空默认值说明1Valuebigint是否计数器表名：Parameters序号列名数据类型长度小数位标识主键外键允许空默认值说明1ParaNovarchar(20)是否编号2ParaNamevarchar(50)是名称3ParaValuevarchar(50)是值4ParaRemarkvarchar(50)是

19、备注表名：Reportcategory序号列名数据类型长度小数位标识主键外键允许空默认值说明1IDint是否编号2RpCodevarchar(20)是编码3RpNamevarchar(50)是名称4RpParentCodevarchar(20)是父编码5RpPyvarchar(50)是拼音6RpWbvarchar(50)是五笔7RpQzvarchar(50)是报表前缀?表名：Reports序号列名数据类型长度小数位标识主键外键允许空默认值说明1IDint是否编号2RCodevarchar(30)是编码3RNamevarchar(100)是名称4RCCodevarchar(20)是分类编码5RC

20、Statevarchar(20)是分类状态6RCreateTimedatetime是创建时间7RLiuShuiHaovarchar(100)是流水号8RBytesvarbinary(MAX)是大小9RYongTuvarchar(300)是用途10RConfigvarbinary(MAX)是配置11RWindowvarchar(50)是窗体名称12REventvarchar(50)是事件名称表名：Reports ID序号列名数据类型长度小数位标识主键外键允许空默认值说明1Valuebigint是否计数器表名：Suppliers序号列名数据类型长度小数位标识主键外键允许空默认值说明1SupplierNovarchar(20)是否编号2SupplierNamevarchar(50)是供应商名称3SupplierTelphonevarchar(50)是电话4SupplierAddressvarchar(50)是地址5SupplierLinkmanvarchar(20)是联系人6SupplierWbvarchar(20)是五笔7SupplierPyvarchar(20)是拼音8SupplierRemarkvarchar(50)是备注表名：Users序号列名数据类型长度小数位标识主键外键允许空默认值说明1