langchain

Tables (3)

email_log

  • id — serial — Primary key — NOT NULL
  • message_id — varchar(255) — NOT NULL
  • from_address — varchar(255) — NOT NULL
  • subject — text
  • body_text — text
  • decision — varchar(20)
  • reply_body — text
  • created_at — timestamptz — NOT NULL

email_question

  • id — serial — Primary key — NOT NULL
  • log_id — int — Foreign key → email_log.id — NOT NULL
  • seq — smallint — NOT NULL
  • question_text — text — NOT NULL
  • matched_faq_id — int — Foreign key → faq.id
  • distance — real

faq

  • id — serial — Primary key — NOT NULL
  • category — varchar(40) — NOT NULL
  • question — text — NOT NULL
  • answer — text — NOT NULL
  • source_url — text
  • embedding — vector(1536)