Embeddings_vertex_multimodal_001
Vertex multimodal 001 embeddings keyed by event and/or artifact media span
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| embedding | extensions.vector(1408) | NOT NULL |
| event_id | bigint | |
| artifact_id | bigint | |
| frame_index | bigint | DEFAULT 0 NOT NULL |
| frame_index_end | bigint | DEFAULT 0 NOT NULL |
| timestamp_observation | timestamp with time zone | |
| timestamp_observation_end | timestamp with time zone | |
| origin_location | extensions.geography | |
| frame_center_location | extensions.geography(Point, 4326) | |
| frame_center_altitude | double precision | |
| frame_center_h14_index | text | |
| frame_center_h13_index | text | |
| frame_center_h12_index | text | |
| frame_center_h11_index | text | |
| origin_pitch | double precision | |
| origin_heading | double precision | |
| origin_roll | double precision | |
| origin_height | double precision | |
| sensor_pitch | double precision | |
| sensor_yaw | double precision | |
| sensor_roll | double precision | |
| thumbnail_uri | text | |
| connectivity_id | bigint | FK -> connectivity, ON DELETE SET NULL |
| sensor_pose_id | bigint | FK -> sensor_poses, ON DELETE SET NULL |
thumbnail_uri is an optional bucket-qualified path to a representative still for the segment, stored in the embedding_thumbnails bucket. search_embeddings_vertex_multimodal_001 returns it so callers can show a picture for each match.
Optional producer-set FKs to nearest connectivity and sensor pose; returned by search_embeddings_vertex_multimodal_001.
Security Policies (RLS)
RLS enabled. Herd scope: Herd from linked event/artifact via get_herd_id_for_embedding.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | media.read | Device API key in herd |
| INSERT | media.write | Device API key in herd |
| UPDATE | media.write | Device API key in herd |
| DELETE | media.write | Device API key in herd |
Platform superadmin: FOR ALL bypass where defined.