labels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('labels_id_seq'::regclass)
image_annotation_label_feature_vectors.label_id image_annotation_label_feature_vectors_label_id_foreignR
image_annotation_labels.label_id annotation_labels_label_id_foreignR
image_labels.label_id image_labels_label_id_foreignR
labels.parent_id labels_parent_id_foreignC
maia_annotation_candidates.label_id maia_annotation_candidates_label_id_foreignN
video_annotation_label_feature_vectors.label_id video_annotation_label_feature_vectors_label_id_foreignR
video_annotation_labels.label_id video_annotation_labels_label_id_foreignR
video_labels.label_id video_labels_label_id_foreignR
name varchar 512 null
color varchar 6 '0099ff'::character varying
parent_id int4 10 √ null
labels.id labels_parent_id_foreignC
label_tree_id int4 10 √ null
label_trees.id labels_label_tree_id_foreignC
source_id varchar 255 √ null
label_source_id int4 10 √ null
label_sources.id labels_label_source_id_foreignR
uuid uuid 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
labels_pkey Primary key Asc id
labels_label_tree_id_index Performance Asc label_tree_id
labels_name_index Performance Asc name
labels_parent_id_index Performance Asc parent_id
labels_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation