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