w

Tables (6)

Untitled

    option (옵션)

    • 옵션아이디 (option_id) — BIGINT — Primary key — NOT NULL
    • 옵션이름 (option_name) — VARCHAR
    • 옵션아이디 (option_id2) — BIGINT

    option_list (옵션리스트)

    • 옵션리스트아이디 (option_list_id) — INT — Primary key — NOT NULL
    • 옵션리스트이름 (Field)
    • 옵션아이디 (option_id) — BIGINT
    • 상품아이디 (product_id) — BIGINT — Foreign key → product.상품아이디 — NOT NULL
    • 옵션아이디 (option_id2) — BIGINT — Foreign key → option.옵션아이디 — NOT NULL

    product (상품)

    • 상품아이디 (product_id) — BIGINT — Primary key — NOT NULL
    • 상품이름 (product_name) — VARCHAR
    • 상품가격 (product_price) — INT
    • 상품코드 (product_code) — VARCHAR
    • 상품상세 (product_des) — VARCHAR

    product_list (Untitled4)

    • Key (id) — BIGINT — Primary key — NOT NULL
    • 상품아이디 (product_id) — BIGINT
    • 옵션리스트아이디 (option_list_id) — INT
    • Field

    product_option_list (옵션별 상품관리)

    • id (Key) — Primary key — NOT NULL
    • Field
    • 옵션리스트아이디 (option_list_id) — INT — Foreign key → option_list.옵션리스트아이디 — NOT NULL