Chat
Tables (4)
Message
- message_datetime — DATETIME
- message_text — TEXT
- Key (message_chat_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (message_user_id) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (chat_room)
- Key (chat_room_id) — INT — Primary key — NOT NULL
- Field (chat_room_title) — VARCHAR
- Field (chat_room_address) — VARCHAR
Untitled (user)
- Key (user_id) — INT — Primary key — NOT NULL
- Field (user_password) — VARCHAR
- Field (user_login_id) — VARCHAR
Untitled (chat_room_user)
- Key (chat_room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL