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