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