kream

Tables (17)

brands

  • brand_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • logo_url — VARCHAR(1024)
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

large_categories

  • large_category_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_images

  • product_image_id — BIGINT
  • product_id — BIGINT — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

product_listings

  • product_listing_id — BIGINT
  • seller_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • price — INT — NOT NULL
  • quantity — INT — NOT NULL
  • status — ENUM('available','reserved','sold','cancelled') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_sizes

  • product_size_id — BIGINT
  • product_id — BIGINT — NOT NULL
  • size_code_id — BIGINT — NOT NULL
  • stock — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_trades

  • product_trade_id — BIGINT
  • product_listing_id — BIGINT — NOT NULL
  • buyer_id — BIGINT
  • seller_id — BIGINT
  • trade_price — INT — NOT NULL
  • trade_status — ENUM('pending','confirmed','shipped','completed','canceled','disputed') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

products

  • product_id — BIGINT
  • kor_name — VARCHAR(255) — NOT NULL
  • eng_name — VARCHAR(255)
  • price — INT — NOT NULL
  • release_date — DATE
  • model_no — VARCHAR(100)
  • brand_id — BIGINT
  • large_category_id — BIGINT
  • small_category_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

size_codes

  • size_code_id — BIGINT
  • category — ENUM('top','bottom','shoes','one_size','etc') — NOT NULL
  • size_label — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)

small_categories

  • small_category_id — BIGINT
  • large_category_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

style_comments

  • style_comment_id — BIGINT
  • style_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

style_images

  • style_image_id — BIGINT
  • style_id — BIGINT — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

style_likes

  • style_like_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • style_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — style_id)

style_products

  • style_product_id — BIGINT
  • style_id — BIGINT — NOT NULL
  • product_id — BIGINT
  • note — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • UNIQUE(style_id, — product_id)

styles

  • style_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_favorite_products

  • user_favorite_product_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — product_id)

user_favorite_styles

  • user_favorite_style_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • style_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — style_id)

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • provider — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — ENUM('male','female','other')
  • birth — DATE
  • region — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL