Chatting

Tables (4)

JOIN (Untitled4)

  • user_id (Key3) — INT — Foreign key → USER.user_id — NOT NULL
  • room_id (Key2) — INT — Foreign key → ROOM.room_id — NOT NULL

MESSAGE (Untitled3)

  • message_id (Key) — INT — Primary key — NOT NULL
  • room_id (Key2) — INT — Foreign key → JOIN.room_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → JOIN.user_id — NOT NULL
  • text (Field) — TEXT
  • datetime (Field2) — varchar(20)

ROOM (Untitled2)

  • room_id (Key) — INT — Primary key — NOT NULL
  • room_name (Field) — varchar(20)

USER (Untitled)

  • user_id (Key) — INT — Primary key — NOT NULL
  • user_name (Field) — varchar(20)
  • password (Field3) — varchar(20)
  • last_login (Field2) — timestamp
  • status (Field4) — varchar(20)