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