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