과제

테이블 (15)

APP_USER

  • ID — BIGINT — 기본 키 — NOT NULL
  • USERNAME — VACHAR(255)
  • PASSWORD — VACHAR(255)

CART_ITEM

  • ID — BIGINT — 기본 키 — NOT NULL
  • QUANTITY — INTEGER — NOT NULL
  • Key (PRODUCT_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

FULFILLMENTS

  • ID — BIGINT — 기본 키 — NOT NULL
  • FULFILLMENT_DATE — TIMESTAMP(6)
  • QUANTITY — INT
  • STATUS — ENUM
  • TYPE — ENUM
  • Key (ORDER_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (PRODUCT_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (WAREHOUSE_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

MEMBERSHIPS

  • ID — BIGINT — 기본 키 — NOT NULL
  • BENEFITS — VACHAR(255)
  • DURATION_IN_MONTHS — INTEGER
  • END_DATE — DATE
  • GRADE — ENUM
  • START_DATE — ENUM
  • TYPE — VARCHAR(255)
  • USER_ID — BIGINT — 외래 키 → APP_USER.ID — NOT NULL

USER_ROLES

  • ID (USER_ID) — BIGINT — 외래 키 → APP_USER.ID — NOT NULL
  • ROLES — VACHAR(255)

Untitled (ORDER_ITEMS)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (PRICE) — FLOAT(53)
  • Field (QUANTITY) — INTEGER
  • Key (ORDER_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (PRODUCT_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (SELLER_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (ORDER_STATUS_2)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR(255)

Untitled (ORDERS)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (CITY) — VACHAR(255)
  • Field (COUNTRY) — VACHAR(255)
  • Field (STATE) — VACHAR(255)
  • Field (STREET) — VACHAR(255)
  • Field (ZIP_CODE) — VACHAR(255)
  • Field (ORDER_DATE) — TIMESTAMP(6)
  • Field (STATUS) — ENUM
  • Field (TOTAL_AMOUNT) — FLOAT(53)
  • ID (USER_ID) — BIGINT — 외래 키 → APP_USER.ID — NOT NULL

Untitled (PAYMENT)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field2 (AMOUNT) — FLOAT(53)
  • Field3 (EXTERNAL_TRANSACTION_ID) — VARCHAR(255)
  • Field4 (PAYMENT_DATE) — TIMESTAMP(6)
  • Field2 (PAYMENT_METHOD) — VARCHAR(255)
  • Field2 (PROVIDER) — VARCHAR(255)
  • Field2 (STATUS) — ENUM
  • Field2 (TRANSACTION_ID) — VARCHAR(255)
  • Key (ORDER_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRODUCT)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (DESCRIPTION) — VARCHAR(255)
  • Field2 (IMAGE_URL) — VARCHAR(255)
  • Field3 (NAME) — VARCHAR(255)
  • Field (PRICE) — FLOAT(53)
  • Field (PRODUCT_CATEGORY) — VARCHAR(255)
  • Field (QTY) — INTEGER
  • Field (VENDOR_CODE) — VARCHAR(255)

Untitled (PROMOTION)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (AFFECT_RANGE) — VACHAR(255)
  • Field2 (DISCOUNT_RATE) — FLOAT(53)
  • Field3 (PROMOTION_DESCRIPTION) — VACHAR(255)
  • Field4 (PROMOTION_END_DT) — TIMESTAMP(6)
  • Field5 (PROMOTION_NAME) — VACHAR(255)
  • Field (PROMOTION_START_DT) — TIMESTAMP(6)
  • Field (PROMOTION_TYPE) — ENUM

Untitled (SELLER)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (CATEGORY) — VARCHAR(255)
  • Field (MARGIN) — FLOAT(53)
  • Field (POLICY) — VARCHAT(255)
  • Field (SELLER_GRADE) — ENUM
  • Field (SELLER_NAME) — VARCHAR(255)

Untitled (SHIPPING_INFO)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Key (ORDER_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ORDER_ITEM_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (SHIPPING_STATUS) — ENUM

Untitled (STOCKS)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (QUANTITY) — INTEGER
  • Key (PRODUCT_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (WAREHOUSE_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (WAREHOUSE)

  • Key (ID) — BIGINT — 기본 키 — NOT NULL
  • Field (LOCATION) — VARCHAR(255)
  • Field (NAME) — VARCHAR(255)