remote_storage_configurations


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
id uuid 2147483647 null
accession_queue.id Implied ConstraintR
accession_queue.remote_storage_id accession_queue_remote_storage_id_fkeyR
location_mappings.remote_configuration_id location_mappings_remote_configuration_id_fkeyR
retrieval_queue.id Implied ConstraintR
retrieval_queue.remote_storage_id retrieval_queue_remote_storage_id_fkeyR
system_user_parameters.id Implied ConstraintR
name varchar 8 √ null
api_key varchar 1 √ null
provider_name varchar 11 √ null
url varchar 1 √ null
status_url varchar 1 √ null
accession_delay int4 10 √ null
accession_time_unit varchar 7 √ null
created_date timestamp 29,6 √ null
created_by_user_id uuid 2147483647 √ null
created_by_username varchar 1 √ null
updated_date timestamp 29,6 √ null
updated_by_user_id uuid 2147483647 √ null
updated_by_username varchar 1 √ null
accession_workflow_details varchar 1 √ null
returning_workflow_details varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
remote_storage_configurations_pkey Primary key Asc id
remote_storage_configurations___origin_idx Performance Asc __origin
remote_storage_configurations___source_idx Performance Asc __source
remote_storage_configurations___start_idx Performance Asc __start
remote_storage_configurations_accession_delay_idx Performance Asc accession_delay
remote_storage_configurations_accession_time_unit_idx Performance Asc accession_time_unit
remote_storage_configurations_accession_workflow_details_idx Performance Asc accession_workflow_details
remote_storage_configurations_api_key_idx Performance Asc api_key
remote_storage_configurations_created_by_user_id_idx Performance Asc created_by_user_id
remote_storage_configurations_created_by_username_idx Performance Asc created_by_username
remote_storage_configurations_created_date_idx Performance Asc created_date
remote_storage_configurations_id_idx Performance Asc id
remote_storage_configurations_name_idx Performance Asc name
remote_storage_configurations_provider_name_idx Performance Asc provider_name
remote_storage_configurations_returning_workflow_details_idx Performance Asc returning_workflow_details
remote_storage_configurations_status_url_idx Performance Asc status_url
remote_storage_configurations_updated_by_user_id_idx Performance Asc updated_by_user_id
remote_storage_configurations_updated_by_username_idx Performance Asc updated_by_username
remote_storage_configurations_updated_date_idx Performance Asc updated_date
remote_storage_configurations_url_idx Performance Asc url

Relationships

Close relationships within degrees of separation