Tags

Table for storing object detection tags and annotations with confidence scores and locations

Column Name	Data Type	Constraints
id	bigint	NOT NULL
inserted_at	timestamp with time zone	DEFAULT timezone('utc'::text, now()) NOT NULL
x	double precision	NOT NULL
y	double precision	NOT NULL
width	double precision	NOT NULL
height	double precision	DEFAULT 0 NOT NULL
conf	double precision	NOT NULL
class	text	NOT NULL
detector	text	DEFAULT '' NOT NULL
observation_type	public.tag_observation_type	NOT NULL
frame_index	integer	DEFAULT 0 NOT NULL
event_id	bigint
artifact_id	bigint
timestamp_observation	timestamp with time zone
origin_location	extensions.geography
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
subject_location	extensions.geography
subject_height	double precision
subject_id	bigint
score	double precision
score_source	text

Security Policies (RLS)

RLS enabled. Herd scope: Herd from linked event/artifact via get_herd_id_for_tag.

Platform superadmin: FOR ALL bypass where defined.