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