volumes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('transects_id_seq'::regclass)
annotation_sessions.volume_id annotation_sessions_transect_id_foreignC
color_sort_sequences.volume_id copria_color_sort_sequence_transect_id_foreignC
images.volume_id images_transect_id_foreignC
maia_jobs.volume_id maia_jobs_volume_id_foreignC
pending_volumes.volume_id pending_volumes_volume_id_foreignC
project_volume.volume_id project_transect_transect_id_foreignC
videos.volume_id videos_volume_id_foreignC
name varchar 512 null
attrs json 2147483647 √ null
media_type int4 10 null
creator_id int4 10 √ null
users.id transects_creator_id_foreignN
created_at timestamp 22 √ null
updated_at timestamp 22 √ null
url varchar 512 null
handle varchar 256 √ null
metadata_file_path varchar 256 √ null
metadata_parser varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
transects_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
volumes_media_type_check (((media_type >= 1) AND (media_type <= 2))) NOT VALID

Relationships

Close relationships within degrees of separation