s

Tables (9)

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • nickname_snapshot — VARCHAR(50) — NOT NULL
  • content — VARCHAR(300) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_by — BIGINT — Foreign key → users.id
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • order_id — VARCHAR(255) — NOT NULL
  • payment_key — VARCHAR(255)
  • amount — INT — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELED') — NOT NULL
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL

room_participants

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME
  • status — ENUM('JOINED', 'LEFT') — NOT NULL

rooms

  • id — BIGINT — Primary key — NOT NULL
  • topic_id — BIGINT — Foreign key → topics.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — ENUM('OPEN', 'CLOSED') — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL

speaking_queue

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • queue_order — INT
  • active_request — BOOLEAN
  • status — ENUM('WAITING', 'ASSIGNED', 'CANCELED', 'COMPLETED') — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • canceled_at — DATETIME
  • assigned_at — DATETIME
  • expires_at — DATETIME

speech_reports

  • id — BIGINT — Primary key — NOT NULL
  • speech_id — BIGINT — Foreign key → speeches.id — NOT NULL
  • reported_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content_snapshot — TEXT — NOT NULL
  • reason — ENUM( 'ABUSE_HARASSMENT', 'HATE_SPEECH', 'SEXUAL_CONTENT', 'THREAT_VIOLENCE', 'SPAM', 'MISINFORMATION', 'PRIVACY_VIOLATION', 'OFF_TOPIC', 'OTHER' ) — NOT NULL
  • description — VARCHAR(500)
  • status — ENUM('PENDING', 'REVIEWING', 'RESOLVED', 'REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

speeches

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • stance — ENUM('PRO', 'CON')
  • link_url — VARCHAR(500)
  • image_url — VARCHAR(500)
  • status — ENUM('READY', 'SPEAKING', 'COMPLETED') — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — DATETIME

topics

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • category — VARCHAR(255)
  • source_url — VARCHAR(255)
  • status — ENUM('APPROVED', 'REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • approved_at — DATETIME
  • approved_by — BIGINT — Foreign key → users.id

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'BANNED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL