SchemaSpy Analysis of uniprotdb.public - Constraints Back to documentation
XMLPipeDB
85 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
fk1603aca37c00d25a keywordtype.entrytype_keyword_hjid entrytype.hjid
fk1973ee7aa4a5f7ef referencetype_scope.referencetype_scope_hjid referencetype.hjid
fk208663aca2ddba4 entrytype_comment.entrytype_comment_hjid entrytype.hjid
fk261f89fdf8d2e7e4 organismtype_lineagetype_taxon.organismtype_lineagetype_taxon_hjid organismtype_lineagetype.hjid
fk2b00f6354e30b06d proteintype_componenttype.allergenname evidencedstringtype.hjid
fk2b00f6358ba451bd proteintype_componenttype.recommendedname proteinnamegrouprecommendednametype.hjid
fk2b00f635b41920e6 proteintype_componenttype.proteintype_component_hjid proteintype.hjid
fk2b00f635e2f9b389 proteintype_componenttype.biotechname evidencedstringtype.hjid
fk3055bc647f1c3193 genelocationtype.entrytype_genelocation_hjid entrytype.hjid
fk3055bc64b7cee32f genelocationtype.name statustype.hjid
fk3476d05e4cb1a72 entrytype_name.entrytype_name_hjid entrytype.hjid
fk3691f25187be97a6 evidencetype.entrytype_evidence_hjid entrytype.hjid
fk4419093d4e30b06d proteintype.allergenname evidencedstringtype.hjid
fk4419093d8ba451bd proteintype.recommendedname proteinnamegrouprecommendednametype.hjid
fk4419093de2f9b389 proteintype.biotechname evidencedstringtype.hjid
fk44b91f4c167da5b0 organismtype.lineage organismtype_lineagetype.hjid
fk44b91f4c3e7d0a0b organismtype.entrytype_organism_hjid entrytype.hjid
fk44b91f4c46dcd7e3 organismtype.entrytype_organismhost_hjid entrytype.hjid
fk452761f5969e4ea2 namelisttype_personorconsortium.namelisttype_personorconsortium_hjid namelisttype.hjid
fk45d53f9828b45ac8 evidencedstringtype.subcellularlocationtype_topology_hjid subcellularlocationtype.hjid
fk45d53f9833363ee4 evidencedstringtype.proteintype_domaintype_innname_hjid proteintype_domaintype.hjid
fk45d53f98440fd91c evidencedstringtype.proteinnamegrouprecommendednametype_shortname_hjid proteinnamegrouprecommendednametype.hjid
fk45d53f9857f232cf evidencedstringtype.proteintype_innname_hjid proteintype.hjid
fk45d53f987de00adc evidencedstringtype.proteinnamegroupalternativenametype_shortname_hjid proteinnamegroupalternativenametype.hjid
fk45d53f989043d942 evidencedstringtype.subcellularlocationtype_location_hjid subcellularlocationtype.hjid
fk45d53f9899b8b42a evidencedstringtype.proteintype_componenttype_innname_hjid proteintype_componenttype.hjid
fk45d53f98c23c0be6 evidencedstringtype.proteintype_componenttype_cdantigenname_hjid proteintype_componenttype.hjid
fk45d53f98e6dad713 evidencedstringtype.subcellularlocationtype_orientation_hjid subcellularlocationtype.hjid
fk45d53f98e79b22e0 evidencedstringtype.proteintype_domaintype_cdantigenname_hjid proteintype_domaintype.hjid
fk45d53f98ecf3308b evidencedstringtype.proteintype_cdantigenname_hjid proteintype.hjid
fk4cf1bb3022d4956d featuretype.entrytype_feature_hjid entrytype.hjid
fk4cf1bb302d6b089c featuretype.location locationtype.hjid
fk5a4f44644a8788c9 bpccommentgroupkineticstype_vmax.bpccommentgroupkineticstype_vmax_hjid bpccommentgroupkineticstype.hjid
fk5adfa2ac25cd0850 entrytype.proteinexistence proteinexistencetype.hjid
fk5adfa2ac3fcd2588 entrytype.protein proteintype.hjid
fk5adfa2ac4029d2b4 entrytype.sequence sequencetype.hjid
fk5adfa2ac4b853b11 entrytype.uniprottype_entry_hjid uniprottype.hjid
fk65214af9d640322 locationtype.commenttype_location_hjid commenttype.hjid
fk65214afc19e1136 locationtype.endposition positiontype.hjid
fk65214afc7310104 locationtype.begin positiontype.hjid
fk65214afee2f2184 locationtype.position positiontype.hjid
fk6f5452b2bcd5b9d1 commenttype_conflicttype.sequence commenttype_conflicttype_sequencetype.hjid
fk7709318f1748f9fa proteinnamegrouprecommendednametype.fullname evidencedstringtype.hjid
fk7951b8d4603ad4e9 eventtype.commenttype_event_hjid commenttype.hjid
fk7c9796e136491e54 citationtype.citingcitation citationtype.hjid
fk7c9796e1f22c5486 citationtype.editorlist namelisttype.hjid
fk7c9796e1f57415a4 citationtype.authorlist namelisttype.hjid
fk7f295df8108a5f95 bpccommentgroupkineticstype_km.bpccommentgroupkineticstype_km_hjid bpccommentgroupkineticstype.hjid
fk80090042cb570028 entrytype_genetype.entrytype_gene_hjid entrytype.hjid
fk856ab5da6ecf92fd commenttype_linktype.commenttype_link_hjid commenttype.hjid
fk872c08e11748f9fa proteinnamegroupalternativenametype.fullname evidencedstringtype.hjid
fk872c08e154d01ca0 proteinnamegroupalternativenametype.proteintype_domaintype_alternativename_hjid proteintype_domaintype.hjid
fk872c08e15abf3d8b proteinnamegroupalternativenametype.proteintype_alternativename_hjid proteintype.hjid
fk872c08e1d2ff36e6 proteinnamegroupalternativenametype.proteintype_componenttype_alternativename_hjid proteintype_componenttype.hjid
fk8f0bd50510f9e9b2 referencetype.source sourcedatatype.hjid
fk8f0bd50574685d78 referencetype.entrytype_reference_hjid entrytype.hjid
fk8f0bd505dc62f600 referencetype.citation citationtype.hjid
fk8f6d77774ebd64e2 organismnametype.organismtype_name_hjid organismtype.hjid
fk93d161776be415d0 isoformtype_id.isoformtype_id_hjid isoformtype.hjid
fk981cf9833419c097 isoformtype.note isoformtype_notetype.hjid
fk981cf98352dffc35 isoformtype.sequence isoformtype_sequencetype.hjid
fk981cf9838394509a isoformtype.commenttype_isoform_hjid commenttype.hjid
fka6f63ba4953dd530 featuretype_variation.featuretype_variation_hjid featuretype.hjid
fkaef4dfc12ddc4d60 isoformtype_nametype.isoformtype_name_hjid isoformtype.hjid
fkc89d6eba37ea5013 genenametype.entrytype_genetype_name_hjid entrytype_genetype.hjid
fkd57105c356b60b70 sourcedatatype_speciesorstrainorplasmid.sourcedatatype_speciesorstrainorplasmid_hjid sourcedatatype.hjid
fkd64442cf68b562be propertytype.dbreferencetype_property_hjid dbreferencetype.hjid
fkdab41539501d42c4 subcellularlocationtype.commenttype_subcellularlocation_hjid commenttype.hjid
fkdcfa0aabdb8bd172 interactanttype.commenttype_interactant_hjid commenttype.hjid
fke0cb521925e10d55 commenttype.absorption bpccommentgroupabsorptiontype.hjid
fke0cb5219c81d818d commenttype.text evidencedstringtype.hjid
fke0cb5219cfa3bf01 commenttype.conflict commenttype_conflicttype.hjid
fke0cb5219d8cf5aeb commenttype.kinetics bpccommentgroupkineticstype.hjid
fke3f7c6802d1c63b proteintype_domaintype.proteintype_domain_hjid proteintype.hjid
fke3f7c6804e30b06d proteintype_domaintype.allergenname evidencedstringtype.hjid
fke3f7c6808ba451bd proteintype_domaintype.recommendedname proteinnamegrouprecommendednametype.hjid
fke3f7c680e2f9b389 proteintype_domaintype.biotechname evidencedstringtype.hjid
fke43b3d2762738266 dbreferencetype.organismtype_dbreference_hjid organismtype.hjid
fke43b3d279338ff06 dbreferencetype.citationtype_dbreference_hjid citationtype.hjid
fke43b3d27e13d04b6 dbreferencetype.entrytype_dbreference_hjid entrytype.hjid
fkf248bbef1748f9fa proteinnamegroupsubmittednametype.fullname evidencedstringtype.hjid
fkf248bbef5298f7d8 proteinnamegroupsubmittednametype.proteintype_componenttype_submittedname_hjid proteintype_componenttype.hjid
fkf248bbef77f80ed2 proteinnamegroupsubmittednametype.proteintype_domaintype_submittedname_hjid proteintype_domaintype.hjid
fkf248bbef7d501c7d proteinnamegroupsubmittednametype.proteintype_submittedname_hjid proteintype.hjid
fkf3878e31135b043f entrytype_accession.entrytype_accession_hjid entrytype.hjid

Check Constraints:

Table Constraint Name Constraint
None detected