Shop
Tables (18)
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
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
CancelItem
- CancelId (Key2) — long — Foreign key → Cancel.CancelId — NOT NULL
- ItemSN (Field) — long
- ColorCode (Field2) — number
- SizeCode (Field3) — number
- ImgPath (Field4) — string
- CreateDate (Field5) — dateTime
- UpdateDate (Field6) — dateTime
Goods
- GoodsId (Key) — long — Primary key — NOT NULL
- RegularPrice (Field) — decimal
- GoodsName (Field2) — string
- Description (Field3) — string
- SaleCode (Field4) — number
- SaleState (Field5) — number
- CreateDate (Field6) — dateTime
- UpdateDate (Field7) — dateTime
- VersionId (Key2) — long — Foreign key → GoodsVersion.VersionId — NOT NULL
GoodsCategory
- CategoryId (Key) — long — Primary key — NOT NULL
- SortOrder (Field) — int
- CategoryName (Field2) — string
- CreateDate (Field3) — dateTime
- UpdateDate (Field4) — dateTime
GoodsCategoryMap
- GoodsId (Key) — long — Foreign key → Goods.GoodsId — NOT NULL
- CategoryId (Key2) — long — Foreign key → GoodsCategory.CategoryId — NOT NULL
- CreateDate (Field) — dateTime
- UpdateDate (Field2) — dateTime
GoodsItem
- GoodsId (Key) — long — Foreign key → Goods.GoodsId — NOT NULL
- ItemSN (Field) — string
- ImgPath (Field2) — string
- ThumbnailPath (Field3) — string
- CountryOfOrigin (Field4) — string
- CreateDate (Field6) — dateTime
- UpdateDate (Field7) — 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
- 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
PurchaseGoodsItem
- PurchaseGoodsId (Key2) — long — Foreign key → PurchaseGoods.PurchaseGoodsId — NOT NULL
- ItemSN (Field) — long
- ColorCode (Field2) — number
- SizeCode (Field4) — number
- ImgPath (Field3) — string
PurchaseGoodsPayment
- 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
User
- AccountId (Key) — long — Foreign key → Account.AccountId — NOT NULL
- Name (Field) — string
- Phone (Field2) — string
- Email (Field3) — string
- Address (Field4) — string
- Sex (Field5) — char
- Birthday (Field6) — dateTime
- CreateDate (Field7) — dateTime
- UpdateDate (Field8) — dateTime