CAFE24
Tables (5)
cafe24_token (카페24 토큰)
- access_token (Key) — VARCHAR(40) — Primary key — NOT NULL
- expires_at (Field) — TIMESTAMP
- refresh_token (Field2) — VARCHAR(40)
- refresh_token_expires_at (Field3) — TIMESTAMP
- issued_at (Field4) — TIMESTAMP
- shop_name (Key2) — VARCHAR(60) — Foreign key → shop.shop_name — NOT NULL
product (상품)
- seq (Key) — int — Primary key — NOT NULL
- product_no (Field) — VARCHAR(40)
- register_date (Field2) — TIMESTAMP
- product_code (Field3) — VARCHAR(20)
- shop_name (Key2) — VARCHAR(60) — Foreign key → shop.shop_name — NOT NULL
product_size (상품사이즈)
- size (Field) — VARCHAR(20)
- shoulder (Field2) — float
- arm (Field3) — float
- bust_round (Field4) — float
- waist_round (Field5) — float
- hip_round (Field6) — float
- length (Field7) — float
- seq (Key) — int — Foreign key → product.seq — NOT NULL
shop (쇼핑몰)
- shop_name (Key) — VARCHAR(60) — Primary key — NOT NULL
- activate (Field) — tinyint
- order_id (Field2) — VARCHAR(30)
- script_id (Field3) — VARCHAR(50)
- register_date (Field4) — TIMESTAMP
- initial (Field5) — tinyint
- uninstalled (Field6) — tinyint
- install_date (Field7) — TIMESTAMP
user_size (쇼핑몰 소비자 신체사이즈)
- seq (Key) — int — Primary key — NOT NULL
- height (Field) — tinyint
- 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
- calf (Field10) — float
- shop_name (Key2) — VARCHAR(60) — Foreign key → shop.shop_name — NOT NULL