chatbot
Tables (4)
products (Untitled)
- id (Key) — int — Primary key — NOT NULL
- certification_number (Field) — int
- product_number (Field2) — int
- model_name (Field3) — varchar(255)
- manufaturer (Field4) — varchar(255)
- country (Field5) — varchar(255)
- remarks (Field6) — varchar(255)
question (CopyOfUntitled)
- id (Key) — int — Primary key — NOT NULL
- id (Key2) — int — Foreign key → products.id — NOT NULL
- session_id (Key3) — int — Foreign key → users.session_id — NOT NULL
- session_id (Field) — varchar(255)
- question_content (Field2) — Text
- question_time (Field3) — TimeStamp
- status (Field4) — status
- product_id (Field5) — product_id
response (CopyOfCopyOfUntitled)
- id (Key) — int — Primary key — NOT NULL
- id (Key2) — int — Foreign key → products.id — NOT NULL
- question_id (Field) — int
- response_content (Field2) — TEXT
- response_time (Field3) — TIMESTAMP
- is_manual (Field4) — BOOLEAN
users (Untitled2)
- session_id (Key) — int — Primary key — NOT NULL
- created_at (Field) — timestamp
- updated_at (Field2) — updated_at