Chat
Tables (8)
ChatMessage
- id — INT — Primary key
- sender — ENUM('user', 'bot') — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME
- session_id — INT — Foreign key → ChatSession.id
ChatSession
- id — INT — Primary key
- session_title — VARCHAR(100)
- created_at — DATETIME
- user_id — INT — Foreign key → User.id
CounselingPost
- id — INT — Primary key
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- category — ENUM('심리', '관계', '중독', '위험') — NOT NULL
- created_at — DATETIME
- user_id — INT — Foreign key → User.id
CounselingPostAttachment
- id — INT — Primary key
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- uploaded_at — DATETIME
- post_id — INT — Foreign key → CounselingPost.id
Document
- id — INT — Primary key
- title — VARCHAR(255)
- content — TEXT
- uploaded_at — DATETIME
- user_id — INT — Foreign key → User.id
Feedback
- id — INT — Primary key
- rating — TINYINT
- comment — TEXT — EX
- created_at — DATETIME
- message_id — INT — Foreign key → ChatMessage.id
PostComment
- id — INT — Primary key
- content — TEXT — NOT NULL
- created_at — DATETIME
- post_id — INT — Foreign key → CounselingPost.id
- user_id — INT — Foreign key → User.id
User
- id — INT — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- created_at — DATETIME