video_annotations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('video_annotations_id_seq'::regclass)
video_annotation_label_feature_vectors.annotation_id video_annotation_label_feature_vectors_annotation_id_foreignC
video_annotation_labels.annotation_id video_annotation_labels_video_annotation_id_foreignC
frames json 2147483647 √ null
points json 2147483647 √ null
video_id int4 10 null
videos.id video_annotations_video_id_foreignC
shape int4 10 null
created_at timestamp 22 √ null
updated_at timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
video_annotations_pkey Primary key Asc id
video_annotations_created_at_index Performance Asc created_at
video_annotations_video_id_index Performance Asc video_id

Check Constraints

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

Relationships

Close relationships within degrees of separation