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)