face

Tables (19)

ai_model_run

  • run_id — BIGINT — Primary key — NOT NULL — PK
  • diagnosis_id — BIGINT — NOT NULL — FK->diagnosis
  • model_name — VARCHAR(100) — NOT NULL — 모델명
  • model_version — VARCHAR(50) — NOT NULL — 버전
  • params_json — JSON — 하이퍼파라미터
  • metrics_json — JSON — 지표(예: loss/accuracy)
  • created_at — TIMESTAMP — NOT NULL — 실행 시각

diagnosis

  • diagnosis_id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • skin_score — DECIMAL(5, 2) — 피부 점수(0~100 가정)
  • predicted_skin_type_id — INT — 예측 피부타입 FK
  • content — TEXT — 요약/메모
  • created_at — TIMESTAMP — NOT NULL — 생성
  • updated_at — TIMESTAMP — 수정
  • is_deleted — TINYINT(1) — NOT NULL — 삭제 플래그

diagnosis_asset

  • asset_id — BIGINT — Primary key — NOT NULL — PK
  • diagnosis_id — BIGINT — NOT NULL — FK->diagnosis
  • file_url — VARCHAR(1000) — NOT NULL — 스토리지 URL
  • kind — ENUM('photo', 'mask', 'report') — NOT NULL — 자산 유형
  • created_at — TIMESTAMP — NOT NULL — 생성

ingredient

  • ingredient_id — BIGINT — Primary key — NOT NULL — PK
  • name — VARCHAR(200) — NOT NULL — 성분명
  • description — TEXT — 설명
  • function — VARCHAR(200) — 기능(보습/진정/항염 등)
  • created_at — TIMESTAMP — NOT NULL — 생성

product

  • product_id — BIGINT — Primary key — NOT NULL — PK
  • product_name — VARCHAR(255) — NOT NULL — 제품명
  • brand — VARCHAR(200) — 브랜드
  • category — VARCHAR(100) — 카테고리(토너/크림/선크림 등)
  • price — DECIMAL(10, 2) — 가격
  • description — TEXT — 설명
  • rating — DECIMAL(3, 2) — 평점 0~5
  • created_at — TIMESTAMP — NOT NULL — 생성

product_ingredient

  • id — BIGINT — Primary key — NOT NULL — PK
  • product_id — BIGINT — NOT NULL — FK->product
  • ingredient_id — BIGINT — NOT NULL — FK->ingredient
  • concentration — VARCHAR(50) — 함량/농도

product_skin_type

  • id — BIGINT — Primary key — NOT NULL — PK
  • product_id — BIGINT — NOT NULL — FK->product
  • skin_type_id — INT — NOT NULL — FK->skin_type
  • suitability_note — VARCHAR(255) — 메모(지성 적합/건성 주의 등)

recommendation_product

  • id — BIGINT — Primary key — NOT NULL — PK
  • diagnosis_id — BIGINT — NOT NULL — FK->diagnosis
  • product_id — BIGINT — NOT NULL — FK->product
  • score — DECIMAL(6, 4) — 추천 점수
  • rank_order — INT — 정렬 우선순위(1위부터)
  • created_at — TIMESTAMP — NOT NULL — 생성

recommendation_routine

  • id — BIGINT — Primary key — NOT NULL — PK
  • diagnosis_id — BIGINT — NOT NULL — FK->diagnosis
  • routine_id — BIGINT — NOT NULL — FK->routine
  • score — DECIMAL(6, 4) — 추천 점수
  • created_at — TIMESTAMP — NOT NULL — 생성

routine

  • routine_id — BIGINT — Primary key — NOT NULL — PK
  • routine_name — VARCHAR(200) — NOT NULL — 루틴명(예: AM 기본)
  • skin_type_id — INT — 대상 피부타입(옵션)
  • period — ENUM('AM', 'PM', 'ANY') — NOT NULL — 적용 시간대
  • description — TEXT — 설명/주의
  • created_at — TIMESTAMP — NOT NULL — 생성

routine_step

  • step_id — BIGINT — Primary key — NOT NULL — PK
  • routine_id — BIGINT — NOT NULL — FK->routine
  • step_order — INT — NOT NULL — 1..n
  • step_name — VARCHAR(200) — NOT NULL — 단계명(클렌징/토너/에센스/크림/선크림 등)
  • product_id — BIGINT — 권장 제품(옵션)
  • instruction — TEXT — 사용 방법/주의

skin_type

  • skin_type_id — INT — Primary key — NOT NULL — PK
  • type_name — VARCHAR(100) — NOT NULL — 타입명(건성/지성/복합성 등)
  • description — TEXT — 설명
  • created_at — TIMESTAMP — NOT NULL — 생성

user_account

  • user_id — BIGINT — Primary key — NOT NULL — PK
  • name — VARCHAR(100) — NOT NULL — 이름
  • gender — ENUM('male', 'female', 'other') — 성별
  • birth_date — DATE — 생년월일
  • email — VARCHAR(255) — NOT NULL — 로그인 이메일(유니크)
  • password — VARCHAR(255) — NOT NULL — 비밀번호 해시
  • created_at — TIMESTAMP — NOT NULL — 생성
  • updated_at — TIMESTAMP — 수정
  • is_deleted — TINYINT(1) — NOT NULL — 삭제 플래그

user_ingredient_sensitivity

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • ingredient_id — BIGINT — NOT NULL — FK->ingredient
  • severity — TINYINT — 심각도(1~5 등급)
  • note — VARCHAR(255) — 메모
  • created_at — TIMESTAMP — NOT NULL — 생성

user_product_blocklist

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • product_id — BIGINT — NOT NULL — FK->product
  • reason — VARCHAR(255) — 차단 사유
  • created_at — TIMESTAMP — NOT NULL — 생성

user_product_feedback

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • diagnosis_id — BIGINT — FK->diagnosis(선택)
  • product_id — BIGINT — NOT NULL — FK->product
  • rating — TINYINT — 별점 1~5
  • reaction — ENUM('like', 'dislike', 'neutral') — 선호/비선호
  • note — VARCHAR(255) — 메모/부작용
  • created_at — TIMESTAMP — NOT NULL — 생성

user_routine_feedback

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • diagnosis_id — BIGINT — FK->diagnosis(선택)
  • routine_id — BIGINT — NOT NULL — FK->routine
  • rating — TINYINT — 별점 1~5
  • note — VARCHAR(255) — 메모
  • created_at — TIMESTAMP — NOT NULL — 생성

user_skintype

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id — BIGINT — NOT NULL — FK->user_account
  • skin_type_id — INT — NOT NULL — FK->skin_type
  • assigned_at — TIMESTAMP — NOT NULL — 부여 시각

uv

  • uv_id — BIGINT — Primary key — NOT NULL — PK
  • date — DATE — NOT NULL — 일자
  • uv_index — INT — NOT NULL — UV 지수
  • created_at — TIMESTAMP — NOT NULL — 생성