somsay
Tables (24)
brands
- brand_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- brand_name — VARCHAR(255) — NOT NULL
- brand_logo_key — VARCHAR(255) — S3 key
- brand_img_key — VARCHAR(255) — S3 key
- avg_rating — DOUBLE — NOT NULL — 브랜드 평균 평점
- total_review_count — INT — 총 리뷰 수
- created_at — DATETIME
- updated_at — DATETIME
creator_reviews
- creator_review_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- content — TEXT
- rating — DOUBLE — 평점 (1~5)
- agree_count — INT — 공감 수
- disagree_count — INT — 비공감 수
- youtube_url — VARCHAR(200)
- video_title — VARCHAR(200)
- upload_at — DATETIME — 영상 업로드 시각
- view_count — BIGINT — 영상 조회수
- creator_id — BIGINT — Foreign key → creators.creator_id
- product_id — BIGINT — Foreign key → products.product_id
- created_at — DATETIME
- updated_at — DATETIME
creator_skin_type
- creator_skin_type_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- creator_id — BIGINT — Foreign key → creators.creator_id
- skin_type_id — BIGINT — Foreign key → skin_types.skin_type_id
- created_at — DATETIME
- updated_at — DATETIME
creator_wishlists
- creator_wishlist_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- status — ENUM('LIKE', 'NONE')
- deleted_at — DATETIME — soft delete
- user_id — BIGINT — Foreign key → users.user_id
- creator_id — BIGINT — Foreign key → creators.creator_id
- created_at — DATETIME
- updated_at — DATETIME
creators
- creator_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- creator_name — VARCHAR(255)
- profile_img_url — VARCHAR(255)
- youtube_link — VARCHAR(255) — 유튜브 채널 링크
- trust_score — DOUBLE — 신뢰도 점수
- subscriber_num — INT — NOT NULL — 구독자 수
- ranking — INT
- old_ranking — INT — 변동 전 순위
- birth_date — DATE
- personal_color — ENUM('COOL', 'WARM')
- created_at — DATETIME
- updated_at — DATETIME
hot_score_state
- id — BIGINT — Primary key — NOT NULL — 단일 행 고정(id=1)
- matured — BOOLEAN — NOT NULL — 핫스코어 λ 성숙 전환 여부
main_categories
- main_category_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- main_category_name — VARCHAR(255) — 스킨케어, 클렌징, 마스크/팩 등
- category_img_key — VARCHAR(255) — S3 key
- created_at — DATETIME
- updated_at — DATETIME
product_skin_expectation
- product_skin_expectation_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- is_primary_effect — BOOLEAN — 대표 효과 여부
- product_id — BIGINT — Foreign key → products.product_id
- skin_expectation_id — BIGINT — Foreign key → skin_expectations.skin_expectation_id
- created_at — DATETIME
- updated_at — DATETIME
product_skin_type
- product_skin_type_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- product_id — BIGINT — Foreign key → products.product_id
- skin_type_id — BIGINT — Foreign key → skin_types.skin_type_id
- created_at — DATETIME
- updated_at — DATETIME
product_wishlists
- product_wishlist_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- status — ENUM('LIKE', 'NONE')
- deleted_at — DATETIME — soft delete
- user_id — BIGINT — Foreign key → users.user_id
- product_id — BIGINT — Foreign key → products.product_id
- created_at — DATETIME
- updated_at — DATETIME
products
- product_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- product_name — VARCHAR(255) — NOT NULL
- price — INT — 정가
- avg_rating — DOUBLE
- user_review_count — INT — 평가 참여 유저 수(중복 제외)
- creator_review_count — INT — 평가 참여 크리에이터 수(중복 제외)
- volume — VARCHAR(255) — 용량
- ai_summary — TEXT — 종합 평가
- short_summary — VARCHAR(255) — 한 줄 요약
- frequent_mention — VARCHAR(255) — 자주 언급되는 점
- consideration — VARCHAR(255) — 참고할 점
- product_img_key — VARCHAR(255) — S3 key
- rec_score — DOUBLE — 추천 점수
- collab_channel_id — VARCHAR(255) — 콜라보 유튜버 채널 id
- collab_channel_name — VARCHAR(255) — 콜라보 유튜버 채널명
- collab_profile_img_url — VARCHAR(255) — 콜라보 유튜버 채널 프로필
- product_notes — VARCHAR(200) — 상품 상세 설명
- brand_id — BIGINT — Foreign key → brands.brand_id — NOT NULL
- sub_category_id — BIGINT — Foreign key → sub_categories.sub_category_id
- created_at — DATETIME
- updated_at — DATETIME
review_attributes
- attribute_id — BIGINT — Primary key — NOT NULL — 기본키
- skin_expectation_id — BIGINT — Foreign key → skin_expectations.skin_expectation_id — NOT NULL — PK, auto increment
- label — VARCHAR(50) — NOT NULL — 칩 노출 문구 끈적임이 없어요
- polarity — ENUM('POSITIVE', 'NEGATIVE') — NOT NULL — 크리에이터가 말한 방향
- claim_type — ENUM('EXPERIENCE', 'FACT') — NOT NULL — 경험형은 투표 가능
- created_at — DATETIME
- updated_at — DATETIME
review_claims
- claim_id — BIGINT — Primary key — NOT NULL — 기본키
- attribute_id — BIGINT — Foreign key → review_attributes.attribute_id — NOT NULL — 극성이 포함된 사전 항목
- creator_review_id — BIGINT — Foreign key → creator_reviews.creator_review_id — NOT NULL — PK, auto increment
- time_link_id — BIGINT — Foreign key → time_links.time_link_id — NOT NULL — PK, auto increment
- created_at — DATETIME
- updated_at — DATETIME
review_effects
- id — BIGINT — Primary key — NOT NULL — PK, auto increment
- creator_review_id — BIGINT — Foreign key → creator_reviews.creator_review_id
- skin_expectation_id — BIGINT — Foreign key → skin_expectations.skin_expectation_id
- created_at — DATETIME
- updated_at — DATETIME
review_skin_types
- id — BIGINT — Primary key — NOT NULL — PK, auto increment
- creator_review_id — BIGINT — Foreign key → creator_reviews.creator_review_id
- skin_type_id — BIGINT — Foreign key → skin_types.skin_type_id
- created_at — DATETIME
- updated_at — DATETIME
skin_expectations
- skin_expectation_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- concern — VARCHAR(255) — 피부 고민
- product_effect — VARCHAR(255) — 보습, 미백, 주름개선, 진정 등
- created_at — DATETIME
- updated_at — DATETIME
skin_types
- skin_type_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- skin_type_name — VARCHAR(255) — 건성, 지성, 복합성 등
- created_at — DATETIME
- updated_at — DATETIME
sub_categories
- sub_category_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- sub_category_name — VARCHAR(255) — 토너, 에센스, 크림 등
- main_category_id — BIGINT — Foreign key → main_categories.main_category_id
- created_at — DATETIME
- updated_at — DATETIME
time_links
- time_link_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- youtube_url — VARCHAR(200) — NOT NULL
- video_title — VARCHAR(200)
- view_count — BIGINT
- upload_at — DATETIME
- creator_review_id — BIGINT — Foreign key → creator_reviews.creator_review_id
- created_at — DATETIME
- updated_at — DATETIME
user_product_feedbacks
- user_product_feedback_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- status — ENUM('MATCHED', 'UNMATCHED')
- user_id — BIGINT — Foreign key → users.user_id
- product_id — BIGINT — Foreign key → products.product_id
user_reaction
- user_reaction_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- reaction_type — ENUM('AGREE', 'DISAGREE', 'SKIP')
- comment — VARCHAR(255) — 리뷰 댓글
- is_finalized — BOOLEAN — NOT NULL — 평가 확정 여부
- user_id — BIGINT — Foreign key → users.user_id
- creator_review_id — BIGINT — Foreign key → creator_reviews.creator_review_id
- created_at — DATETIME
- updated_at — DATETIME
user_skin_expectation
- user_skin_expectation_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- user_id — BIGINT — Foreign key → users.user_id
- skin_expectation_id — BIGINT — Foreign key → skin_expectations.skin_expectation_id
- created_at — DATETIME
- updated_at — DATETIME
user_skin_type
- user_skin_type_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- user_id — BIGINT — Foreign key → users.user_id
- skin_type_id — BIGINT — Foreign key → skin_types.skin_type_id
- created_at — DATETIME
- updated_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL — PK, auto increment
- email — VARCHAR(255)
- nickname — VARCHAR(255)
- enabled — BOOLEAN — NOT NULL — 회원가입 추가정보 입력 완료 여부
- role — ENUM('USER', 'ADMIN')
- profile_img_key — VARCHAR(255) — S3 key
- personal_color — ENUM('COOL', 'WARM')
- gender — ENUM('MALE', 'FEMALE', 'NONE')
- age — ENUM('TEENS', 'TWENTIES', 'THIRTIES', 'FORTIES', 'FIFTIES', 'SIXTIES_PLUS') — 연령대
- created_at — DATETIME
- updated_at — DATETIME