SOONEBO
Tables (4)
option
- id — INT — Primary key — NOT NULL
- value — VARCHAR(100)
- price — INT
- isDelete — BOOLEAN
optionList
- id — INT — Primary key — NOT NULL
- ProductId — INT — Foreign key → product.id — NOT NULL
- OptionId — INT — Foreign key → option.id — NOT NULL
product (Product)
- id — INT — Primary key — NOT NULL
- title — VARCHAR(300)
- thumbnail — VARCHAR(600)
- price — INT
- description — VARCHAR(2000)
- deliveryPrice — INT
- descImage — VARCHAR
- isDelete — BOOLEAN
- ProductTypeId — INT — Foreign key → productType.id — NOT NULL
productType
- id — INT — Primary key — NOT NULL
- value — VARCHAR(100)
- isDelete — BOOLEAN