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