SchemaSpy Analysis of cxgn.phenome - Constraints

Generated by
SchemaSpy
131 Foreign Key Constraints:
SourceForge.net
Please support this project

Constraint Name Child Column Parent Column
allele_alias_allele_id_fkey allele_alias.allele_id allele.allele_id
allele_alias_sp_person_id_fkey allele_alias.sp_person_id
allele_dbxref_allele_id_fkey allele_dbxref.allele_id allele.allele_id
allele_dbxref_dbxref_id_fkey allele_dbxref.dbxref_id
allele_dbxref_sp_person_id_fkey allele_dbxref.sp_person_id
allele_history_allele_id_fkey allele_history.allele_id allele.allele_id
allele_history_locus_id_fkey allele_history.locus_id locus.locus_id
allele_history_sp_person_id_fkey allele_history.sp_person_id
allele_history_updated_by_fkey allele_history.updated_by
allele_locus_id_fkey allele.locus_id locus.locus_id
allele_sp_person_id_fkey allele.sp_person_id
allele_updated_by_fkey allele.updated_by
genotype_background_accession_id_fkey genotype.background_accession_id
genotype_experiment_background_accession_id_fkey genotype_experiment.background_accession_id
genotype_experiment_reference_map_id_fkey genotype_experiment.reference_map_id
genotype_experiment_sp_person_id_fkey genotype_experiment.sp_person_id
genotype_genotype_experiment_id_fkey genotype.genotype_experiment_id genotype_experiment.genotype_experiment_id
genotype_individual_id_fkey genotype.individual_id individual.individual_id
genotype_reference_map_id_fkey genotype.reference_map_id
genotype_region_genotype_id_fkey genotype_region.genotype_id genotype.genotype_id
genotype_region_lg_id_fkey genotype_region.lg_id
genotype_region_marker_id_nn_fkey genotype_region.marker_id_nn
genotype_region_marker_id_ns_fkey genotype_region.marker_id_ns
genotype_region_marker_id_sn_fkey genotype_region.marker_id_sn
genotype_region_marker_id_ss_fkey genotype_region.marker_id_ss
genotype_region_sp_person_id_fkey genotype_region.sp_person_id
genotype_sp_person_id_fkey genotype.sp_person_id
germplasm_dbxref_id_fkey germplasm.dbxref_id
germplasm_individual_id_fkey germplasm.individual_id individual.individual_id
germplasm_sp_person_id_fkey germplasm.sp_person_id
image_phenotype_id_fkey image.phenotype_id phenotype.phenotype_id
individual_allele_allele_id_fkey individual_allele.allele_id allele.allele_id
individual_allele_individual_id_fkey individual_allele.individual_id individual.individual_id
individual_allele_sp_person_id_fkey individual_allele.sp_person_id
individual_common_name_id_fkey individual.common_name_id
individual_dbxref_dbxref_id_fkey individual_dbxref.dbxref_id
individual_dbxref_evidence_evidence_code_fkey individual_dbxref_evidence.evidence_code
individual_dbxref_evidence_evidence_description_fkey individual_dbxref_evidence.evidence_description
individual_dbxref_evidence_evidence_with_fkey individual_dbxref_evidence.evidence_with
individual_dbxref_evidence_hi_individual_dbxref_evidence_i_fkey individual_dbxref_evidence_history.individual_dbxref_evidence_id individual_dbxref_evidence.individual_dbxref_evidence_id
individual_dbxref_evidence_history_evidence_code_fkey individual_dbxref_evidence_history.evidence_code
individual_dbxref_evidence_history_evidence_description_fkey individual_dbxref_evidence_history.evidence_description
individual_dbxref_evidence_history_evidence_with_fkey individual_dbxref_evidence_history.evidence_with
individual_dbxref_evidence_history_individual_dbxref_id_fkey individual_dbxref_evidence_history.individual_dbxref_id individual_dbxref.individual_dbxref_id
individual_dbxref_evidence_history_reference_id_fkey individual_dbxref_evidence_history.reference_id
individual_dbxref_evidence_history_relationship_type_fkey individual_dbxref_evidence_history.relationship_type
individual_dbxref_evidence_history_sp_person_id_fkey individual_dbxref_evidence_history.sp_person_id
individual_dbxref_evidence_history_updated_by_fkey individual_dbxref_evidence_history.updated_by
individual_dbxref_evidence_individual_dbxref_id_fkey individual_dbxref_evidence.individual_dbxref_id individual_dbxref.individual_dbxref_id
individual_dbxref_evidence_reference_id_fkey individual_dbxref_evidence.reference_id
individual_dbxref_evidence_relationship_type_fkey individual_dbxref_evidence.relationship_type
individual_dbxref_evidence_sp_person_id_fkey individual_dbxref_evidence.sp_person_id
individual_dbxref_evidence_updated_by_fkey individual_dbxref_evidence.updated_by
individual_dbxref_individual_id_fkey individual_dbxref.individual_id individual.individual_id
individual_dbxref_sp_person_id_fkey individual_dbxref.sp_person_id
individual_history_individual_id_fkey individual_history.individual_id individual.individual_id
individual_history_sp_person_id_fkey individual_history.sp_person_id
individual_history_updated_by_fkey individual_history.updated_by
individual_locus_individual_id_fkey individual_locus.individual_id individual.individual_id
individual_locus_locus_id_fkey individual_locus.locus_id locus.locus_id
individual_locus_sp_person_id_fkey individual_locus.sp_person_id
individual_population_id_fkey individual.population_id population.population_id
individual_sp_person_id_fkey individual.sp_person_id
individual_updated_by_fkey individual.updated_by
locus2locus_evidence_id_fkey locus2locus.evidence_id
locus2locus_object_id_fkey locus2locus.object_id locus.locus_id
locus2locus_reference_id_fkey locus2locus.reference_id
locus2locus_relationship_id_fkey locus2locus.relationship_id
locus2locus_sp_person_id_fkey locus2locus.sp_person_id
locus2locus_subject_id_fkey locus2locus.subject_id locus.locus_id
locus_alias_locus_id_fkey locus_alias.locus_id locus.locus_id
locus_alias_sp_person_id_fkey locus_alias.sp_person_id
locus_common_name_id_fkey locus.common_name_id
locus_dbxref_dbxref_id_fkey locus_dbxref.dbxref_id
locus_dbxref_evidence_evidence_code_id_fkey locus_dbxref_evidence.evidence_code_id
locus_dbxref_evidence_evidence_description_id_fkey locus_dbxref_evidence.evidence_description_id
locus_dbxref_evidence_evidence_relationship_type_id_fkey locus_dbxref_evidence.relationship_type_id
locus_dbxref_evidence_evidence_with_fkey locus_dbxref_evidence.evidence_with
locus_dbxref_evidence_history_evidence_code_fkey locus_dbxref_evidence_history.evidence_code
locus_dbxref_evidence_history_evidence_description_fkey locus_dbxref_evidence_history.evidence_description
locus_dbxref_evidence_history_evidence_with_fkey locus_dbxref_evidence_history.evidence_with
locus_dbxref_evidence_history_locus_dbxref_evidence_id_fkey locus_dbxref_evidence_history.locus_dbxref_evidence_id locus_dbxref_evidence.locus_dbxref_evidence_id
locus_dbxref_evidence_history_locus_dbxref_id_fkey locus_dbxref_evidence_history.locus_dbxref_id locus_dbxref.locus_dbxref_id
locus_dbxref_evidence_history_reference_id_fkey locus_dbxref_evidence_history.reference_id
locus_dbxref_evidence_history_relationship_type_fkey locus_dbxref_evidence_history.relationship_type
locus_dbxref_evidence_history_sp_person_id_fkey locus_dbxref_evidence_history.sp_person_id
locus_dbxref_evidence_history_updated_by_fkey locus_dbxref_evidence_history.updated_by
locus_dbxref_evidence_locus_dbxref_id_fkey locus_dbxref_evidence.locus_dbxref_id locus_dbxref.locus_dbxref_id
locus_dbxref_evidence_reference_id_fkey locus_dbxref_evidence.reference_id
locus_dbxref_evidence_sp_person_id_fkey locus_dbxref_evidence.sp_person_id
locus_dbxref_evidence_updated_by_fkey locus_dbxref_evidence.updated_by
locus_dbxref_locus_id_fkey locus_dbxref.locus_id locus.locus_id
locus_dbxref_sp_person_id_fkey locus_dbxref.sp_person_id
locus_history_locus_id_fkey locus_history.locus_id locus.locus_id
locus_history_sp_person_id_fkey locus_history.sp_person_id
locus_history_updated_by_fkey locus_history.updated_by
locus_marker_locus_id_fkey locus_marker.locus_id locus.locus_id
locus_marker_marker_id_fkey locus_marker.marker_id
locus_marker_sp_person_id_fkey locus_marker.sp_person_id
locus_owner_granted_by_fkey locus_owner.granted_by
locus_owner_locus_id_fkey locus_owner.locus_id locus.locus_id
locus_owner_sp_person_id_fkey locus_owner.sp_person_id
locus_registry_locus_id_fkey locus_registry.locus_id locus.locus_id
locus_registry_registry_id_fkey locus_registry.registry_id registry.registry_id
locus_registry_sp_person_id_fkey locus_registry.sp_person_id
locus_sp_person_id_fkey locus.sp_person_id
locus_unigene_locus_id_fkey locus_unigene.locus_id locus.locus_id
locus_unigene_sp_person_id_fkey locus_unigene.sp_person_id
locus_unigene_unigene_id_fkey locus_unigene.unigene_id
locus_updated_by_fkey locus.updated_by
phenotype_allele_id_fkey phenotype.allele_id allele.allele_id
phenotype_locus_id_fkey phenotype.locus_id locus.locus_id
phenotype_population_id_fkey phenotype.population_id population.population_id
phenotype_term_phenotype_id_fkey phenotype_term.phenotype_id phenotype.phenotype_id
polymorphic_fragment_flanking_marker1_id_fkey polymorphic_fragment.flanking_marker1_id
polymorphic_fragment_flanking_marker2_id_fkey polymorphic_fragment.flanking_marker2_id
polymorphic_fragment_genotype_id_fkey polymorphic_fragment.genotype_id genotype.genotype_id
polymorphic_fragment_sp_person_id_fkey polymorphic_fragment.sp_person_id
population_background_accession_id_fkey population.background_accession_id
population_dbxref_dbxref_id_fkey population_dbxref.dbxref_id
population_dbxref_population_id_fkey population_dbxref.population_id population.population_id
population_dbxref_sp_person_id_fkey population_dbxref.sp_person_id
population_person_id_fkey population.person_id
population_sp_person_id_fkey population.sp_person_id
registry_sp_person_id_fkey registry.sp_person_id
registry_updated_by_fkey registry.updated_by
tomato_il_bin_n_marker_n_fkey tomato_il_bin.n_marker_n
tomato_il_bin_n_marker_s_fkey tomato_il_bin.n_marker_s
tomato_il_bin_s_marker_n_fkey tomato_il_bin.s_marker_n
tomato_il_bin_s_marker_s_fkey tomato_il_bin.s_marker_s
variant_locus_id_fkey variant.locus_id locus.locus_id

Check Constraints:

Table Constraint Name Constraint
None detected