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