2ryuk

Tables (8)

chat_messages

  • id — BIGINT
  • room_id — INT
  • sender_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

game_records

  • id — INT
  • game_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • score — INT — NOT NULL
  • achieved_at — TIMESTAMP

games

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • type — EN_TYPE — NOT NULL
  • description — TEXT

reports

  • id — INT
  • reporter_id — INT — NOT NULL
  • target_id — INT — NOT NULL
  • reason — TEXT — NOT NULL
  • status — ENUM('PENDING', 'PROCESSED')
  • created_at — TIMESTAMP

room_members

  • id — INT
  • room_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • is_mic_on — BOOLEAN
  • joined_at — TIMESTAMP

room_tags

  • id — INT
  • room_id — INT — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL

rooms

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • host_id — INT — NOT NULL
  • max_participants — INT
  • current_count — INT
  • is_private — BOOLEAN
  • password — VARCHAR(255)
  • is_gaming — BOOLEAN
  • created_at — TIMESTAMP

users

  • id — INT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • role — ENUM('USER', 'ADMIN')
  • is_blacklisted — BOOLEAN
  • warning_count — INT
  • status — ENUM('ONLINE', 'OFFLINE', 'AWAY')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP