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