Plans
Table for storing plans with instructions for herds
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| inserted_at | timestamp with time zone | DEFAULT timezone('utc'::text, now()) |
| name | text | NOT NULL |
| instructions | text | NOT NULL |
| herd_id | bigint | NOT NULL |
| plan_type | public.plan_type | DEFAULT 'mission' NOT NULL |
Security Policies (RLS)
RLS enabled. Herd scope: Herd from plans.herd_id.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | map.read | Device API keys in herd |
| INSERT | map.write | Device API keys in herd |
| UPDATE | map.write | Device API keys in herd |
| DELETE | map.write | Device API keys in herd |
Platform superadmin: FOR ALL bypass where defined.