burgerqueen
Tables (9)
TB_CART
- CartId — Long — Primary key — NOT NULL
- UserId — Long — Foreign key → TB_USER.UserId — NOT NULL
- TotalCount (Field)
- TotalDiscountPrice (Field5)
- TotalPrice (Field2)
- CreatedAt (Field3)
- ModifiedAt (Field4)
TB_CARTPRODUCT (Untitled3)
- CartDetailsId (Key) — Long — Primary key — NOT NULL
- CartId — Long — Foreign key → TB_CART.CartId — NOT NULL
- ProductId — Long — Foreign key → TB_PRODUCT.ProductId — NOT NULL
- PromotionId — Long — Foreign key → TB_PRODUCT.PromotionId
- count (Field2)
TB_CATEGORY
- CategoryId — Long — Primary key — NOT NULL
- PromotionId — Long — Foreign key → TB_PROMOTIONINFO.PromotionId
- CateroryName (Name) — String
TB_DELIVERY (Untitled)
- DeliveryId (Key) — Primary key — NOT NULL
- UserIdSeq (UserId) — Long — Foreign key → TB_USER.UserId — NOT NULL
- OrderId — Foreign key → TB_ORDER.OrderId — NOT NULL
- UserIdSeq (UserId2) — Long — Foreign key → TB_ORDER.UserIdSeq — NOT NULL
- DeliveryStatus (Field)
TB_ODERPRODUCT (Untitled2)
- OrderDetailsId (Key) — Primary key — NOT NULL
- OrderId — Foreign key → TB_ORDER.OrderId — NOT NULL
- ProductId (Field)
- Count (Field2)
- Price (Field3)
- DiscountPrice (Field4)
TB_ORDER
- OrderId — Primary key — NOT NULL
- UserIdSeq (UserId) — Long — Foreign key → TB_USER.UserId — NOT NULL
- OrderStatus (Field3)
- TotalCount (Field)
- TotalDiscoutPrice (Field4)
- TotalPrice (Field2)
TB_PRODUCT
- ProductId — Long — Primary key — NOT NULL
- CategoryId — Long — Foreign key → TB_CATEGORY.CategoryId — NOT NULL
- PromotionId — Long — Foreign key → TB_CATEGORY.PromotionId
- ProductName (Name) — String
- ProductPrice (Price) — int
- ProductImage (Image) — String
- ProductDescription (Detail) — String
- ProductCount (Integer) — Integer
- ProductStatus (status) — String
TB_PROMOTIONINFO (Untitled5)
- PromotionId — Long — Primary key
- PromotionName (Field2)
- PromotionDescription (Description) — String
- DiscountType (Field6)
- Amount (Field5)
- PromotionStatus (Field3)
TB_USER
- UserId — Long — Primary key — NOT NULL
- Email (Field2)
- Password (Field3)
- UserName — String
- Phone (phone)
- Address1 (Field4)
- Address2 (Field8)
- Address3 (Field)
- Grade (Field11)
- Stamp (Field7)
- Provider (Field9)
- ProviderId (Field10)
- CreatedAt (Field5)
- ModifiedAt (Field6) — Date