SchemaSpy Analysis of test_seqware_meta_db.public - Constraints Generated by
SchemaSpy
100 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
expense_attribute_expense_id_fkey expense_attribute.expense_id expense.expense_id Restrict delete 
experiment__owner_fk experiment.owner_id registration.registration_id Restrict delete 
experiment_attribute_experiment_id_fkey experiment_attribute.experiment_id experiment.experiment_id Restrict delete 
experiment_experiment_library_design_id_fkey experiment.experiment_library_design_id experiment_library_design.experiment_library_design_id Restrict delete 
experiment_experiment_spot_design_id_fkey experiment.experiment_spot_design_id experiment_spot_design.experiment_spot_design_id Restrict delete 
experiment_library_design_selection_fkey experiment_library_design.selection library_selection.library_selection_id Restrict delete 
experiment_library_design_source_fkey experiment_library_design.source library_source.library_source_id Restrict delete 
experiment_library_design_strategy_fkey experiment_library_design.strategy library_strategy.library_strategy_id Restrict delete 
experiment_link_experiment_id_fkey experiment_link.experiment_id experiment.experiment_id Restrict delete 
experiment_platform_id_fkey experiment.platform_id platform.platform_id Restrict delete 
experiment_spot_design_read_spec_experiment_spot_design_id_fkey experiment_spot_design_read_spec.experiment_spot_design_id experiment_spot_design.experiment_spot_design_id Restrict delete 
experiment_study_id_fkey experiment.study_id study.study_id Restrict delete 
file_id workflow_run_input_files.file_id file.file_id Restrict delete 
fk2d251a1c685fba9d workflow_attribute.workflow_id workflow.workflow_id Restrict delete 
fk35f09d686071c5f8 workflow_run_attribute.workflow_run_id workflow_run.workflow_run_id Restrict delete 
fk48cd19ddcc73e37d sample_search.sample_id sample.sample_id Restrict delete 
fk7750ef99bb4f9efd file_attribute.file_id file.file_id Restrict delete 
fk_file_file_type_id file.file_type_id file_type.file_type_id Restrict delete 
fk_file_owner_id file.owner_id registration.registration_id Restrict delete 
fk_ius_link_ius_id ius_link.ius_id ius.ius_id Restrict delete 
fk_ius_owner_id ius.owner_id registration.registration_id Restrict delete 
fk_ius_workflow_runs_ius_id ius_workflow_runs.ius_id ius.ius_id Restrict delete 
fk_ius_workflow_runs_workflow_run_id ius_workflow_runs.workflow_run_id workflow_run.workflow_run_id Restrict delete 
fk_lane_link_lane_id lane_link.lane_id lane.lane_id Restrict delete 
fk_lane_workflow_runs_lane_id lane_workflow_runs.lane_id lane.lane_id Restrict delete 
fk_lane_workflow_runs_workflow_run_id lane_workflow_runs.workflow_run_id workflow_run.workflow_run_id Restrict delete 
fk_processing_owner_id processing.owner_id registration.registration_id Restrict delete 
fk_sequencer_run_attribute_sequencer_run_id sequencer_run_attribute.sample_id sequencer_run.sequencer_run_id Restrict delete 
fk_share_experiment_experiment_id share_experiment.experiment_id experiment.experiment_id Restrict delete 
fk_share_experiment_registration_id share_experiment.registration_id registration.registration_id Restrict delete 
fk_share_file_file_id share_file.file_id file.file_id Restrict delete 
fk_share_file_registration_id share_file.registration_id registration.registration_id Restrict delete 
fk_share_lane_lane_id share_lane.lane_id lane.lane_id Restrict delete 
fk_share_lane_registration_id share_lane.registration_id registration.registration_id Restrict delete 
fk_share_processing_processing_id share_processing.processing_id processing.processing_id Restrict delete 
fk_share_processing_registration_id share_processing.registration_id registration.registration_id Restrict delete 
fk_share_sample_registration_id share_sample.registration_id registration.registration_id Restrict delete 
fk_share_sample_sample_id share_sample.sample_id sample.sample_id Restrict delete 
fk_share_study_registration_id share_study.registration_id registration.registration_id Restrict delete 
fk_share_study_study_id share_study.study_id study.study_id Restrict delete 
fk_share_workflow_run_registration_id share_workflow_run.registration_id registration.registration_id Restrict delete 
fk_share_workflow_run_workflow_run_id share_workflow_run.workflow_run_id workflow_run.workflow_run_id Restrict delete 
fk_workflow_param_value_workflow_param_id workflow_param_value.workflow_param_id workflow_param.workflow_param_id Restrict delete 
fk_workflow_param_workflow_id workflow_param.workflow_id workflow.workflow_id Restrict delete 
fk_workflow_registration_id workflow.owner_id registration.registration_id Restrict delete 
fk_workflow_run_param_workflow_run_id workflow_run_param.workflow_run_id workflow_run.workflow_run_id Restrict delete 
fk_workflow_run_registration_id workflow_run.owner_id registration.registration_id Restrict delete 
fkf378ceba921d0a72 sample_search_attribute.sample_search_id sample_search.sample_search_id Restrict delete 
invoice_attribute_invoice_id_fkey invoice_attribute.invoice_id invoice.invoice_id Restrict delete 
invoice_id_fk expense.invoice_id invoice.invoice_id Restrict delete 
invoice_owner_id_fk invoice.owner_id registration.registration_id Restrict delete 
ius__lane_fk ius.lane_id lane.lane_id Restrict delete 
ius__sample_fk ius.sample_id sample.sample_id Restrict delete 
ius_attribute_ius_id_fkey ius_attribute.ius_id ius.ius_id Restrict delete 
lane_attribute_lane_id_fkey lane_attribute.lane_id lane.lane_id Restrict delete 
lane_library_selection_fkey lane.library_selection library_selection.library_selection_id Restrict delete 
lane_library_source_fkey lane.library_source library_source.library_source_id Restrict delete 
lane_library_strategy_fkey lane.library_strategy library_strategy.library_strategy_id Restrict delete 
lane_organism_id_fkey lane.organism_id organism.organism_id Restrict delete 
lane_owner_id_fkey lane.owner_id registration.registration_id Restrict delete 
lane_sample_id_fkey lane.sample_id sample.sample_id Restrict delete 
lane_sequencer_run_id_fkey lane.sequencer_run_id sequencer_run.sequencer_run_id Restrict delete 
lane_study_type_fkey lane.study_type study_type.study_type_id Restrict delete 
lane_type_fkey lane.type lane_type.lane_type_id Restrict delete 
processing_ancestor_workflow_run_id_fkey processing.ancestor_workflow_run_id workflow_run.workflow_run_id Restrict delete 
processing_attribute_processing_id_fkey processing_attribute.processing_id processing.processing_id Restrict delete 
processing_experiments_experiment_id_fkey processing_experiments.experiment_id experiment.experiment_id Restrict delete 
processing_experiments_processing_id_fkey processing_experiments.processing_id processing.processing_id Restrict delete 
processing_files_file_id_fkey processing_files.file_id file.file_id Restrict delete 
processing_files_processing_id_fkey processing_files.processing_id processing.processing_id Restrict delete 
processing_ius_ius_id_fkey processing_ius.ius_id ius.ius_id Restrict delete 
processing_ius_processing_id_fkey processing_ius.processing_id processing.processing_id Restrict delete 
processing_lanes_lane_id_fkey processing_lanes.lane_id lane.lane_id Restrict delete 
processing_lanes_processing_id_fkey processing_lanes.processing_id processing.processing_id Restrict delete 
processing_relationship_child_id_fkey processing_relationship.child_id processing.processing_id Cascade on delete 
processing_relationship_parent_id_fkey processing_relationship.parent_id processing.processing_id Restrict delete 
processing_samples_processing_id_fkey processing_samples.processing_id processing.processing_id Restrict delete 
processing_samples_sample_id_fkey processing_samples.sample_id sample.sample_id Restrict delete 
processing_sequencer_runs_processing_id_fkey processing_sequencer_runs.processing_id processing.processing_id Restrict delete 
processing_sequencer_runs_sequencer_run_id_fkey processing_sequencer_runs.sequencer_run_id sequencer_run.sequencer_run_id Restrict delete 
processing_studies_processing_id_fkey processing_studies.processing_id processing.processing_id Restrict delete 
processing_studies_study_id_fkey processing_studies.study_id study.study_id Restrict delete 
processing_workflow_run_id_fkey processing.workflow_run_id workflow_run.workflow_run_id Restrict delete 
sample__organism_fk sample.organism_id organism.organism_id Restrict delete 
sample__owner_fk sample.owner_id registration.registration_id Restrict delete 
sample_attribute_sample_id_fkey sample_attribute.sample_id sample.sample_id Restrict delete 
sample_experiment_id_fkey sample.experiment_id experiment.experiment_id Restrict delete 
sample_hierarchy_parent_id_fkey sample_hierarchy.parent_id sample.sample_id Restrict delete 
sample_hierarchy_sample_id_fkey sample_hierarchy.sample_id sample.sample_id Restrict delete 
sample_link_sample_id_fkey sample_link.sample_id sample.sample_id Restrict delete 
sample_relationship_child_id_fkey sample_relationship.child_id sample.sample_id Cascade on delete 
sample_relationship_parent_id_fkey sample_relationship.parent_id sample.sample_id Restrict delete 
sequencer_run_owner_id_fkey sequencer_run.owner_id registration.registration_id Restrict delete 
sequencer_run_platform_id_fkey sequencer_run.platform_id platform.platform_id Restrict delete 
study_attribute_study_id_fkey study_attribute.study_id study.study_id Restrict delete 
study_existing_type_fkey study.existing_type study_type.study_type_id Restrict delete 
study_link_study_id_fkey study_link.study_id study.study_id Restrict delete 
study_owner_id_fkey study.owner_id registration.registration_id Restrict delete 
workflow_run_id workflow_run_input_files.workflow_run_id workflow_run.workflow_run_id Restrict delete 
workflow_run_workflow_id_fkey workflow_run.workflow_id workflow.workflow_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected