data_source


Columns

Column Type Size Nulls Auto Default Children Parents Comments
data_source_id uuid 2147483647 gen_random_uuid()
barcode_file.data_source_id barcode_file_data_source_id_fkey R
biosample.alternative_data_source_id biosample_alternative_data_source_id_fkey R
biosample.data_source_id biosample_data_source_id_fkey R
biosample_data_source.alternative_data_source_id Implied Constraint R
biosample_data_source.data_source_id Implied Constraint R
biosample_set.data_source_id biosample_set_data_source_id_fkey R
biosample_set_data_source.data_source_id Implied Constraint R
biosource.alternative_data_source_id biosource_alternative_data_source_id_fkey R
biosource.data_source_id biosource_data_source_id_fkey R
biosource_data_source.alternative_data_source_id Implied Constraint R
biosource_data_source.data_source_id Implied Constraint R
epigenome.alternative_data_source_id epigenome_alternative_data_source_id_fkey R
epigenome.data_source_id epigenome_data_source_id_fkey R
epigenome_data_source.data_source_id Implied Constraint R
epigenome_group.data_source_id epigenome_group_data_source_id_fkey R
experiment.data_source_id experiment_data_source_id_fkey R
experiment_control_data_source.data_source_id Implied Constraint R
experiment_control_target_info.data_source_id Implied Constraint R
experiment_data_source.data_source_id Implied Constraint R
experiment_metadata.data_source_id Implied Constraint R
experiment_signal_data_source.data_source_id Implied Constraint R
experiment_signal_target_info.data_source_id Implied Constraint R
experiment_target_info.data_source_id Implied Constraint R
file.data_source_id file_data_source_id_fkey R
library_data_source.data_source_id Implied Constraint R
read_file.data_source_id read_file_data_source_id_fkey R
read_file_data_source.data_source_id Implied Constraint R
read_file_metadata.data_source_id Implied Constraint R
read_file_set.data_source_id read_file_set_data_source_id_fkey R
replicate.data_source_id replicate_data_source_id_fkey R
replicate_data_source.data_source_id Implied Constraint R
replicate_set.data_source_id replicate_set_data_source_id_fkey R
replicate_set_data_source.data_source_id Implied Constraint R
run.data_source_id run_data_source_id_fkey R
run_accession.data_source_id Implied Constraint R
accession text 2147483647 null
first_public date 13 √ null
last_updated date 13 √ null
archive_id uuid 2147483647 null
archive.archive_id data_source_archive_id_fkey R
request_payload jsonb 2147483647 √ null
data_source_type data_source_type 2147483647 √ null
registration_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
data_source_pkey Primary key Asc data_source_id
ix_data_source_accession Performance Asc accession
ix_data_source_archive_id Performance Asc archive_id

Relationships

Close relationships within degrees of separation