Manufacturers
Global catalog of product manufacturers
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| name | text | NOT NULL, unique (case-insensitive) |
| website | text | |
| country | text | ISO 3166-1 alpha-2 |
| gln | text | unique when set (GS1 Global Location Number) |
| lifecycle | public.entity_lifecycle | DEFAULT 'active' NOT NULL |
| lifecycle_changed_at | timestamp with time zone | DEFAULT timezone('utc'::text, now()) NOT NULL |
| lifecycle_changed_by | uuid | |
| lifecycle_reason | text | |
| 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.