skin
Tables (14)
Untitled
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
boards
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
calendar_tasks
- cal_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key
- task_date — DATE
- title — VARCHAR(255)
- description — VARCHAR(500)
- is_completed — BOOLEAN
chat_messages
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key
- sender — VARCHAR(50)
- message — TEXT
- created_at — DATETIME
comments
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → posts.id
- user_id — INT — Foreign key
- content — TEXT
- created_at — DATETIME
diagnosis_metrics
- id — INT — Primary key — NOT NULL
- diagnosis_record_id — INT — Foreign key → diagnosis_records.id
- label — VARCHAR(100)
- value — INT
diagnosis_recommendations
- diagnosis_record_id — INT — Foreign key → diagnosis_records.id — NOT NULL
- product_id — INT — Foreign key → products.id — NOT NULL
diagnosis_records
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key
- diagnosis_type_id — INT — Foreign key → diagnosis_types.id
- image_url — VARCHAR(500)
- score — INT
- grade — VARCHAR(50)
- created_at — DATETIME
diagnosis_types
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- description — VARCHAR(500)
- icon — VARCHAR(500)
post_likes
- user_id — INT — Foreign key — NOT NULL
- post_id — INT — Foreign key → posts.id — NOT NULL
posts
- id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → boards.id
- user_id — INT — Foreign key
- title — VARCHAR(255)
- content — TEXT
- view_count — INT
- like_count — INT
- created_at — DATETIME
products
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- image_url — VARCHAR(500)
- category — VARCHAR(100)
skin_score_logs
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key
- log_date — DATE
- score — INT