annotations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
room_id uuid 2147483647 null
page_url text 2147483647 null
css_selector text 2147483647 √ null
xpath text 2147483647 √ null
text_content text 2147483647 √ null
bounding_box jsonb 2147483647 √ null
title text 2147483647 null
body text 2147483647 √ null
category text 2147483647 null
severity text 2147483647 √ null
source text 2147483647 null
source_rule text 2147483647 √ null
source_meta jsonb 2147483647 √ null
wcag_criteria text 2147483647 √ null
wcag_level text 2147483647 √ null
status text 2147483647 'open'::text
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
created_by text 2147483647 √ null
node_id text 2147483647 √ null
canvas_x float8 17,17 √ null
canvas_y float8 17,17 √ null
target_node_id text 2147483647 √ null
visibility text 2147483647 'shared'::text
author_email text 2147483647 √ null
resolved_at timestamptz 35,6 √ null
disability_group text 2147483647 √ null
lawsuit_risk text 2147483647 √ null
capture_obj_key text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
annotations_pkey Primary key Asc id
idx_annotations_category Performance Asc category
idx_annotations_node Performance Asc/Asc room_id + node_id
idx_annotations_room Performance Asc room_id
idx_annotations_room_page Performance Asc/Asc room_id + page_url
idx_annotations_source Performance Asc/Asc room_id + source
idx_annotations_visibility Performance Asc/Asc room_id + visibility

Relationships

Close relationships within degrees of separation