Constraints

69 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
assembly_file_id_fkey
assembly.file_id
file.file_id
Restrict delete
assembly_species_id_fkey
assembly.species_id
species.species_id
Restrict delete
run_alignment_task_run_id_fkey
run_alignment_task.run_id
run.run_id
Restrict delete
run_alignment_task_alignment_task_id_fkey
run_alignment_task.alignment_task_id
alignment_task.alignment_task_id
Restrict delete
biosource_alternative_data_source_id_fkey
biosource.alternative_data_source_id
data_source.data_source_id
Restrict delete
biosource_data_source_id_fkey
biosource.data_source_id
data_source.data_source_id
Restrict delete
biosource_life_stage_id_fkey
biosource.life_stage_id
life_stage.life_stage_id
Restrict delete
data_source_archive_id_fkey
data_source.archive_id
archive.archive_id
Restrict delete
analysis_file_file_id_fkey
analysis_file.file_id
file.file_id
Restrict delete
analysis_file_assembly_id_fkey
analysis_file.assembly_id
assembly.assembly_id
Restrict delete
analysis_file_experiment_id_fkey
analysis_file.experiment_id
experiment.experiment_id
Restrict delete
dnase_seq_experiment_id_fkey
dnase_seq.experiment_id
experiment.experiment_id
Restrict delete
dnase_seq_replicate_set_id_fkey
dnase_seq.replicate_set_id
replicate_set.replicate_set_id
Restrict delete
biosample_set_biosample_biosample_id_fkey
biosample_set_biosample.biosample_id
biosample.biosample_id
Restrict delete
biosample_set_biosample_biosample_set_id_fkey
biosample_set_biosample.biosample_set_id
biosample_set.biosample_set_id
Restrict delete
mask_file_assembly_id_fkey
mask_file.assembly_id
assembly.assembly_id
Restrict delete
mask_file_file_id_fkey
mask_file.file_id
file.file_id
Restrict delete
s3_object_bucket_id_fkey
s3_object.bucket_id
bucket.bucket_id
Restrict delete
s3_object_file_id_fkey
s3_object.file_id
file.file_id
Restrict delete
biosample_biosource_id_fkey
biosample.biosource_id
biosource.biosource_id
Restrict delete
biosample_ontology_id_fkey
biosample.ontology_id
ontology.ontology_id
Restrict delete
biosample_life_stage_id_fkey
biosample.life_stage_id
life_stage.life_stage_id
Restrict delete
biosample_alternative_data_source_id_fkey
biosample.alternative_data_source_id
data_source.data_source_id
Restrict delete
biosample_data_source_id_fkey
biosample.data_source_id
data_source.data_source_id
Restrict delete
chip_seq_control_fkey
chip_seq.control
replicate_set.replicate_set_id
Restrict delete
chip_seq_tf_target_id_fkey
chip_seq.tf_target_id
tf_target.tf_target_id
Restrict delete
chip_seq_histone_target_id_fkey
chip_seq.histone_target_id
histone_target.histone_target_id
Restrict delete
chip_seq_signal_fkey
chip_seq.signal
replicate_set.replicate_set_id
Restrict delete
chip_seq_experiment_id_fkey
chip_seq.experiment_id
experiment.experiment_id
Restrict delete
posix_file_file_id_fkey
posix_file.file_id
file.file_id
Restrict delete
replicate_set_data_source_id_fkey
replicate_set.data_source_id
data_source.data_source_id
Restrict delete
inclusion_list_file_id_fkey
inclusion_list.file_id
file.file_id
Restrict delete
file_data_source_id_fkey
file.data_source_id
data_source.data_source_id
Restrict delete
rna_seq_experiment_id_fkey
rna_seq.experiment_id
experiment.experiment_id
Restrict delete
rna_seq_replicate_set_id_fkey
rna_seq.replicate_set_id
replicate_set.replicate_set_id
Restrict delete
biosample_set_data_source_id_fkey
biosample_set.data_source_id
data_source.data_source_id
Restrict delete
life_stage_ontology_id_fkey
life_stage.ontology_id
ontology.ontology_id
Restrict delete
atac_seq_experiment_id_fkey
atac_seq.experiment_id
experiment.experiment_id
Restrict delete
atac_seq_replicate_set_id_fkey
atac_seq.replicate_set_id
replicate_set.replicate_set_id
Restrict delete
run_data_source_id_fkey
run.data_source_id
data_source.data_source_id
Restrict delete
run_read_file_set_id_fkey
run.read_file_set_id
read_file_set.read_file_set_id
Restrict delete
replicate_replicate_set_id_fkey
replicate.replicate_set_id
replicate_set.replicate_set_id
Restrict delete
replicate_read_file_set_id_fkey
replicate.read_file_set_id
read_file_set.read_file_set_id
Restrict delete
replicate_data_source_id_fkey
replicate.data_source_id
data_source.data_source_id
Restrict delete
replicate_biosample_set_id_fkey
replicate.biosample_set_id
biosample_set.biosample_set_id
Restrict delete
experiment_data_source_id_fkey
experiment.data_source_id
data_source.data_source_id
Restrict delete
experiment_epigenome_id_fkey
experiment.epigenome_id
epigenome.epigenome_id
Restrict delete
track_epigenome_id_fkey
track.epigenome_id
epigenome.epigenome_id
Restrict delete
barcode_file_file_id_fkey
barcode_file.file_id
file.file_id
Restrict delete
barcode_file_run_id_fkey
barcode_file.run_id
run.run_id
Restrict delete
barcode_file_data_source_id_fkey
barcode_file.data_source_id
data_source.data_source_id
Restrict delete
multiome_sn_atac_seq_id_fkey
multiome.sn_atac_seq_id
replicate_set.replicate_set_id
Restrict delete
multiome_sn_rna_seq_id_fkey
multiome.sn_rna_seq_id
replicate_set.replicate_set_id
Restrict delete
multiome_experiment_id_fkey
multiome.experiment_id
experiment.experiment_id
Restrict delete
alignment_file_file_id_fkey
alignment_file.file_id
file.file_id
Restrict delete
alignment_file_alignment_task_id_fkey
alignment_file.alignment_task_id
alignment_task.alignment_task_id
Restrict delete
alignment_file_read_file_set_id_fkey
alignment_file.read_file_set_id
read_file_set.read_file_set_id
Restrict delete
alignment_file_assembly_id_fkey
alignment_file.assembly_id
assembly.assembly_id
Restrict delete
read_file_file_id_fkey
read_file.file_id
file.file_id
Restrict delete
read_file_run_id_fkey
read_file.run_id
run.run_id
Restrict delete
read_file_data_source_id_fkey
read_file.data_source_id
data_source.data_source_id
Restrict delete
read_file_read_file_set_id_fkey
read_file.read_file_set_id
read_file_set.read_file_set_id
Restrict delete
public_url_file_id_fkey
public_url.file_id
file.file_id
Restrict delete
epigenome_epigenome_group_id_fkey
epigenome.epigenome_group_id
epigenome_group.epigenome_group_id
Restrict delete
epigenome_data_source_id_fkey
epigenome.data_source_id
data_source.data_source_id
Restrict delete
epigenome_species_id_fkey
epigenome.species_id
species.species_id
Restrict delete
epigenome_alternative_data_source_id_fkey
epigenome.alternative_data_source_id
data_source.data_source_id
Restrict delete
read_file_set_data_source_id_fkey
read_file_set.data_source_id
data_source.data_source_id
Restrict delete
epigenome_group_data_source_id_fkey
epigenome_group.data_source_id
data_source.data_source_id
Restrict delete

Check Constraints

Table Constraint Name Constraint