video_annotation_labels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('video_annotation_labels_id_seq'::regclass)
video_annotation_label_feature_vectors.id video_annotation_label_feature_vectors_id_foreignC
annotation_id int4 10 null
video_annotations.id video_annotation_labels_video_annotation_id_foreignC
label_id int4 10 null
labels.id video_annotation_labels_label_id_foreignR
user_id int4 10 √ null
users.id video_annotation_labels_user_id_foreignN
created_at timestamp 22 √ null
updated_at timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
video_annotation_labels_pkey Primary key Asc id
video_annotation_labels_label_id_index Performance Asc label_id
video_annotation_labels_user_id_index Performance Asc user_id
video_annotation_labels_video_annotation_id_index Performance Asc annotation_id
video_annotation_labels_video_annotation_id_label_id_user_id_un Must be unique Asc/Asc/Asc annotation_id + label_id + user_id

Relationships

Close relationships within degrees of separation