image_annotation_labels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('annotation_labels_id_seq'::regclass)
image_annotation_label_feature_vectors.id image_annotation_label_feature_vectors_id_foreignC
annotation_id int4 10 null
image_annotations.id annotation_labels_annotation_id_foreignC
label_id int4 10 null
labels.id annotation_labels_label_id_foreignR
user_id int4 10 √ null
users.id annotation_labels_user_id_foreignN
confidence float8 17,17 null
created_at timestamp 22 √ null
updated_at timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
annotation_labels_pkey Primary key Asc id
annotation_labels_annotation_id_index Performance Asc annotation_id
annotation_labels_annotation_id_label_id_user_id_unique Must be unique Asc/Asc/Asc annotation_id + label_id + user_id
annotation_labels_label_id_index Performance Asc label_id
annotation_labels_user_id_index Performance Asc user_id

Relationships

Close relationships within degrees of separation