image_annotations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('annotations_id_seq'::regclass)
annotation_assistance_requests.annotation_id annotation_assistance_requests_annotation_id_foreignC
image_annotation_label_feature_vectors.annotation_id image_annotation_label_feature_vectors_annotation_id_foreignC
image_annotation_labels.annotation_id annotation_labels_annotation_id_foreignC
maia_annotation_candidates.annotation_id maia_annotation_candidates_annotation_id_foreignN
points json 2147483647 √ null
image_id int4 10 null
images.id annotations_image_id_foreignC
shape int4 10 null
created_at timestamp 22 √ null
updated_at timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
annotations_pkey Primary key Asc id
annotations_image_id_index Performance Asc image_id
image_annotations_created_at_index Performance Asc created_at

Check Constraints

Constraint Name Constraint
image_annotations_shape_check (((shape >= 1) AND (shape <= 7))) NOT VALID

Relationships

Close relationships within degrees of separation