hompcha

Tables (3)

Room (Untitled3)

  • room_id (Key) — text — Primary key — NOT NULL
  • room_name (Field) — text
  • room_status (Field2) — text
  • room_max (Field3) — int
  • people_num (Field4) — int

User (Untitled)

  • user_id (Key) — text — Primary key — NOT NULL
  • id (Field) — text
  • password (Field2) — text
  • nickname (Field3) — text

joinTable (Untitled2)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — text — Foreign key → User.user_id — NOT NULL
  • room_id (Key3) — text — Foreign key → Room.room_id — NOT NULL