참견도치
테이블 (10)
comment
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT
- created_at — DATETIME
community_post
- id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- created_at — DATETIME
- vote_type — ENUM('AGREE', 'DISAGREE')
conflict_analysis
- id — BIGINT
- conflict_id — BIGINT — NOT NULL
- summary — TEXT
- ai_comment — TEXT — EX
- created_at — DATETIME
conflict_card
- id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- goal — VARCHAR(200)
- created_at — DATETIME
- updated_at — DATETIME
emotion_log
- id — BIGINT
- conflict_id — BIGINT — NOT NULL
- emotion_type — ENUM('ANGER', 'SAD', 'HAPPY', 'NEUTRAL') — NOT NULL
- intensity — INT
- timestamp — DATETIME — NOT NULL
notice
- id — BIGINT
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- admin_id — BIGINT — NOT NULL
- created_at — DATETIME
rtc_session
- id — BIGINT
- conflict_id — BIGINT — NOT NULL
- host_user_id — BIGINT — NOT NULL
- session_code — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN
- started_at — DATETIME
- ended_at — DATETIME
session_participant
- id — BIGINT
- session_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role — ENUM('USER', 'OBSERVER')
- joined_at — DATETIME
session_summary
- id — BIGINT
- session_id — BIGINT — NOT NULL
- summary_text — TEXT
- final_comment — TEXT — EX
user
- id — BIGINT
- social_id — VARCHAR(100) — NOT NULL
- provider — ENUM('KAKAO', 'GOOGLE') — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- role — ENUM('USER', 'ADMIN')
- created_at — DATETIME
- deleted — BOOLEAN