priority INTEGER NOT NULL DEFAULT 10, -- Lower number = higher priority attempts INTEGER NOT NULL DEFAULT 0, max_attempts INTEGER NOT NULL DEFAULT 3, error_message TEXT, return_value JSONB, ...
CREATE UNIQUE INDEX IF NOT EXISTS idx_njq_patient ON ontology.nlp_job_queue(patient_id); CREATE INDEX IF NOT EXISTS idx_njq_status ON ontology.nlp_job_queue(status); ...