Analysis_jobs
Top-level analysis or batch jobs
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| inserted_at | timestamp with time zone | DEFAULT timezone('utc'::text, now()) NOT NULL |
| timestamp_requested | timestamp with time zone | DEFAULT timezone('utc'::text, now()) NOT NULL |
| timestamp_started | timestamp with time zone | |
| timestamp_finished | timestamp with time zone | |
| job_type | text | DEFAULT '' NOT NULL |
| status | public.analysis_work_status | DEFAULT 'waiting' NOT NULL |
Security Policies (RLS)
RLS enabled. Herd scope: TBD when policies ship.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | TBD | service_role / superadmin today |
| INSERT | TBD | — |
| UPDATE | TBD | — |
| DELETE | TBD | — |
Platform superadmin: FOR ALL bypass where defined.
Expect explicit ability keys (e.g. media.read / .write) when policies are added.