epigenome


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name text 2147483647 √ null
description text 2147483647 √ null
epigenome_id uuid 2147483647 gen_random_uuid()
analysis_file_experiment_info.epigenome_id Implied Constraint R
analysis_file_info_with_checks.epigenome_id Implied Constraint R
base_epigenome_replicates.base_epigenome_id Implied Constraint R
base_epigenomes_replicates_and_files.base_epigenome_id Implied Constraint R
biosample_biological_group.epigenome_id Implied Constraint R
biosample_sample_type.epigenome_id Implied Constraint R
biosample_term_group.epigenome_id Implied Constraint R
curated_experiment_metadata.epigenome_id Implied Constraint R
curated_open_chromatin_assay_metadata.epigenome_id Implied Constraint R
epigenome_data_source.epigenome_id Implied Constraint R
experiment.epigenome_id experiment_epigenome_id_fkey R
experiment_control_data_source.epigenome_id Implied Constraint R
experiment_control_target_info.epigenome_id Implied Constraint R
experiment_data_source.epigenome_id Implied Constraint R
experiment_metadata.epigenome_id Implied Constraint R
experiment_signal_and_control_data_source.epigenome_id Implied Constraint R
experiment_signal_data_source.epigenome_id Implied Constraint R
experiment_signal_target_info.epigenome_id Implied Constraint R
experiment_target_info.epigenome_id Implied Constraint R
read_file_metadata.epigenome_id Implied Constraint R
track.epigenome_id track_epigenome_id_fkey R
epigenome_group_id uuid 2147483647 null
epigenome_group.epigenome_group_id epigenome_epigenome_group_id_fkey R
species_id uuid 2147483647 null
species.species_id epigenome_species_id_fkey R
data_source_id uuid 2147483647 √ null
data_source.data_source_id epigenome_data_source_id_fkey R
alternative_data_source_id uuid 2147483647 √ null
data_source.data_source_id epigenome_alternative_data_source_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
epigenome_pkey Primary key Asc epigenome_id
ix_epigenome_alternative_data_source_id Performance Asc alternative_data_source_id
ix_epigenome_data_source_id Performance Asc data_source_id
ix_epigenome_epigenome_group_id Performance Asc epigenome_group_id
ix_epigenome_species_id Performance Asc species_id

Relationships

Close relationships within degrees of separation