chatbot

Tables (3)

message (Message)

  • msg_id — int — Primary key — NOT NULL
  • sender — varchar(255)
  • text — text()
  • session_id — int — Foreign key → session.session_id — NOT NULL
  • Field (created_dt) — datetime()

session (Session)

  • session_id — int — Primary key — NOT NULL
  • title — varchar(255)
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • Field (created_dt) — datetime()

user (User)

  • user_id — int — Primary key — NOT NULL
  • password (user_name) — varchar(20) — NOT NULL
  • ID (email) — varchar(100) — NOT NULL