Artifacts
Table for storing file artifacts associated with sessions and devices
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| file_path | text | NOT NULL |
| session_id | bigint | |
| timestamp_observation | timestamp with time zone | |
| modality | text | |
| device_id | bigint | NOT NULL |
| updated_at | timestamp with time zone | DEFAULT now() |
| timestamp_observation_end | timestamp with time zone | DEFAULT now() NOT NULL |
Security Policies (RLS)
This table has Row Level Security (RLS) enabled with the following policies:
- Read Access: Device API key that owns the artifact OR users with view role in same herd
- Create/Update/Delete: Device API key that owns the artifact OR users with edit role in same herd