Coupang
Tables (11)
CLIENT (Client)
- Key (CLIENT_ID) — INT — Primary key — NOT NULL
- Field (CLIENT_NAME) — VARCHAR(20)
LARGE CATEGORY (Large Category)
- Key (LARGE_CATEGORY_ID) — INT — Primary key — NOT NULL
- Field (CATEGORY_NAME) — CHAR
MIDDLE_CATEGORY (Middle Category)
- Key (MIDDLE_CATEGORY_ID) — INT — Primary key — NOT NULL
- Key (LARGE_CATEGORY_ID) — INT — Foreign key → LARGE CATEGORY.Key — NOT NULL
- Field (CATEGORY_NAME) — CHAR
OPTION (Option)
- Key (OPTION_ID) — INT — Primary key — NOT NULL
- Key (SELLER_ID) — INT — Foreign key → SELLER.Key — NOT NULL
- Key (PRODUCT_ID) — INT — Foreign key → SELLER.Key — NOT NULL
- Field (OPTION_NAME) — VARCHAR(60)
- Field (OPTION_PRICE) — INT
ORDER (Order)
- Key (ORDER_ID) — INT — Primary key — NOT NULL
- Key (ORDER_LIST_ID) — INT — Foreign key → ORDER_LIST.Key — NOT NULL
- Key (SHIPMENT_ID) — INT — Foreign key → SHIMPMENT.Key — NOT NULL
- Key (OPTION_ID) — INT — Foreign key → OPTION.Key — NOT NULL
- Field (QUANTITY) — INT
ORDER_LIST (Order List)
- Key (ORDER_LIST_ID) — INT — Primary key — NOT NULL
- Key (CLIENT_ID) — INT — Foreign key → CLIENT.Key — NOT NULL
- Field (CREATED_AT) — DATETIME
PRODUCT (product)
- Key (PRODUCT_ID) — INT — Primary key — NOT NULL
- Key (SMALL CATEGORY_ID) — INT — Foreign key → SMALL_CATEGORY.Key — NOT NULL
- Key (MIDDLE_CATEGORY_ID) — INT — Foreign key → SMALL_CATEGORY.Key — NOT NULL
- Key (LARGE_CATEGORY_ID) — INT — Foreign key → SMALL_CATEGORY.Key — NOT NULL
REVIEW (Review)
- Key (REVIEW_ID) — INT — Primary key — NOT NULL
- Key (ORDER_ID) — INT — Foreign key → ORDER.Key — NOT NULL
- Field (TITLE) — VARCHAR(50)
- Field (BODY) — VARCHAR(500)
- Field2 (IMAGE) — VARCHAR(150)
SELLER (Seller)
- Key (SELLER_ID) — INT — Primary key — NOT NULL
- Key (PRODUCT_ID) — INT — Foreign key → PRODUCT.Key — NOT NULL
- Field (SELLER_NAME) — VARCHAR(20)
SHIMPMENT (Shipment)
- Key (SHIPMENT_ID) — INT — Primary key — NOT NULL
- Field (STATUS) — CHAR
- Field (LOCATION_NO) — INT
SMALL_CATEGORY (Small Category)
- Key (SMALL_CATEGORY_ID) — INT — Primary key — NOT NULL
- Key (MIDDLE_CATEGORY_ID) — INT — Foreign key → MIDDLE_CATEGORY.Key — NOT NULL
- Key (LARGE_CATEGORY_ID) — INT — Foreign key → MIDDLE_CATEGORY.Key — NOT NULL
- Field (CATEGORY_NAME) — CHAR