프로토타입

테이블 (9)

Untitled4

    option_settings (Untitled)

    • product_no (Key2) — int(4) — 외래 키 → products.product_no — NOT NULL
    • has_option (Field) — varchar(10)
    • option_type (Field2) — varchar(10)
    • option_list_type (Field3) — varchar(10)

    option_values (Untitled3)

    • option_value_no (Key2) — 기본 키 — NOT NULL
    • option_image_file (Field) — varchar(255)
    • option_link_image (Field2) — varchar(255)
    • option_color (Field3) — varchar(10)
    • option_text (Field4) — varchar(20)
    • value_no (Field5) — int(4)
    • additional_amount (Field6) — float
    • option_no (Key) — int(4) — 외래 키 → options.option_no — NOT NULL

    options (Untitled2)

    • option_no (Key) — int(4) — 기본 키 — NOT NULL
    • option_code (Field) — varchar(10)
    • option_name (Field2) — varchar(20)
    • product_no (Key2) — int(4) — 외래 키 → option_settings.product_no — NOT NULL

    product_sizes (상품 사이즈)

    • product_size_no (Key) — int(4) — 기본 키 — NOT NULL
    • size (Field) — int(4)
    • shoulder (Field2) — float
    • arm (Field3) — float
    • bust (Field4) — float
    • waist (Field5) — float
    • hip (Field6) — float
    • bust_round (Field7) — float
    • waist_round (Field8) — float
    • hip_round (Field9) — float
    • leg (Field10) — float
    • length (Field11) — float
    • option_no (Key2) — int(4) — 외래 키 → options.option_no — NOT NULL

    products (상품)

    • product_no (Key2) — int(4) — 기본 키 — NOT NULL
    • supplier_no (Key) — int — 외래 키 → suppliers.supplier_no — NOT NULL
    • product_code (Field) — varchar(10)
    • product_name (Field2) — varchar(100)
    • price (Field3) — int(4)
    • size (Field4) — tinyint(4)
    • detail_page_length (Field5) — tinyint(4)
    • discountRate (Field6) — float
    • buylink (Field7) — varchar(70)
    • add_Date (Field8) — timestamp
    • category (Field9) — varchar(20)
    • p_type (Field10) — varchar(20)
    • love (Field11) — int(4)
    • fitting_option (Field12) — varchar(10)
    • list_image (Field13) — varchar(200)

    shops (쇼핑몰(공급사아님))

    • shop_no (Key) — int(4) — 기본 키 — NOT NULL
    • shop_name (Field2) — varchar(255)

    suppliers (공급사)

    • supplier_no (Key) — int — 기본 키 — NOT NULL
    • supplier_code (Field2) — varchar(10)
    • supplier_name (Field) — varchar(20)
    • supplier_id (Field3) — varchar(20)
    • supplier_pw (Field4) — varchar(20)
    • phone (Field6) — varchar(20)
    • fax (Field7) — varchar(20)
    • address1 (Field8) — varchar(50)
    • address2 (Field9) — varchar(50)
    • manager_information (Field10) — varchar(200)
    • approve_status (Field5) — boolean
    • shop_no (Key2) — int(4) — 외래 키 → shops.shop_no — NOT NULL

    tokens (토큰)

    • access_token (Key) — 기본 키 — NOT NULL
    • expires_at (Field)
    • refresh_token (Field2)
    • refresh_token_expires_at (Field3)
    • client_id (Field4)
    • mall_id (Field5)
    • user_id (Field6)
    • issued_at (Field7)