images


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('images_id_seq'::regclass)
image_annotations.image_id annotations_image_id_foreignC
image_labels.image_id image_labels_image_id_foreignC
maia_annotation_candidates.image_id maia_annotation_candidates_image_id_foreignC
maia_training_proposals.image_id maia_training_proposals_image_id_foreignC
filename varchar 512 null
volume_id int4 10 null
volumes.id images_transect_id_foreignC
attrs json 2147483647 √ null
uuid uuid 2147483647 null
lat float8 17,17 √ null
lng float8 17,17 √ null
taken_at timestamp 22 √ null
tiled bool 1 false

Indexes

Constraint Name Type Sort Column(s)
images_pkey Primary key Asc id
images_filename_transect_id_unique Must be unique Asc/Asc filename + volume_id
images_transect_id_index Performance Asc volume_id
images_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation