maia_annotation_candidates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('maia_annotation_candidates_id_seq'::regclass)
points json 2147483647 √ null
score float8 17,17 null
image_id int4 10 null
images.id maia_annotation_candidates_image_id_foreignC
shape int4 10 null
job_id int4 10 null
maia_jobs.id maia_annotation_candidates_job_id_foreignC
label_id int4 10 √ null
labels.id maia_annotation_candidates_label_id_foreignN
annotation_id int4 10 √ null
image_annotations.id maia_annotation_candidates_annotation_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
maia_annotation_candidates_pkey Primary key Asc id
maia_annotation_candidates_annotation_id_index Performance Asc annotation_id
maia_annotation_candidates_image_id_index Performance Asc image_id
maia_annotation_candidates_job_id_index Performance Asc job_id
maia_annotation_candidates_label_id_index Performance Asc label_id

Check Constraints

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

Relationships

Close relationships within degrees of separation