Team12

Tables (20)

ai_counter_issues

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • trigger_queue_id — BIGINT — Foreign key → speaking_queue.id — NOT NULL
  • target_stance — VARCHAR(10) — NOT NULL
  • content — VARCHAR(3000)
  • status — VARCHAR(20) — NOT NULL
  • error_message — VARCHAR(500)
  • retry_count — INT — NOT NULL
  • last_attempted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

ai_report_pdf_exports

  • id — BIGINT — Primary key — NOT NULL
  • ai_report_id — BIGINT — Foreign key → ai_reports.id — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • requested_by_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • pdf_type — VARCHAR(20) — NOT NULL
  • pdf_status — VARCHAR(20) — NOT NULL
  • pdf_object_key — VARCHAR(500)
  • pdf_generated_at — DATETIME
  • pdf_error_message — VARCHAR(1000)
  • pdf_retry_count — INT — NOT NULL
  • pdf_last_attempted_at — DATETIME
  • notification_status — VARCHAR(20) — NOT NULL
  • notification_sent_at — DATETIME
  • notification_error_message — VARCHAR(1000)
  • notification_retry_count — INT — NOT NULL
  • notification_last_attempted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ai_reports

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • core_line — VARCHAR(3000)
  • key_issues — VARCHAR(3000)
  • custom_prompts — VARCHAR(3000)
  • custom_reports — VARCHAR(3000)
  • ai_summary — VARCHAR(3000)
  • common_ground — VARCHAR(3000)
  • ai_opinion — VARCHAR(3000)
  • error_message — VARCHAR(1000)
  • publish_retry_count — INT — NOT NULL
  • generation_retry_count — INT — NOT NULL
  • last_error_code — VARCHAR(100)
  • last_error_message — VARCHAR(1000)
  • processing_started_at — DATETIME
  • processing_locked_until — DATETIME
  • requested_at — DATETIME — NOT NULL
  • queued_at — DATETIME
  • completed_at — DATETIME
  • failed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

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 — TINYINT — NOT NULL
  • deleted_by — BIGINT — Foreign key → users.id
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

chat_reports

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • message_id — BIGINT — Foreign key → chat_messages.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 — VARCHAR(3000) — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • description — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • reviewed_by — BIGINT — Foreign key → users.id
  • reviewed_at — DATETIME
  • resolution_note — VARCHAR(500)
  • severity — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

custom_ai_report_requests

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • payment_id — BIGINT — Foreign key → payments.id
  • status — VARCHAR(30) — NOT NULL
  • custom_prompts — VARCHAR(3000) — NOT NULL
  • last_error_message — VARCHAR(1000)
  • paid_at — DATETIME
  • queued_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

off_topic_ai_reviews

  • id — BIGINT — Primary key — NOT NULL
  • version — BIGINT
  • speech_id — BIGINT — Foreign key → speeches.id — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • content_snapshot — VARCHAR(3000) — NOT NULL
  • report_count — INT — NOT NULL
  • threshold — INT — NOT NULL
  • participant_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • is_off_topic — TINYINT
  • confidence — DOUBLE
  • reason — VARCHAR(500)
  • error_message — VARCHAR(500)
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

outbox_events

  • id — BIGINT — Primary key — NOT NULL
  • event_id — VARCHAR(36) — NOT NULL
  • aggregate_type — VARCHAR(50) — NOT NULL
  • aggregate_id — BIGINT — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • payload — VARCHAR(3000) — NOT NULL
  • deduplication_key — VARCHAR(150) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME
  • last_error_message — VARCHAR(3000)
  • occurred_at — DATETIME — NOT NULL
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • order_id — VARCHAR(100) — NOT NULL
  • payment_key — VARCHAR(200)
  • amount — BIGINT — NOT NULL
  • order_name — VARCHAR(200) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • approved_at — DATETIME
  • failed_at — DATETIME
  • failure_reason — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • updated_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 — VARCHAR(20) — NOT NULL

room_queue_sequences

  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • next_queue_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

rooms

  • id — BIGINT — Primary key — NOT NULL
  • topic_id — BIGINT — Foreign key → topics.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • max_participants — INT — NOT NULL
  • 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 — TINYINT
  • stance — VARCHAR(10)
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • canceled_at — DATETIME
  • assigned_at — DATETIME
  • expires_at — DATETIME
  • last_activity_at — DATETIME
  • idle_warning_sent — TINYINT — NOT NULL
  • idle_warned_at — DATETIME

speech_reactions

  • id — BIGINT — Primary key — NOT NULL
  • speech_id — BIGINT — Foreign key → speeches.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

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 — VARCHAR(3000) — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • description — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • reviewed_by — BIGINT — Foreign key → users.id
  • reviewed_at — DATETIME
  • resolution_note — VARCHAR(500)
  • severity — VARCHAR(20)
  • 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
  • speaking_queue_id — BIGINT — Foreign key → speaking_queue.id
  • content — VARCHAR(3000) — NOT NULL
  • stance — VARCHAR(10)
  • speaking_stance — VARCHAR(10)
  • link_url — VARCHAR(500)
  • image_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — TINYINT — NOT NULL
  • delete_reason — VARCHAR(30)
  • deleted_at — DATETIME

stage_summaries

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • moderator_summary — VARCHAR(3000)
  • key_points — VARCHAR(3000)
  • speech_count — INT — NOT NULL
  • completed_speaker_count — INT — NOT NULL
  • triggered_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • retry_count — INT — NOT NULL
  • last_attempted_at — DATETIME
  • error_message — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

topics

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

user_sanctions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • admin_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • report_id — BIGINT
  • type — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • starts_at — DATETIME — NOT NULL
  • ends_at — DATETIME
  • revoked_at — DATETIME
  • revoked_by — BIGINT — Foreign key → users.id
  • revocation_reason — VARCHAR(500)
  • extended_at — DATETIME
  • extended_by — BIGINT — Foreign key → users.id
  • extension_reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • token_version — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL