Mahjong Server
Tables (3)
Rooms
- id — int — Primary key — NOT NULL
- room_name — varchar
- is_private — bool
- created_at — datetime
RoomsUsers
- room_id — int — Foreign key → Rooms.id — NOT NULL
- user_id — int — Foreign key → Users.id — NOT NULL
- created_at — datetime
- is_connected — bool
- Field
Users
- id — int — Primary key — NOT NULL
- user_name — varchar
- password — varchar
- is_active — bool
- created_at — datetime