location_mappings


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
final_location_id uuid 2147483647 null
accession_queue.permanent_location_id accession_queue_permanent_location_id_fkey1R
remote_configuration_id uuid 2147483647 √ null
remote_storage_configurations.id location_mappings_remote_configuration_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
location_mappings_pkey Primary key Asc final_location_id
location_mappings___origin_idx Performance Asc __origin
location_mappings___source_idx Performance Asc __source
location_mappings___start_idx Performance Asc __start
location_mappings_final_location_id_idx Performance Asc final_location_id
location_mappings_remote_configuration_id_idx Performance Asc remote_configuration_id

Relationships

Close relationships within degrees of separation