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