Actions
Table for storing automated actions triggered by zone events
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| inserted_at | timestamp with time zone | DEFAULT now() NOT NULL |
| zone_id | bigint | NOT NULL |
| trigger | text[] | NOT NULL |
| opcode | integer | NOT NULL |
Security Policies (RLS)
RLS enabled. Herd scope: Herd from zones.herd_id via get_herd_by_zone_id(zone_id).
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | map.read | Device API key in herd (via zone) |
| INSERT | map.write | Device API key in herd (via zone) |
| UPDATE | map.write | Device API key in herd (via zone) |
| DELETE | map.write | Device API key in herd (via zone) |
Platform superadmin: FOR ALL bypass where defined.