과제
테이블 (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)