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