GeneX-2.0 DB: SF_ExternalDBLink Table
GeneX-2.0 DB: SF_ExternalDBLink Table
Table TypeInheritsComment
LINKINGnone The SF_ExternalDBLink table allows a many-to-many relationship between Reporter and ExternalDatabase. It provides the id by which the Reporter is known in the ExternalDatabase.

Column Information
Column NameFull NameData TypeNot NULLComment
ed_fkDatabase Nameinttrue
external_identifierExternal Identifierchar128true the accession or other unique identifier of the Reporter in the referenced database
rep_fkSequence Featureinttrue

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
ed_fkExternalDatabaseed_pkLINKING_TABLE
rep_fkReporterrep_pkLINKING_TABLE

Unique Column Information
Column Names
rep_fk ed_fk external_identifier

Index Information
NameColumn Name
ed_fksf_externaldblink_ed_fk
rep_fksf_externaldblink_rep_fk