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