hackday

Tables (5)

product (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • merchant (Field2) — varchar(100)
  • saleStartDate (Field3) — timestamp
  • saleEndDate (Field4) — timestamp

product_info (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • type (Field2) — varchar(100)
  • value (Field3) — longText
  • productOptionId (Key2) — int — Foreign key → product_option.id — NOT NULL

product_option (Untitled2)

  • id (Key2) — Primary key — NOT NULL
  • productId (Key) — int — Foreign key → product.id — NOT NULL
  • name (Field) — varchar(100)
  • price (Field2) — int
  • quantity (Field3) — int
  • maxShare (Field4) — int

promotion (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • startDate (Field) — timestamp
  • endDate (Field2) — timestamp
  • type (Field3) — varchar(100)
  • productOptionId (Key2) — int — Foreign key → product_option.id — NOT NULL
  • value (Field4) — varchar(100)

promotion_condition (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • promotionId (Key2) — int — Foreign key → promotion.id — NOT NULL
  • type (Field) — varchar(100)
  • value (Field2) — varchar(100)