-- database/schema.sql (Pre-loaded in Live Frontend & Vercel SQLite Engine)
CREATE TABLE erp_branch_financials (branch_id SERIAL PRIMARY KEY, branch_name VARCHAR(100), region VARCHAR(50), q3_revenue_lakhs NUMERIC(12,2), po_expense_lakhs NUMERIC(12,2), overdue_invoices_count INT, sla_compliance_pct NUMERIC(5,2));
CREATE TABLE ats_candidates (candidate_id SERIAL PRIMARY KEY, full_name VARCHAR(120), target_role VARCHAR(120), core_skills TEXT, experience_years NUMERIC(4,1), notice_period_days INT, ats_match_score INT, expected_ctc_lpa VARCHAR(30));
CREATE TABLE dealer_inventory_skus (dealer_id SERIAL PRIMARY KEY, dealer_name VARCHAR(120), city VARCHAR(60), fulfillment_pct VARCHAR(20), credit_overdue_pct VARCHAR(20), quarterly_volume_lakhs NUMERIC(12,2), scheme_tier VARCHAR(40));
CREATE TABLE rag_document_chunks (chunk_id VARCHAR(40) PRIMARY KEY, doc_title VARCHAR(200), department VARCHAR(60), chunk_text TEXT, rrf_score NUMERIC(4,2));