Chat
Table for storing chat messages between users in herds
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| message | text | NOT NULL |
| sender | uuid | |
| herd_id | bigint | NOT NULL |
Security Policies (RLS)
RLS enabled. Herd scope: Herd from chat.herd_id.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | chat.binary | Device API key in herd |
| INSERT | chat.binary | Device API key in herd; user must be sender or null |
| UPDATE | — | Device API key in herd, or sender = auth.uid() |
| DELETE | — | Device API key in herd, or sender = auth.uid() |
Platform superadmin: FOR ALL bypass where defined.
UPDATE/DELETE do not call has_herd_ability.