夜貓商務(wù)會(huì)所運(yùn)營(yíng)管理平臺(tái)數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)要點(diǎn)

1、數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)夜貓商務(wù)會(huì)所運(yùn)營(yíng)管理平臺(tái)數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)文件狀態(tài)：文件標(biāo)識(shí) 草稿當(dāng)前版本1.0.0V 正式發(fā)布作者:宇祥科技 正在修改完成日期2014-08-25目 錄1. 版本歷史32. 邏輯設(shè)計(jì)4II數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)1.版本歷史版本/狀態(tài)修訂人修改日期備注1.0.0宇祥科 技2014-08-25創(chuàng)建文檔3數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)2.邏輯設(shè)計(jì)數(shù)據(jù)庫(kù)物理結(jié)構(gòu)圖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數(shù)據(jù)庫(kù)結(jié)構(gòu)說(shuō)明書(shū)表設(shè)計(jì):表名功能說(shuō)明1、CardRecords會(huì)員卡充值記錄表2、Cards會(huì)員卡表3、Categories商品分類表4、Deliveries配送信息表5、Deliveries。配送信息序號(hào)表6、Departments部門(mén)表7、Goo

7、ds商品表8、Goods_ID商品序號(hào)表9、Members會(huì)員表10、Members_ID會(huì)員序號(hào)表11、OrderDetails訂單詳細(xì)信息表12、OrderDetails ID訂單詳細(xì)信息序號(hào)表13、Orders訂單表14、Orders_ID訂單序號(hào)表15、Parameters參數(shù)表16、ReportCategory報(bào)表分類表17、Reports報(bào)表信息表18、Suppliers供應(yīng)商表19、Users用戶表20、Visits拜訪記錄表21、Visits ID拜訪記錄編號(hào)表22、WorkUnits配送表表詳細(xì)設(shè)計(jì)：表名：CardRecords序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)

8、值說(shuō)明1Idint是否編號(hào)2CardIDvarchar(20)是卡編號(hào)3TradingTypeint是交易類型4TradingMoneydecimal(18,4)是交易金額5TradingDatedatetime是交易時(shí)間6SerialNumbervarchar(200)是序列號(hào)表名：Cards序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1CardIDvarchar(20)是否編號(hào)2MemberNovarchar(20)是會(huì)員編號(hào)3CardSendDatedatetime是發(fā)卡日期4CardValidDatedatetime是有效日期5CardPwdvarchar(50)是密碼6Ca

9、rdBalancedecimal(18,4)是金額7CardStateint是狀態(tài)8CardDepositdecimal(18,4)是消費(fèi)金額9CardSendUservarchar(20)是發(fā)卡人10CardOperTimedatetime是開(kāi)卡日期11CardSerialNumbervarchar(200)是卡序列號(hào)12CardRemarkvarchar(500)是備注表名：Categories序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1CatIdint40是否編號(hào)2CatCodevarchar(20)500是類別編號(hào)3CatNamevarchar(50)40是類別名稱5Par

10、entCatCodevarchar(20)40是父類別編號(hào)6CatCodeLevelint2550是類別等級(jí)7CatCodeStateint是類別狀態(tài)8CatCodePyvarchar(50)是類別拼音9CatCodeWbvarchar(50)是類別五筆表名： Deliveries序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1DeliveryNovarchar(20)0是否配送編號(hào)2OrderNovarchar(20)0是訂單編號(hào)3Useridvarchar(20)4是用戶編號(hào)4DeliveryTimedatetime4是配送時(shí)間5DeliveryAddressvarchar(20)

11、是配送地址6DeliverySignInvarchar(50)是簽收7DeliverySignTimedatetime是簽收日期8DeliveryStateint是配送狀態(tài)9DeliveryRemarkvarchar(50)是備注表名：Deliveries。序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1Valuebigint0是否計(jì)數(shù)器表名：Departme nts序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1DepIdvarchar(20)是否部門(mén)編號(hào)2DepNamevarchar(50)是部門(mén)名稱3UpDepIdnchar(10)是上級(jí)部門(mén)4DepPyvarchar(5

12、0)是部門(mén)拼音5DepWbvarchar(50)是部門(mén)五筆6ReMarkvarchar(50)是備注表名：Goods序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1GoodIdvarchar(20)是否商品編號(hào)2GoodCategoryvarchar(20)是商品分類3GoodBarvarchar(50)是商品條形碼4GoodStandardvarchar(20)是商品規(guī)格5GoodNamevarchar(50)是商品名稱6GoodAlcoholicdecimal(18,4)是商品酒精度7GoodNetcontentvarchar(50)是商品凈含量8GoodPricedecimal(

13、18,是商品單價(jià)4)9GoodVipPricedecimal(18,4)是商品會(huì)員價(jià)10Goodintegraldecimal(18,0)是兌換積分11GoodSuppliervarchar(20)是供貨商12GoodStockint是庫(kù)存13Remarkvarchar(50)是備注表名：Goods ID序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1valuebigint是否計(jì)數(shù)器表名：Members序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1MemberNoMemberNo是否會(huì)員編號(hào)2MemberFamilyNameMemberFamilyName是姓名3Member

14、GenderMemberGender是性別4MemBerBirthdayMemBerBirthday是岀生日期5MemberMobileMemberMobile是手機(jī)號(hào)6MemberLevelMemberLevel是等級(jí)7MemberUnitNoMemberUnitNo是區(qū)號(hào)8MemberAddressMemberAddress是地址9MemberRemarkMemberRemark是備注表名：Members ID序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1valuebigint是否計(jì)數(shù)器表名：OrderDetails序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1Orde

15、rDetailNovarchar(20)是否訂單明細(xì)編號(hào)2OrderNovarchar(20)是訂單號(hào)3GoodNovarchar(20)是商品編號(hào)4CategoryNamevarchar(50)是類別名稱5SupplierNamevarchar(50)是提供商6OrderDetailGoodNamevarchar(50)是商品名稱7OrderDetailBarvarchar(50)是條碼8OrderDetailStandardvarchar(20)是規(guī)格9OrderDetailQuantityint是數(shù)量10OrderDetailPricedecimal(18, 2)價(jià)格11OrderDet

16、ailVipPricedecimal(18, 4)會(huì)員價(jià)格12OrderDetailAlcoholicdecimal(18, 4)酒精度13OrderDetailNetcontentvarchar(50)凈含量14OrderDetailIntegraldecimal(18, 0)積分15OrderDetailSumdecimal(18, 4)小計(jì)16OrderDetailOperatorvarchar(50)操作人17OrderDetailOperatorTimedatetime操作日期18OrderDetailRemarkvarchar(500)備注表名：OrderDetails ID序號(hào)列

17、名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1Valuebigint是否計(jì)數(shù)器表名：Orders序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1OrderNovarchar(20)是否訂單編號(hào)2OrderMemberNovarchar(20)是會(huì)員編號(hào)3OrderJinedecimal(18, 4)是金額4OrderIntegraldecimal(18, 4)是積分5OrderOperatorvarchar(50)是操作人6OrderOperatorTimedatetime是操作日期7OrderStateint是狀態(tài)8OrderRecipientvarchar(50)是收件人9Or

18、derAddressvarchar(50)是地址10OrderRecPhonevarchar(50)是電話11OrderDeliveryManvarchar(50)是接收人12OrderRemarkvarchar(50)是備注表名：Orders_ID序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1Valuebigint是否計(jì)數(shù)器表名：Parameters序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1ParaNovarchar(20)是否編號(hào)2ParaNamevarchar(50)是名稱3ParaValuevarchar(50)是值4ParaRemarkvarchar(50)是

19、備注表名：Reportcategory序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1IDint是否編號(hào)2RpCodevarchar(20)是編碼3RpNamevarchar(50)是名稱4RpParentCodevarchar(20)是父編碼5RpPyvarchar(50)是拼音6RpWbvarchar(50)是五筆7RpQzvarchar(50)是報(bào)表前綴?表名：Reports序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1IDint是否編號(hào)2RCodevarchar(30)是編碼3RNamevarchar(100)是名稱4RCCodevarchar(20)是分類編碼5RC

20、Statevarchar(20)是分類狀態(tài)6RCreateTimedatetime是創(chuàng)建時(shí)間7RLiuShuiHaovarchar(100)是流水號(hào)8RBytesvarbinary(MAX)是大小9RYongTuvarchar(300)是用途10RConfigvarbinary(MAX)是配置11RWindowvarchar(50)是窗體名稱12REventvarchar(50)是事件名稱表名：Reports ID序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1Valuebigint是否計(jì)數(shù)器表名：Suppliers序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1SupplierNovarchar(20)是否編號(hào)2SupplierNamevarchar(50)是供應(yīng)商名稱3SupplierTelphonevarchar(50)是電話4SupplierAddressvarchar(50)是地址5SupplierLinkmanvarchar(20)是聯(lián)系人6SupplierWbvarchar(20)是五筆7SupplierPyvarchar(20)是拼音8SupplierRemarkvarchar(50)是備注表名：Users序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1