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)