SchemaSpy Analysis of gmbuilder.public - Constraints Generated by
SchemaSpy
139 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
fk13cf31f5e4a69ea2 namelisttype_consortiumorperson.namelisttype_consortiumorperson_hjid namelisttype.hjid Restrict delete 
fk1603aca37c00d25a keywordtype.entrytype_keyword_hjid entrytype.hjid Restrict delete 
fk1973ee7aa4a5f7ef referencetype_scope.referencetype_scope_hjid referencetype.hjid Restrict delete 
fk1d8423bec7e8e1c4 bpccommentgroupabsorptiontype.max evidencedstringtype.hjid Restrict delete 
fk208663aca2ddba4 entrytype_comment.entrytype_comment_hjid entrytype.hjid Restrict delete 
fk261f89fdf8d2e7e4 organismtype_lineagetype_taxon.organismtype_lineagetype_taxon_hjid organismtype_lineagetype.hjid Restrict delete 
fk28877d356470105 isoformtype_nametype_evidence.isoformtype_nametype_evidence_hjid isoformtype_nametype.hjid Restrict delete 
fk297cc9ffab33cea3 def_content.def_content_hjid def.hjid Restrict delete 
fk2a4f7136191784 positiontype_evidence.positiontype_evidence_hjid positiontype.hjid Restrict delete 
fk2b00f6354e30b06d proteintype_componenttype.allergenname evidencedstringtype.hjid Restrict delete 
fk2b00f6358ba451bd proteintype_componenttype.recommendedname proteinnamegrouprecommendednametype.hjid Restrict delete 
fk2b00f635b41920e6 proteintype_componenttype.proteintype_component_hjid proteintype.hjid Restrict delete 
fk2b00f635e2f9b389 proteintype_componenttype.biotechname evidencedstringtype.hjid Restrict delete 
fk2df63471bd35b898 referencetype_evidence.referencetype_evidence_hjid referencetype.hjid Restrict delete 
fk3055bc647f1c3193 genelocationtype.entrytype_genelocation_hjid entrytype.hjid Restrict delete 
fk340e93f1325554 keywordtype_evidence.keywordtype_evidence_hjid keywordtype.hjid Restrict delete 
fk3476d05e4cb1a72 entrytype_name.entrytype_name_hjid entrytype.hjid Restrict delete 
fk3492c215a693e7c uniprotsourcetype.dbreference dbreferencetype.hjid Restrict delete 
fk3691f25131242c68 evidencetype.source uniprotsourcetype.hjid Restrict delete 
fk3691f25187be97a6 evidencetype.entrytype_evidence_hjid entrytype.hjid Restrict delete 
fk3691f251aabb5e2e evidencetype.importedfrom importedfromtype.hjid Restrict delete 
fk3c582567b0fc9151 sourcedatatype_straintype_evidence.sourcedatatype_straintype_evidence_hjid sourcedatatype_straintype.hjid Restrict delete 
fk43aa44c77ed8ea01 header_content.header_content_hjid header.hjid Restrict delete 
fk4419093d4e30b06d proteintype.allergenname evidencedstringtype.hjid Restrict delete 
fk4419093d8ba451bd proteintype.recommendedname proteinnamegrouprecommendednametype.hjid Restrict delete 
fk4419093de2f9b389 proteintype.biotechname evidencedstringtype.hjid Restrict delete 
fk44b91f4c167da5b0 organismtype.lineage organismtype_lineagetype.hjid Restrict delete 
fk44b91f4c46dcd7e3 organismtype.entrytype_organismhost_hjid entrytype.hjid Restrict delete 
fk45a90ea6243777ae featuretype_evidence.featuretype_evidence_hjid featuretype.hjid Restrict delete 
fk45d53f98108a5f95 evidencedstringtype.bpccommentgroupkineticstype_km_hjid bpccommentgroupkineticstype.hjid Restrict delete 
fk45d53f9817115ac8 evidencedstringtype.bpccommentgrouptemperaturedependencetype_text_hjid bpccommentgrouptemperaturedependencetype.hjid Restrict delete 
fk45d53f9828b45ac8 evidencedstringtype.subcellularlocationtype_topology_hjid subcellularlocationtype.hjid Restrict delete 
fk45d53f9833363ee4 evidencedstringtype.proteintype_domaintype_innname_hjid proteintype_domaintype.hjid Restrict delete 
fk45d53f9836f8ec94 evidencedstringtype.bpccommentgroupabsorptiontype_text_hjid bpccommentgroupabsorptiontype.hjid Restrict delete 
fk45d53f98440fd91c evidencedstringtype.proteinnamegrouprecommendednametype_shortname_hjid proteinnamegrouprecommendednametype.hjid Restrict delete 
fk45d53f984a8788c9 evidencedstringtype.bpccommentgroupkineticstype_vmax_hjid bpccommentgroupkineticstype.hjid Restrict delete 
fk45d53f984d48b4dc evidencedstringtype.proteinnamegrouprecommendednametype_ecnumber_hjid proteinnamegrouprecommendednametype.hjid Restrict delete 
fk45d53f9857f232cf evidencedstringtype.proteintype_innname_hjid proteintype.hjid Restrict delete 
fk45d53f986a2c70de evidencedstringtype.bpccommentgroupredoxpotentialtype_text_hjid bpccommentgroupredoxpotentialtype.hjid Restrict delete 
fk45d53f987de00adc evidencedstringtype.proteinnamegroupalternativenametype_shortname_hjid proteinnamegroupalternativenametype.hjid Restrict delete 
fk45d53f989043d942 evidencedstringtype.subcellularlocationtype_location_hjid subcellularlocationtype.hjid Restrict delete 
fk45d53f9891c845aa evidencedstringtype.commenttype_text_hjid commenttype.hjid Restrict delete 
fk45d53f9898922c00 evidencedstringtype.proteinnamegroupalternativenametype_ecnumber_hjid proteinnamegroupalternativenametype.hjid Restrict delete 
fk45d53f9899b8b42a evidencedstringtype.proteintype_componenttype_innname_hjid proteintype_componenttype.hjid Restrict delete 
fk45d53f989cd1342a evidencedstringtype.bpccommentgroupkineticstype_text_hjid bpccommentgroupkineticstype.hjid Restrict delete 
fk45d53f98a678d7fe evidencedstringtype.isoformtype_text_hjid isoformtype.hjid Restrict delete 
fk45d53f98bfb584f4 evidencedstringtype.bpccommentgroupphdependencetype_text_hjid bpccommentgroupphdependencetype.hjid Restrict delete 
fk45d53f98c23c0be6 evidencedstringtype.proteintype_componenttype_cdantigenname_hjid proteintype_componenttype.hjid Restrict delete 
fk45d53f98dcf8b39c evidencedstringtype.proteinnamegroupsubmittednametype_ecnumber_hjid proteinnamegroupsubmittednametype.hjid Restrict delete 
fk45d53f98e6dad713 evidencedstringtype.subcellularlocationtype_orientation_hjid subcellularlocationtype.hjid Restrict delete 
fk45d53f98e79b22e0 evidencedstringtype.proteintype_domaintype_cdantigenname_hjid proteintype_domaintype.hjid Restrict delete 
fk45d53f98ecf3308b evidencedstringtype.proteintype_cdantigenname_hjid proteintype.hjid Restrict delete 
fk4cf1bb3022d4956d featuretype.entrytype_feature_hjid entrytype.hjid Restrict delete 
fk4cf1bb302d6b089c featuretype.location locationtype.hjid Restrict delete 
fk50bcd190a693e7c commenttype_diseasetype.dbreference dbreferencetype.hjid Restrict delete 
fk515d54132a4b85c3 synonymcategory_content.synonymcategory_content_hjid synonymcategory.hjid Restrict delete 
fk55102ddd751fd9c0 commenttype_evidence.commenttype_evidence_hjid commenttype.hjid Restrict delete 
fk56dbdfa6a29f821 term_content.term_content_hjid term.hjid Restrict delete 
fk5adfa2ac25cd0850 entrytype.proteinexistence proteinexistencetype.hjid Restrict delete 
fk5adfa2ac3fcd2588 entrytype.protein proteintype.hjid Restrict delete 
fk5adfa2ac4029d2b4 entrytype.sequence sequencetype.hjid Restrict delete 
fk5adfa2ac48f8f456 entrytype.organism organismtype.hjid Restrict delete 
fk5adfa2ac4b853b11 entrytype.uniprottype_entry_hjid uniprottype.hjid Restrict delete 
fk65214af9d640322 locationtype.commenttype_location_hjid commenttype.hjid Restrict delete 
fk65214afc19e1136 locationtype.endposition positiontype.hjid Restrict delete 
fk65214afc7310104 locationtype.begin positiontype.hjid Restrict delete 
fk65214afee2f2184 locationtype.position positiontype.hjid Restrict delete 
fk664f62852b4eafe3 typedef_content.typedef_content_hjid typedef.hjid Restrict delete 
fk6f5452b2bcd5b9d1 commenttype_conflicttype.sequence commenttype_conflicttype_sequencetype.hjid Restrict delete 
fk6fb5300fcb570028 genetype.entrytype_gene_hjid entrytype.hjid Restrict delete 
fk70e93bf5ae1585e3 synonym_content.synonym_content_hjid synonym.hjid Restrict delete 
fk7709318f1748f9fa proteinnamegrouprecommendednametype.fullname evidencedstringtype.hjid Restrict delete 
fk77a1429debb8faa3 subsetdef_content.subsetdef_content_hjid subsetdef.hjid Restrict delete 
fk7951b8d4603ad4e9 eventtype.commenttype_event_hjid commenttype.hjid Restrict delete 
fk7acb6572c102b4a1 relationship_content.relationship_content_hjid relationship.hjid Restrict delete 
fk7c6ca8a21de5f9e1 sourcedatatype_plasmidtype_evidence.sourcedatatype_plasmidtype_evidence_hjid sourcedatatype_plasmidtype.hjid Restrict delete 
fk7c9796e1f22c5486 citationtype.editorlist namelisttype.hjid Restrict delete 
fk7c9796e1f57415a4 citationtype.authorlist namelisttype.hjid Restrict delete 
fk7e0b957a6ef53e01 intersectionof_content.intersectionof_content_hjid intersectionof.hjid Restrict delete 
fk855cd28f121da37c dbreferencetype_evidence.dbreferencetype_evidence_hjid dbreferencetype.hjid Restrict delete 
fk856ab5da6ecf92fd commenttype_linktype.commenttype_link_hjid commenttype.hjid Restrict delete 
fk859a666c5b7ca8f2 statustype.genelocationtype_name_hjid genelocationtype.hjid Restrict delete 
fk85fa8a0a51d1b216 organismtype_evidence.organismtype_evidence_hjid organismtype.hjid Restrict delete 
fk872c08e11748f9fa proteinnamegroupalternativenametype.fullname evidencedstringtype.hjid Restrict delete 
fk872c08e154d01ca0 proteinnamegroupalternativenametype.proteintype_domaintype_alternativename_hjid proteintype_domaintype.hjid Restrict delete 
fk872c08e15abf3d8b proteinnamegroupalternativenametype.proteintype_alternativename_hjid proteintype.hjid Restrict delete 
fk872c08e1d2ff36e6 proteinnamegroupalternativenametype.proteintype_componenttype_alternativename_hjid proteintype_componenttype.hjid Restrict delete 
fk89e3456a586f5be1 synonymtypedef_content.synonymtypedef_content_hjid synonymtypedef.hjid Restrict delete 
fk8f0bd50510f9e9b2 referencetype.source sourcedatatype.hjid Restrict delete 
fk8f0bd50574685d78 referencetype.entrytype_reference_hjid entrytype.hjid Restrict delete 
fk8f0bd505dc62f600 referencetype.citation citationtype.hjid Restrict delete 
fk8f6d77774ebd64e2 organismnametype.organismtype_name_hjid organismtype.hjid Restrict delete 
fk93d161776be415d0 isoformtype_id.isoformtype_id_hjid isoformtype.hjid Restrict delete 
fk960bae257294c361 xrefanalog_content.xrefanalog_content_hjid xrefanalog.hjid Restrict delete 
fk97a65c558d7ee0c1 source_content.source_content_hjid source.hjid Restrict delete 
fk981cf98352dffc35 isoformtype.sequence isoformtype_sequencetype.hjid Restrict delete 
fk981cf9838394509a isoformtype.commenttype_isoform_hjid commenttype.hjid Restrict delete 
fka262bf750217c31 sourcedatatype_tissuetype_evidence.sourcedatatype_tissuetype_evidence_hjid sourcedatatype_tissuetype.hjid Restrict delete 
fka61e68c1950ed528 cofactortype_evidence.cofactortype_evidence_hjid cofactortype.hjid Restrict delete 
fka6f63ba4953dd530 featuretype_variation.featuretype_variation_hjid featuretype.hjid Restrict delete 
fkaef4dfc12ddc4d60 isoformtype_nametype.isoformtype_name_hjid isoformtype.hjid Restrict delete 
fkb84fff3e19bd1e5e evidencedstringtype_evidence.evidencedstringtype_evidence_hjid evidencedstringtype.hjid Restrict delete 
fkbaf8c548a693e7c importedfromtype.dbreference dbreferencetype.hjid Restrict delete 
fkbce14911c04a4e7d sourcedatatype_transposontype_evidence.sourcedatatype_transposontype_evidence_hjid sourcedatatype_transposontype.hjid Restrict delete 
fkc40db65cdd630c52 genenametype_evidence.genenametype_evidence_hjid genenametype.hjid Restrict delete 
fkc89d6ebaef1d7aa8 genenametype.genetype_name_hjid genetype.hjid Restrict delete 
fkca5bd2f07fe97b63 sourcedatatype_strainorplasmidortransposon.sourcedatatype_strainorplasmidortransposon_hjid sourcedatatype.hjid Restrict delete 
fkcc1f36a9f7c3adc3 xrefunknown_content.xrefunknown_content_hjid xrefunknown.hjid Restrict delete 
fkd2ec78d3f25e5d81 dbxref_content.dbxref_content_hjid dbxref.hjid Restrict delete 
fkd64442cf68b562be propertytype.dbreferencetype_property_hjid dbreferencetype.hjid Restrict delete 
fkdab41539501d42c4 subcellularlocationtype.commenttype_subcellularlocation_hjid commenttype.hjid Restrict delete 
fkdb2127f250a6ba26 genelocationtype_evidence.genelocationtype_evidence_hjid genelocationtype.hjid Restrict delete 
fkdcfa0aabdb8bd172 interactanttype.commenttype_interactant_hjid commenttype.hjid Restrict delete 
fke0cb5219236a6dbe commenttype.molecule moleculetype.hjid Restrict delete 
fke0cb521925e10d55 commenttype.absorption bpccommentgroupabsorptiontype.hjid Restrict delete 
fke0cb521966aa2ef5 commenttype.phdependence bpccommentgroupphdependencetype.hjid Restrict delete 
fke0cb52196e81953 commenttype.temperaturedependence bpccommentgrouptemperaturedependencetype.hjid Restrict delete 
fke0cb5219cfa3bf01 commenttype.conflict commenttype_conflicttype.hjid Restrict delete 
fke0cb5219d49cbcdf commenttype.redoxpotential bpccommentgroupredoxpotentialtype.hjid Restrict delete 
fke0cb5219d8cf5aeb commenttype.kinetics bpccommentgroupkineticstype.hjid Restrict delete 
fke0cb5219ea21feef commenttype.disease commenttype_diseasetype.hjid Restrict delete 
fke2ce5e1ca5a60d12 relation.holdsoverchain_relation_hjid holdsoverchain.hjid Restrict delete 
fke3f7c6802d1c63b proteintype_domaintype.proteintype_domain_hjid proteintype.hjid Restrict delete 
fke3f7c6804e30b06d proteintype_domaintype.allergenname evidencedstringtype.hjid Restrict delete 
fke3f7c6808ba451bd proteintype_domaintype.recommendedname proteinnamegrouprecommendednametype.hjid Restrict delete 
fke3f7c680e2f9b389 proteintype_domaintype.biotechname evidencedstringtype.hjid Restrict delete 
fke43b3d27236a6dbe dbreferencetype.molecule moleculetype.hjid Restrict delete 
fke43b3d2762738266 dbreferencetype.organismtype_dbreference_hjid organismtype.hjid Restrict delete 
fke43b3d279338ff06 dbreferencetype.citationtype_dbreference_hjid citationtype.hjid Restrict delete 
fke43b3d27e13d04b6 dbreferencetype.entrytype_dbreference_hjid entrytype.hjid Restrict delete 
fke7560cc5798d57e3 idspace_content.idspace_content_hjid idspace.hjid Restrict delete 
fke8dc0bf63fb25803 obo_content.obo_content_hjid obo.hjid Restrict delete 
fkf248bbef1748f9fa proteinnamegroupsubmittednametype.fullname evidencedstringtype.hjid Restrict delete 
fkf248bbef5298f7d8 proteinnamegroupsubmittednametype.proteintype_componenttype_submittedname_hjid proteintype_componenttype.hjid Restrict delete 
fkf248bbef77f80ed2 proteinnamegroupsubmittednametype.proteintype_domaintype_submittedname_hjid proteintype_domaintype.hjid Restrict delete 
fkf248bbef7d501c7d proteinnamegroupsubmittednametype.proteintype_submittedname_hjid proteintype.hjid Restrict delete 
fkf3878e31135b043f entrytype_accession.entrytype_accession_hjid entrytype.hjid Restrict delete 
fkfe1886b59e6bd1dc cofactortype.commenttype_cofactor_hjid commenttype.hjid Restrict delete 
fkfe1886b5a693e7c cofactortype.dbreference dbreferencetype.hjid Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected