final-project-erd
Tables (3)
Copy Of chatbot_room (message)
- id (message_id) — bigint(20) — Primary key — NOT NULL
- id (session_id) — bigint(20) — Foreign key → chatbot_room.id — NOT NULL
- content — longtext — NOT NULL
- sender — enum('user', 'bot') — NOT NULL
- timestamp — datetime — NOT NULL
chatbot_room (chat_room)
- id (chat_room_id) — bigint(20) — Primary key — NOT NULL
- id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- date_created — datetime — NOT NULL
- title — varchar(255) — NOT NULL
user
- id (user_id) — bigint(20) — Primary key — NOT NULL
- user_id (identify_id) — varchar(10) — NOT NULL