BizMakes
Tables (10)
Product (PRODUCT)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (CATEGORY_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (NAME) — VARCHAR(100) — NOT NULL
- Field (DESCRIPTION) — VARCHAR(1000)
ProductOption (PRODUCT_OPTION_KEY)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
Untitled (PRODUCT_OPTION_VALUE)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (OPTION_ITEM_ID) — BIGINT — Foreign key → ProductOption.Key — NOT NULL
- Field (NAME) — VARCHAR(100)
Untitled (PRODUCT_OPTION)
- Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
- Key (OPTION_VALUE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (OPTION_COMBINATION)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
- Field (PRICE) — BIGINT — NOT NULL
- Field (ACTIVE) — CHAR(1) — NOT NULL
Untitled (PRODUCT_CATEGORY)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(50) — NOT NULL
Untitled (CART_ITEM)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
- Key (ORDER_ID) — BIGINT — Foreign key → Untitled.Key
- Key (OPTION_COMBINATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (QUANTITY) — INT — NOT NULL
- Field (STATUS) — INT — NOT NULL
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field (UPDATED_AT) — TIMESTAMP — NOT NULL
- Field (DELETED_AT) — TIMESTAMP
Untitled (ORDERS)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Field (STATUS) — INT — NOT NULL
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field2 (UPDATED_AT) — TIMESTAMP — NOT NULL
Untitled (OPTION_COMBINATION_ITEM)
- Key (OPTION_VALUE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (OPTION_COMBINATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
User (USER)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (EMAIL) — VARCHAR(320) — NOT NULL
- Key (PROVIDER) — VARCHAR(50) — NOT NULL
- Field (NAME) — VARCHAR(30) — NOT NULL
- Field (ENCODED_PASSWORD) — VARCHAR(200) — NOT NULL
- Field (PHONE_NUMBER) — VARCHAR(20)
- Field (ADDRESS) — VARCHAR(100)
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field2 (UPDATED_AT) — TIMESTAMP — NOT NULL
- Field (DELETED_AT) — TIMESTAMP