ShoesCase Shop

Tables (13)

Account

  • AccountId (Key) — long — Primary key — NOT NULL
  • LoginDate (Field) — dateTime
  • LogoutDate (Field2) — dateTime
  • LoginId (Field3) — string
  • LoginPassword (Field4) — string
  • TermsVersion (Field5) — number
  • TermsAgreeDate (Field6) — dateTime
  • CreateDate (Field7) — dateTime
  • UpdateDate (Field8) — dateTime
  • DeleteDate (Field9) — dateTime
  • Name (Field10) — string
  • Phone (Field11) — string
  • Email (Field12) — string
  • Address (Field13) — string
  • Sex (Field14) — char
  • Birthday (Field15) — string

AdminAccount

  • AccountId (Key) — long — Primary key — NOT NULL
  • ManagerId (Field2) — string
  • Password (Field) — string
  • Name (Field3) — string
  • CreateDate (Field4) — dateTime
  • UpdateDate (Field5) — dateTime

BillKey

  • BillKey (Key) — long — Primary key — NOT NULL
  • IssueDate (Field) — dateTime
  • CancelDate (Field2) — dateTime
  • CreateDate (Field3) — dateTime
  • UpdateDate (Field4) — dateTime

Cancel

  • CancelId (Key) — long — Primary key — NOT NULL
  • PurchaseGoodsId (Key3) — long — Foreign key → PurchaseGoods.PurchaseGoodsId — NOT NULL
  • PurchaseBasketId (Key4) — long — Foreign key → PurchaseGoods.PurchaseBasketId — NOT NULL
  • Price (Field) — decimal
  • Resson (Field5) — string
  • Count (Field6) — number
  • CreateDate (Field7) — dateTime
  • UpdateDate (Field8) — dateTime
  • GoodsId (Field2) — long
  • BillKey (Key2) — long — Foreign key → BillKey.BillKey — NOT NULL
  • RefundType (Field4) — number
  • ItemSN (Field3) — long
  • ColorCode (Field9) — number
  • SizeCode (Field10) — number
  • ImgPath (Field11) — string

Goods

  • GoodsId (Key) — long — Primary key — NOT NULL
  • RegularPrice (Field) — decimal
  • Name (Field2) — string
  • Count (Field3) — number
  • SaleCode (Field4) — number
  • SaleState (Field5) — number
  • CreateDate (Field6) — dateTime
  • UpdateDate (Field7) — dateTime
  • VersionId (Key2) — long — Foreign key → GoodsVersion.VersionId — NOT NULL
  • ItemSN (Field8) — long
  • ImgPath (Field9) — string
  • ThumbnailPath (Field10) — string
  • ColorCode (Field11) — number
  • SizeCode (Field12) — number
  • CategoryId (Field13) — long
  • CategoryId (Key3) — long — Foreign key → GoodsCategory.CategoryId — NOT NULL

GoodsCategory

  • CategoryId (Key) — long — Primary key — NOT NULL
  • SortOrder (Field) — int
  • Name (Field2) — string
  • CreateDate (Field3) — dateTime
  • UpdateDate (Field4) — dateTime

GoodsVersion

  • VersionId (Key) — long — Primary key — NOT NULL
  • FilePath (Field) — string
  • CreateDate (Field2) — dateTime
  • UpdateDate (Field3) — dateTime

PurchaseBasket

  • PurchaseBasketId (Key) — long — Primary key — NOT NULL
  • BillKey (Key2) — long — Foreign key → BillKey.BillKey — NOT NULL
  • AccountId (Key5) — long — Foreign key → Account.AccountId — NOT NULL
  • AccountId (Key3) — long
  • TotalPrice (Field2) — decimal
  • StateCode (Field3) — int
  • OrderDate (Field4) — dateTime
  • DeliveryAddress (Field5) — string
  • CreateDate (Field6) — dateTime
  • UpdateDate (Field7) — dateTime

PurchaseGoods

  • PurchaseGoodsId (Key) — long — Primary key — NOT NULL
  • PurchaseBasketId (Key3) — long — Foreign key → PurchaseBasket.PurchaseBasketId — NOT NULL
  • BillKey (Key2) — long — Foreign key → BillKey.BillKey — NOT NULL
  • GoodsId (Key4) — long — Foreign key → Goods.GoodsId — NOT NULL
  • StateCode (Field3) — int
  • Name (Field) — string
  • Count (Field2) — number
  • Price (Field4) — decimal
  • CreateDate (Field6) — dateTime
  • UpdateDate (Field7) — dateTime
  • ItemSN (Field5) — long
  • ColorCode (Field8) — number
  • SizeCode (Field9) — number
  • ImgPath (Field10) — string

PurchasePayment

  • PurchaseBasketId (Key) — long — Foreign key → PurchaseBasket.PurchaseBasketId — NOT NULL
  • PaymentType (Field) — number
  • Price (Field2) — decimal
  • RecieverName (Field3) — string
  • RecieverPhone (Field4) — string
  • DeliveryComment (Field5) — string
  • CreateDate (Field6) — dateTime
  • UpdateDate (Field7) — dateTime

PurchaseStatistics

  • SaleDate (Key) — dateTime — Primary key — NOT NULL
  • GoodsId (Key2) — long — Primary key — NOT NULL
  • PaymentType (Key3) — number — Primary key — NOT NULL
  • SaleCount (Field) — int
  • SalePrice (Field2) — decimal

Review

  • ReviewId (Key3) — long — Primary key — NOT NULL
  • GoodsId (Key1) — long — Foreign key → Goods.GoodsId — NOT NULL
  • AccountId (Key2) — long — Foreign key → Account.AccountId — NOT NULL
  • Title (Field) — string
  • Content (Field2) — string
  • Score (Field3) — number
  • ReviewPassword (Field4) — string
  • CreateDate (Field5) — dateTime
  • UpdateDate (Field6) — dateTime

RollingBanner

  • RollingId (Key) — long — Primary key — NOT NULL
  • RollingVersion (Key2) — long — Primary key — NOT NULL
  • Name (Field) — string
  • ImgPath (Field2) — string
  • CreateDate (Field3) — dateTime
  • UpdateDate (Field4) — dateTime