deepiary
Tables (5)
chat_sessions
- chat_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → users.user_id
- user_id — BIGINT — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
- result_text — TEXT
diary_entries
- diary_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → users.user_id
- user_id — BIGINT — NOT NULL
- content — TEXT
- emotion_summary — VARCHAR(255)
- emotion_json — JSON
- created_at — DATETIME
- updated_at — DATETIME
inquiries
- inquiry_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → users.user_id
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- answered — BOOLEAN
users
- user_id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- profile_image — VARCHAR(255)
- role — ENUM('USER', 'ADMIN')
- withdrawn — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
withdrawal_logs
- log_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → users.user_id
- user_id — BIGINT
- reason — TEXT
- created_at — DATETIME