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