图书系统数据库表.pdf

该【图书系统数据库表 】是由【青山代下】上传分享，文档一共【25】页，该文档可以免费在线阅读，需要了解更多关于【图书系统数据库表 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。:..注意:表结构以数据库为准一、数据表如下:系统基础表::..:..P_OperationLog数据库里没有该表编号字段中文说明类型备注是否是否为空主键1OperationID操作IDbigint是2OperationTypes操作类型varchar23UnitName单元名称varchar34Explain操作说明varchar2005Operator操作人员varchar206OperateTime操作时间datetimemon_User用户表编号字段中文说明类型备注是否是否为空主键1UserID用户代码varchar8是2Password用户密码varchar1283remark备注varchar2004Status用户状态varchar25AddDate添加日期datetime6CanSeeAllvarchar2mon_Role_User角色和用户对照表编号字段中文说明类型备注是否是否为空主键1RoleID角色代码int是2UserID用户代码varchar30是3Com_UserID用户表_用户代码varchar8mon_Role角色表编号字段中文说明类型备注是否是否为空主键1RoleID角色代码int是2RoleName角色名称varchar303SysFlag系统标志tinyint4Remark备注varchar2005AddDate添加日期datetimemon_Role_Operate操作和角色对照表编号字段中文说明类型备注是否是否为空主键1RoleID角色代码int是2OperateID操作代码varchar32是:..:15、Qry_Types查询类型编号字段中文说明类型备注是否是否为空主键1QueryTypeID类型编码varchar30是2QueryTypeName类型名称varchar3216、Qry_HeaderList查询的表头列表编号字段中文说明类型备注是否是否为空主键1StatementID查询语句编号int是2FieldID字段varchar40是3FieldWidth字段宽度int4FieldOrder字段顺序tinyint5FieldVisible字段是否显示tinyint:..Qry_AllFields字段信息表编号字段中文说明类型备注是否是否为空主键1FieldID字段varchar40是2FieldName字段中文名称varchar403FieldType字段类型char14CodeType对应的编码类型int5PrimaryFlag是否主键tinyint6Condition对应条件varchar160018、Qry_Statements查询语句列表编号字段中文说明类型备注是否是否为空主键1StatementID查询语句编号int是2TypeID所属查询类型varchar303StatementName查询语句名称varchar304ParentStatementID上级查询语句int5SqlStatement查询语句text6MainTable主表名称varchar307Primarykey主键名称varchar1008ProcessType是否分页检索tinyint9PageField分页字段名称varchar6010OrderID排列顺序smallint11ExecuteFlag是否执行tinyint12IsSumSQL是否汇总查询tinyint13DelFlagValue对应DelFlag值int14RecycleFlag是否用于回收站tinyint15ExpandLevel可展开的层次tinyint16Remark备注varchar60019、Qry_ClassifyStat分类统计表编号字段中文说明类型备注是是否否为主键空1StatementID查询语句编号int是2ClassifyTableID分类表编号int是3TableName表名称varchar324PrimaryKey关键字段varchar325TargetField关联目标字段varchar326ExpandLevel展开层次int7Operate比较运算符varchar328SubCondtion附加条件varchar3009ShowField显示字段varchar32不在数据库里:..TableName22varchar32不在数据库里11PrimaryKey2关键字段2varchar32不在数据库里12TargetField2关联目标字段2varchar32不在数据库里13ShowField2显示字段2varchar32不在数据库里14SubCondition2附加条件2varchar300不在数据库里20、Qry_Conditions存储的查询条件编号字段中文说明类型备注是否是否为空主键1ConditionID存储查询条件编号int是2StatementID查询语句编号int是3Name查询条件名称varchar304Condition查询条件varchar60005UserID对应用户varchar206IsDefault是否默认查询tinyint7ConditionOrder顺序smallint8Remark备注varchar20021、Qry_FieldsList开放的查询字段编号字段中文说明类型备注是否是否为空主键1StatementID查询语句编号int是2FieldID字段varchar60是3FieldOrder字段顺序int主要业务表:22、U_Register用户注册信息编号字段中文说明类型备注是否是否为空主键1UserID用户IDuniqueidentifier是2UserNumber用户代码varchar303UserName用户名称varchar604ShortName简称varchar305AreaCode所在地varchar96Address详细地址varchar307ZipCode邮政编码varchar88Phone联系varchar309Fax传真号码varchar2010ContactMan联系人varchar2011EMailEMailvarchar3012BankName开户银行varchar60ountNumber银行帐号varchar3214TaxNumber增值税发票账号varchar30:..TaxAddressvarchar6016TaxBank增值税发开户行varchar6017SizeCode单位规模char218RegisterDate注册日期datetime23、pany出版社信息出版社基础信息编号字段中文说明类型备注是否是否为空主键1PubID出版社IDint是2PubNumber出版社代码varchar303PubName名称varchar604ShortName简称varchar305PrivateCode自编码varchar306AreaCode所属省市varchar97Address地址varchar458ZipCode邮编varchar309Phonevarchar3010WebAddress网址varchar6011EMailEMailvarchar3012ContactMan联系人varchar3013Operator操作员varchar1614Remark备注varchar10015AddDate添加日期datetime16DelFlag删除标记int17ChFlag修改标记int18TransFlag传输标记int24、U_RequestOrder我的征订单数据库里没有该表编号字段中文说明类型备注是否是否为空主键1CustomerID客户IDint是2RequestNumber征订单号varchar163BookNumber书号varchar304RequestDate征订日期datetime5Price定价money6SaleRebate销售折扣float7BookCount征订样本量int8AddDate添加日期datetime9Remark备注varchar5010DelFlag删除标记Int11ChFlag修改标记int12TransFlag传输标记inr:..B_Books图书信息编号字段中文说明类型备注是否是否为空主键1BookNumber书号int是2BookGUID图书GUIDuniqueidentifier3ISBNISBN号varchar204BookName书名varchar605PrivateCode自编码varchar606PubID出版社IDint7BookTypeCode类别varchar28Author作者varchar309Translator译者varchar3010EditionOrder版次varchar3011PageStyleCode版别varchar212PageCount页码int13Price定价int14BatchRebate批销折扣int15RetailRebate零售折扣int16MaxValue库存上限int17MinValue库存下限int18StatusCode销售状态varchar219ProviderID供应商IDintessaryCode附件varchar221AmountInPackage每包册数int22PublishYear出版年份int23Operator操作员varchar1624AddDate添加日期datetime25Remark备注varchar5026OrderID排序号int自增27DelFlag删除标记int28ChFlag修改标记int29TransFlag传输标记int30SourceNumber源书号int31SourceID源IDint26、B_BookTypes图书类型表编号字段中文说明类型备注是否是否为空主键1TypesID类型IDint是2TypesName类型名称varchar163ParentTypes上级类型varchar304VisibleCode是否可见datetime5OrderID显示预号money:..IsSysFlagfloat7AddDate添加日期int8Remark备注varchar509DelFlag删除标记int10ChFlag修改标记Int11TransFlag传输标记int27、M_LevelRebate会员级别对应折扣表编中文说明字段类型备注是否为空是否主键号1MemberLevel会员级别varchar2是2RetailRebate对应折扣int3IsValid是否有效varchar24Operator操作员varchar165AddDate添加日期datetime6Remark备注varchar507DelFlag删除标记int8ChFlag修改标记int9TransFlag传输标记int28、M_MemberBuyDetail会员购书记录编号字段中文说明类型备注是否是否为空主键1MemberID会员IDint2RetailNumber零售单号varchar163TransFlag删除标记int4Delflag修改标记int5SynchFlag传输标记int29、M_Member会员信息表编号字段中文说明类型备注是否是否为空主键1BarCode条形码varchar13是2MName会员名varchar303SexCode性别char24BirthDate出生日期datetime5Address住址varchar306Phone联系varchar207EduGradeCode学历char28WorkPlaceCode工作单位char29MLevelCode会员级别char210MTax会费moneyumulate积分int:..ValidDatedatetime13MStatusCode会员状态char214JoinDate入会日期datetime15AddDate添加日期datetime16Remark备注varchar5017DelFlag删除标记int18ChFlag修改标记int19TransFlag传输标记int20MemberID会员IDint21MNumber会员编码varchar1630、B_Retail零售记录表编号字段中文说明类型备注是否是否为空主键1RetailNumber零售单号varchar16是2SaleCount销售总数int3FixedMoney总码注money4DiscountedMoney总实洋money5ReceivableMoney应收金额money6ComeToHandMoney接手金额money7OddMoney找零money8ChargeMoney实收金额money9Collector收费员varchar810RetailDate销售日期datetime11StateCode本单状态varchar212TotalCount本单数量int13IsMember是否会员varchar214AddDate添加日期datetime15Remark备注varchar5016DelFlag删除标记int17ChFlag修改标记int18TransFlag传输标记int19SourceID源IDint20SourceNumber源单号varchar1631、B_RetailDetail零售明细编号字段中文说明类型备注是否是否为空主键1RetailNumber零售单号varchar16是2BookNumber书号int是3IDIDint是4BCount数量int5FixedPrice码洋money:..RetailRebateint7DiscountedPrice实洋money8Collector收费员varchar89Remark备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int32、B_OddOrderForm散客户订单表编号字段中文说明类型备注是否是否为空主键1OrderNumber订单号varchar16是2BookNumber书号int是3BookName书名varchar30为什么要书名4PubID出版社IDint5PubName出版社名称varchar306CName客户姓名varchar307SexCode性别char28Phone联系varchar169EMailEMailvarchar3010BCount订数int11ValidDate有效日期datetime12Operator操作员varchar813AddDate添加日期datetime14Remark备注varchar5015DelFlag删除标记int16ChFlag修改标记int17TransFlag传输标记int18SourceNumber源单号varchar1619SourceID源IDint33、P_Provider供应商信息编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDint是2ProviderGUID供应商GUIDuniqueidentifier3ProviderName供应商名称varchar604ShortName供应商简称varchar305PrivateCode自编码varchar306AreaCode所属区域varchar97Address详细地址varchar608ZipCode邮政编码varchar89Phone联系varchar20:..MobiPhonevarchar1611Faxvarchar2012WebAddress网址varchar6013EMail电子varchar3014ContactMan联系人varchar3015BankName开户银行varchar60ountNumber银行账号varchar2017TaxNumber税号varchar2018PreBalance预付余额money19SendBackRate允许退书率int20Station铁路到站varchar2021Operator操作员varchar1622AddDate添加日期datetime23Remark备注varchar5024DelFlag删除标记int25ChFlag修改标记int26TransFlag传输标记int27SourcePID源供应商IDint28SourceID源IDint29Global_ID30SynchFlag31没有找完3234、P_RequestOrder供应商征订单编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDint是2RequestNumber征订单号varchar16是3BookName书名varchar604PubID出版社int5PrivateCode自编码varchar606BookTypeCode所属类别char27Author作者varchar308Translator译者varchar309EditionOrder版次varchar3010Price定价money11BookCount征订样本量int12AddDate添加日期datetime13Remark备注varchar5014DelFlag删除标记int15ChFlag修改标记int16TransFlag传输标记int:..SourceNumbervarchar1618SourceID源IDint35、ount付款对账单编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDintountNumber对帐单号varchar16是3GenerateDate生成日期datetime4StartDate开始日期datetime5EndDate结束日期datetime6BalanceCode结算情况varchar27AddDate添加日期datetime8Remark备注varchar509Operator操作员varchar1610DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int13SourceNumber源单号varchar1614SourceID源IDint36、P_Payment付款表编号字段中文说明类型备注是否是否为空主键1PaymentNumber付款单号varchar16是ountNumber对帐单号varchar16是3ShouldPayMoney应付金额money4PreBalanceMoney上次余额money5CurrBalanceMoney当前余额money6GetBalanceMoney本次取余money7PayMoney付款金额money8PayDate付款日期datetime9Payer付款人varchar1610PayModeCode付款方式varchar211CheckStateCode审核状态varchar212AddDate添加日期datetime13Remark备注varchar5014Operator操作员varchar1615DelFlag删除标记int16ChFlag修改标记int17TransFlag传输标记int该表多字段18SourceNumber源单号varchar1619SourceID源IDint:..P_PrePayment预付款表编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDint是2PrePaymentNumber付款单号varchar163PrePayDate付款日期datetime4PrePayMoney付款金额money5Payer付款人varchar166PrePayModeCode付款方式varchar27CheckStateCode审核状态varchar28AddDate添加日期datetime9Remark备注varchar5010Operator操作员varchar1611DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int14SourceNumber源单号varchar1615SourceID源IDint38、U_SendBack我的退书单SBTypesCode退货类型默认值为“01”滞销,当SBTypesCode为“02”调拔时,在字段Remark中填写收货人信息编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDint是2SendBackNumber退货单号varchar163SendBackDate退货日期datetime4SBTypesCode退货类型varchar25CarryModeCode发货方式char26TotalCount退书数量int7Operator操作员varchar168CheckStateCode审核状态varchar29AddDate添加日期datetime10Remark备注varchar5011DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int14SourceNumber源单号varchar1615SourceID源IDint:..U_SendBackDetail我的退书单明细编号字段中文说明类型备注是否是否为空主键1SendBackNumber退货单号varchar16是2BookNumber书号int3IDIDint4SBCount数量int5FixedPrice码洋money6SBRebate退货折扣int7DiscountedPrice实洋money8Operator操作员varchar169Remark备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int40、B_ProviderBooks供应商图书对应表编号字段中文说明类型备注是否是否为空主键1ProviderID供应商IDint是2BookNumber图书代码int3ProviderGUID供应商GUIDuniqueidentifier4ISBN图书ISBNvarchar205IsMostly是否主供应商varchar241、U_Stock进货记录表进货类型StockTypesCode默认为“01”采购,如是进货类型为“调拔”02,那么须在备注Remark中写入调入者的名称编号字段中文说明类型备注是否是否为空主键1StockNumber进货单号varchar16是2ProviderID供应商IDint3ProviderSNumber对方单号varchar164StockDate进货日期datetime5StockTypesCode进货类型varchar26ReturnDays退货天数int7StockModeCode购货方式varchar28PaymentStateCode付款情况varchar29CarryModeCode发货方式varchar210AllowSendBackCode是否允许退货varchar211CheckStateCode审核状态varchar212PlusMoney附加费money13TotalCount进货总数int:..TotalFixedPricemoney15TotalDiscountedPrice总实洋money16AverageRebate平均折扣float17StateCode单据状态varchar200录入和没有确认的01正常02作废18Operator操作员varchar1619AddDate添加日期dat