f

Tables (6)

analysis_results

  • analysis_id — SERIAL — Primary key — NOT NULL
  • review_id — VARCHAR(50) — Foreign key → reviews.review_id
  • risk_level — VARCHAR(10) — NOT NULL
  • reasoning — TEXT — NOT NULL
  • false_claim — TEXT
  • extortion_claim — TEXT
  • unlocked_legal_option — BOOLEAN
  • created_at — TIMESTAMP

chat_histories

  • chat_id — SERIAL — Primary key — NOT NULL
  • seller_id — VARCHAR(50) — Foreign key → sellers.seller_id
  • session_id — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP

legal_documents

  • doc_id — SERIAL — Primary key — NOT NULL
  • review_id — VARCHAR(50) — Foreign key → reviews.review_id
  • doc_type — VARCHAR(30) — NOT NULL
  • target_institution — VARCHAR(100)
  • file_path — VARCHAR(255)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

reviews

  • review_id — VARCHAR(50) — Primary key — NOT NULL
  • seller_id — VARCHAR(50) — Foreign key → sellers.seller_id
  • raw_text — TEXT — NOT NULL
  • cleaned_text — TEXT
  • platform_name — VARCHAR(50)
  • product_name — VARCHAR(100)
  • created_at — TIMESTAMP

sellers

  • seller_id — VARCHAR(50) — Primary key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • representative_name — VARCHAR(50) — NOT NULL
  • address — TEXT
  • contact — VARCHAR(20)
  • created_at — TIMESTAMP

suggested_replies

  • reply_id — SERIAL — Primary key — NOT NULL
  • analysis_id — INT — Foreign key → analysis_results.analysis_id
  • tone — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • is_selected — BOOLEAN