some
Tables (20)
brand
- brand_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(100)
- avg_rating — DECIMAL(3, 2) — 브랜드 평균 평점
- total_review_count — INT — 총 리뷰 수
- created_at — DATETIME
- review_summary — VARCHAR(500)
- ranking — INT
- personal_color_id — BIGINT — NOT NULL
category_main
- category_main_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL — 스킨케어, 메이크업, 클렌징 등
- image_url — VARCHAR(100)
category_sub
- category_sub_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL — 토너, 에센스, 크림 등
- category_main_id — BIGINT — NOT NULL
creator
- creator_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- youtube_link — VARCHAR(500) — 유튜브 채널 링크
- trust_score — DECIMAL(5, 2) — 신뢰도 점수
- skin_type — ENUM
- personal_color — ENUM
- birth_year — YEAR
- subscriber_num — BIGINT
- ranking — INT
- skin_type_id — BIGINT — NOT NULL
- personal_color_id — BIGINT — NOT NULL
creator_review
- creator_review_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- rating — DECIMAL(2, 1) — 평점 (1~5)
- agree_count — INT — 공감 수
- disagree_count — INT — 반대 수
- created_at — DATETIME
- updated_at — DATETIME
- youtube_url — VARCHAR(200)
- creator_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
creator_skin_type
- creator_skin_type — BIGINT — Primary key — NOT NULL
- creator_id — BIGINT — NOT NULL
- skin_type_id — BIGINT — NOT NULL
creator_wishlist
- creator_wishlist_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- status — ENUM(LIKE,UNLIKE)
- creator_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
personal_color
- personal_color_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
product
- product_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- price — INT — 정가
- avg_rating — DECIMAL(3, 2)
- review_count — INT
- volume(ml) — BIGINT
- ai_summary — VARCHAR(500)
- review_summary — VARCHAR(200)
- category_sub_id — BIGINT — NOT NULL
- brand_id — BIGINT — NOT NULL
- product_image — VARCHAR(500)
product_effect
- product_effect_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- product_id — BIGINT — NOT NULL
- is_primary — BOOLEAN
product_skin_type
- product_skin_type_id — BIGINT — Primary key — NOT NULL
- skin_type_id2 — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
product_wishlist
- product_wishlist_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- status — ENUM(LIKE,UNLIKE)
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
skin_concern
- skin_concern_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL — 보습, 미백, 주름개선, 진정 등
- product_effect_id — BIGINT — NOT NULL
skin_type
- skin_type_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
user
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- birth_year — YEAR
- gender — VARCHAR(10)
- created_at — DATETIME
- updated_at — DATETIME
- skin_type — ENUM
- personal_color — ENUM
- personal_color_id — BIGINT — NOT NULL
user_creator_score
- user_trust_score_id — BIGINT — Primary key — NOT NULL
- trust_score — DECIMAL(5,1)
- similarity_score — DECIMAL(5,1)
- user_id — BIGINT — NOT NULL
- creator_id — BIGINT — NOT NULL
user_product_preference
- user_product_preference_id — BIGINT — Primary key — NOT NULL
- status — ENUM(LIKE,UNLIKE)
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
user_reaction
- user_reaction_id — BIGINT — Primary key — NOT NULL
- reaction_type — ENUM('AGREE', 'DISAGREE') — NOT NULL
- created_at — DATETIME
- comment — VARCHAR(255)
- user_id — BIGINT — NOT NULL
- creator_review_id — BIGINT — NOT NULL
user_skin_concern
- user_skin_concern_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- skin_concern_id — BIGINT — NOT NULL
user_skin_type
- user_skin_type_id — BIGINT — Primary key — NOT NULL
- skin_type_id2 — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL