Document Templates
Consistent document categories per locality and issuer
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| name | text | NOT NULL |
| issuer_id | bigint | FK -> issuers |
| categories | text | |
| localization_id | bigint | FK -> localizations |
| uses_expiry | boolean | DEFAULT false NOT NULL |
| inserted_at | timestamp with time zone | DEFAULT timezone('utc'::text, now()) NOT NULL |
Security Policies (RLS)
RLS enabled. Scope: Global, superadmin-managed catalog.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | — | has_view_role_any_herd (herds.read in any herd), device API key, or superadmin |
| INSERT | — | Platform superadmin only |
| UPDATE | — | Platform superadmin only |
| DELETE | — | Platform superadmin only |
Platform superadmin: FOR ALL bypass where defined.