label_trees


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('label_trees_id_seq'::regclass)
image_annotation_label_feature_vectors.label_tree_id image_annotation_label_feature_vectors_label_tree_id_foreignR
label_tree_authorized_project.label_tree_id label_tree_authorized_project_label_tree_id_foreignC
label_tree_project.label_tree_id label_tree_project_label_tree_id_foreignC
label_tree_user.label_tree_id label_tree_user_label_tree_id_foreignC
label_tree_versions.label_tree_id label_tree_versions_label_tree_id_foreignC
labels.label_tree_id labels_label_tree_id_foreignC
video_annotation_label_feature_vectors.label_tree_id video_annotation_label_feature_vectors_label_tree_id_foreignR
name varchar 256 null
description text 2147483647 √ null
visibility_id int4 10 null
visibilities.id label_trees_visibility_id_foreignR
created_at timestamp 22 √ null
updated_at timestamp 22 √ null
uuid uuid 2147483647 null
version_id int4 10 √ null
label_tree_versions.id label_trees_version_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
label_trees_pkey Primary key Asc id
label_trees_uuid_unique Must be unique Asc uuid
label_trees_version_id_unique Must be unique Asc version_id

Relationships

Close relationships within degrees of separation