《夜猫商务会所运营管理平台数据库结构说明书要点》由会员分享,可在线阅读,更多相关《夜猫商务会所运营管理平台数据库结构说明书要点(13页珍藏版)》请在金锄头文库上搜索。
1、夜猫商务会所运营管理平台数据库结构说明书文件状态: 草稿V正式发布 正在修改文件标识当前版本1.0.0作 者r宇祥科技完成日期2014-08-25目录1. 版本历史 32. 逻辑设计 41.版本历史版本/状态修订人修改日期备注1.0.0宇祥科 技2014-08-25创建文档2.逻辑设计数据库物理结构图DepartmentsDepidDepNameCardsC CardIDParametersP ParaNoUpDepidDepPyDepWbReMarkVisits父 VisitNoCardidUseridCardSendDateCardValidDateCardPwdCardBalancePa
2、raValueParaRemarkVisitTimeCardStateVisitFeedbackCardDepositCardSendUserCardOperTimei卜VisitRemarkWorkUnitsU UnitNoUsersUnitNameUseridUserNameCardRemarkUnitPyUnitWbUnitTelphoneUnitPersonCountUserPyUserWbUserPwdUserRoleDepidUserRemarkHeadSculptureCardRecords g idCardiDTradingTypeTradingMoney81MembersR
3、MemberNoMemberFamilyName8 3UnitPostUnitAddressReMarkTradingDateSerialNumberMemberGenderMemBerBirthdayCategoriesMemberMobileMemberLevelCatidMemberUnitNoCatCodeDeliveriesD* DeliveryNoOrderNoUseridDeliveryTimeDeliveryAddressDeliverySignInDeliverySignTimeDeliveryStateDeliveryRemarkderDetailsOrderDetailN
4、oOrderNoGoodNoCategoryNameSupplierNameOrderDetailGoodName3-CatNameParentCatCodeCatCodeLevelCatCodeStateCatCodePyCatCodeWbRemarkOr flAGoodsG GoodidGoodCategoryGoodBarGoodStandardGoodNamecGoodAlcoholicOrderDetailBarOrderDetailStandardGoodNetcontentGoodPriceGoodVipPriceOrderDetails_IDV ValueOrderDetail
5、QuantityOrderDetailPriceGoodintegralrJ(OrderDetailVipPriceOrderDetailAlcoholicGoodSupplierOrdersO OrderNo!Goods_IDOrderMemberNoOrderJineOrderintegralOrderDetailNetcontentOrderDetailintegralOrderDetailSumSuppliersS SupplierNo9valueSupplierNameOrderOperatorSupplierTelphoneOrderOperatorTimeOrderStateOr
6、derRecipientReports t ID*SupplierAddressSupplierLinkmaneVisits_IDValueSupplierWbOrderAddress.RCodeRNameRCCodeReports_IDValueReportcategoryMembers IDflidRCStatevalueRCreateTimeRpCodeRpNameRLiuShuiHaoRpParentCodeRpPyRpWb3RBytesRYongTuRConfigRWindowValueOrders_IDV ValueRpQzLREvent表设计:表名功能说明1、CardRecord
7、s会员 卡充值记录表2、Cards会员卡表3、Categories商品分类表4、Deliveries配送信息表5、Deliveries_ID配送信息序号表6、Departments部门表7、Goods商品表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、Us
8、ers用户表20、Visits拜访记录表21、Visits_ID拜访记录编号表22、WorkUnits配送表表详细设计:表名:CardRecords序号列名数据类型长度小数位标识主键外键允许空默认值说明1Idint是否编号2CardIDvarchar(20)是卡编号3TradingTypeint是交易类型4TradingMoneydecimal(18,4)是交易金额5TradingDatedatetime是交易时间6SerialNumbervarchar(200)是序列号表名:Cards序号列名数据类型长度小数位标识主键外键允许空默认值说明1CardIDvarchar(20)是否编号2Memb
9、erNovarchar(20)是会员编号3CardSendDatedatetime是发卡日期4CardValidDatedatetime是有效日期5CardPwdvarchar(50)是密码6CardBalancedecimal(18,4)是金额7CardStateint是状态8CardDepositdecimal(18,4)是消费金额9CardSendUservarchar(20)是发卡人10CardOperTimedatetime是开卡日期11CardSerialNumbervarchar(200)是卡序列号12CardRemarkvarchar(500)是备注表名:Categories序号列名数据类型长度小数位标识主键外键允许空默认值说明1CatIdint40是否编号2CatCodevarchar(20)500是类别编号3CatNamevarchar(50)40是类别名称5ParentCatCodevarchar(20)40是