ARENA
Tables (7)
comments
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
debate_messages
- id — BIGINT — Primary key — NOT NULL
- debate_session_id — BIGINT — Foreign key → debate_sessions.id — NOT NULL
- speaker — VARCHAR(30) — NOT NULL
- round_no — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
debate_sessions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- mode — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- peak_reached — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- stopped_at — DATETIME
debate_summaries
- id — BIGINT — Primary key — NOT NULL
- debate_session_id — BIGINT — Foreign key → debate_sessions.id — NOT NULL
- core_arguments — TEXT — NOT NULL
- highlight — TEXT
- decision_criteria — TEXT
- remaining_issue — TEXT
- summary_text — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
post_votes
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- choice — VARCHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
posts
- id — BIGINT — Primary key — NOT NULL
- debate_session_id — BIGINT — Foreign key → debate_sessions.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(120) — NOT NULL
- summary_card — TEXT — NOT NULL
- vote_option_a — VARCHAR(80) — NOT NULL
- vote_option_b — VARCHAR(80) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL