chatTables (3)roomid — Primary key — NOT NULLFielduseruser_id — Primary key — NOT NULLFielduser_roomid (Keyid) — Primary key — NOT NULLuser_id — Foreign key → user.user_id — NOT NULLid (id2) — Foreign key → room.id — NOT NULL