CREATE TABLE IF NOT EXISTS document_requests (
  id TEXT PRIMARY KEY,
  application_id TEXT NOT NULL REFERENCES applications(id),
  requested_by TEXT NOT NULL,
  recipient TEXT NOT NULL,
  message TEXT NOT NULL,
  status TEXT NOT NULL DEFAULT 'SENT',
  sent_at TEXT,
  created_at TEXT NOT NULL
);
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS idx_document_requests_application ON document_requests(application_id, created_at);
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS idx_documents_review ON documents(application_id, review_status);