SkinCheck

Tables (10)

AI_ANALYSIS_LOG

  • id — BIGINT
  • analysis_id — BIGINT — Foreign key → SKIN_ANALYSIS.id — NOT NULL
  • provider — VARCHAR(20)
  • request_payload — TEXT
  • response_payload — TEXT
  • created_at — DATETIME

ANALYSIS_IMAGE

  • id — BIGINT
  • analysis_id — BIGINT — Foreign key → SKIN_ANALYSIS.id — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — DATETIME

COSMETIC

  • id — BIGINT
  • name — VARCHAR(255)
  • brand — VARCHAR(255)
  • image_url — VARCHAR(255)
  • link — VARCHAR(255)
  • category — VARCHAR(50)

EMAIL_VERIFICATION

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • token — VARCHAR(255)
  • expires_at — DATETIME
  • verified_at — DATETIME

PRODUCT_GUIDE

  • id — BIGINT
  • skin_type_code — VARCHAR(30)
  • condition_type — VARCHAR(50)
  • min_value — INT
  • max_value — INT
  • title — VARCHAR(255)
  • content — TEXT

RECOMMENDATION_HISTORY

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • analysis_id — BIGINT — Foreign key → SKIN_ANALYSIS.id — NOT NULL
  • condition_type — VARCHAR(50)
  • score — INT
  • created_at — DATETIME

SKIN_ANALYSIS

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • skin_type_code — VARCHAR(30)
  • summary_text — TEXT
  • image_url — VARCHAR(255)
  • created_at — DATETIME

SKIN_ANALYSIS_CONDITION

  • id — BIGINT
  • analysis_id — BIGINT — Foreign key → SKIN_ANALYSIS.id — NOT NULL
  • condition_type — VARCHAR(50)
  • condition_value — INT
  • condition_level — VARCHAR(20)
  • description — TEXT

USER

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • email_verified — BOOLEAN
  • created_at — DATETIME

USER_PROFILE

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • gender — VARCHAR(20)
  • birth_year — INT