Operators
Table for recording operator actions and sessions with timestamp tracking
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| timestamp | timestamp with time zone | |
| session_id | bigint | |
| user_id | uuid | NOT NULL |
| action | text |
Security Policies (RLS)
RLS enabled. Herd scope: Herd from operators.session_id → get_herd_id_by_session_id.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | sessions.read | Device API key on session |
| INSERT | sessions.write | Device API key on session |
| UPDATE | sessions.write | Device API key on session |
| DELETE | sessions.write | Device API key on session |
Platform superadmin: FOR ALL bypass where defined.