ㅂㅈㄷㅂㅈ

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