Sensor Poses
Time-series sensor pose samples for a part
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| part_id | bigint | NOT NULL, FK -> parts |
| active_processing_modality | text | |
| active_recording_modality | text | |
| timestamp_observation | timestamp with time zone | NOT NULL |
| origin_location | extensions.geography | |
| origin_pitch | double precision | |
| origin_heading | double precision | |
| origin_roll | double precision | |
| sensor_pitch | double precision | |
| sensor_yaw | double precision | |
| sensor_roll | double precision | |
| origin_height | double precision | |
| inserted_at | timestamp with time zone | DEFAULT timezone('utc'::text, now()) NOT NULL |
Security Policies (RLS)
RLS enabled. Scope: Access resolved from the part via part_content_access (the part's herd directly, or the herd of its device).
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | telemetry.read | Owning device API key, or approved gateway in the same herd |
| INSERT | telemetry.write | Owning device API key, or approved gateway in the same herd |
| UPDATE | telemetry.write | Owning device API key, or approved gateway in the same herd |
| DELETE | telemetry.write | Owning device API key, or approved gateway in the same herd |
Platform superadmin: FOR ALL bypass where defined.