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