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 — 생성