프로토타입
테이블 (9)
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)