商品銷(xiāo)售管理系統(tǒng)課程設(shè)計(jì)-資料下載頁(yè)
2025-04-07 23:05本頁(yè)面
【正文】 null會(huì)員卡號(hào)TotalCostMoney4Not null累積消費(fèi)金額RegDateDatetime8Not null注冊(cè)日期銷(xiāo)售表(Sale)字段名字段類(lèi)型長(zhǎng)度主/外鍵字段值約束對(duì)應(yīng)中文名SaleIDVarchar10PNot null銷(xiāo)售編號(hào)MerChIDVarchar10FNot null商品編號(hào)SaleDateDatetime8Not null銷(xiāo)售日期SaleNumInt4Not null銷(xiāo)售數(shù)量SalePriceMoney4Not null銷(xiāo)售單額交易表(Dealing)字段名字段類(lèi)型長(zhǎng)度主/外鍵字段值約束對(duì)應(yīng)中文名DealingIDVarchar10PNot null交易編號(hào)DealingPriceMoney4Not null交易金額DealingDateMoney4Not null交易日期MemberIDVarchar10會(huì)員卡號(hào)UserNameVarchar10FNot null用戶(hù)名稱(chēng)入庫(kù)紀(jì)錄表(Stock)字段名字段類(lèi)型長(zhǎng)度主/外鍵字段值約束對(duì)應(yīng)中文名StockIDVarchar10PNot null入庫(kù)編號(hào)MerchIDVarchar10FNot null入庫(kù)商品編號(hào)MerchNumInt4Not null入庫(kù)數(shù)量MerchPriceMoney4Not null單額TotalPriceMoney4Not null總額StockDateDatetime8Datetime入庫(kù)日期PlanDateDatetime8Datetime計(jì)劃進(jìn)貨日期StockStateInt4Not null入庫(kù)狀態(tài)供貨商表(Provide)字段名字段類(lèi)型長(zhǎng)度主/外鍵字段值約束對(duì)應(yīng)中文名ProvideIDvarchar10PNot null供貨商編號(hào)ProvideNameVarchar50Not null供貨商名稱(chēng)ProvideAddressVarchar250供貨商地址ProvidePhoneVarchar25供貨商電話(huà)廠(chǎng)商表(Provide)字段名字段類(lèi)型長(zhǎng)度主/外鍵字段值約束對(duì)應(yīng)中文名FactoryIDvarchar10PNot null廠(chǎng)商編號(hào)FactoryNameVarchar50Not null廠(chǎng)商名稱(chēng)FactoryAddressVarchar250廠(chǎng)商地址FactoryPhoneVarchar25廠(chǎng)商電話(huà)15 / 15
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1