eee

Tables (21)

Untitled

  • review_skin_expectation_id — BIGINT — Primary key — NOT NULL
  • creator_review_id — BIGINT — NOT NULL
  • skin_expectation_id — BIGINT — NOT NULL

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_skin_expectation

  • product_skin_expecation_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • product_effect_primary — BOOLEAN
  • skin_expectation_id — BIGINT — NOT NULL

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_expectation

  • skin_expectation_id — BIGINT — Primary key — NOT NULL
  • skin_concern — VARCHAR(100) — NOT NULL — 보습, 미백, 주름개선, 진정 등
  • product_effect — VARCHAR(100)

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_expectation

  • user_skin_expectation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • skin_expectation_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