ㅂㅈㄷㅂㅈ
Tables (8)
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
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
payments
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — 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 — NOT NULL
- status — ENUM('WAITING', 'ASSIGNED', 'CANCELED', 'COMPLETED') — NOT NULL
- requested_at — DATETIME — NOT NULL
- canceled_at — DATETIME
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
topics
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
- source_url — VARCHAR(500)
- status — ENUM('PENDING', '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(100) — 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