GeneX Development Supported By
|
GeneX-2.0 DB: SF_ExternalDBLink Table
|
GeneX-2.0 DB: SF_ExternalDBLink Table
|
| Table Type | Inherits | Comment |
| LINKING | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| ed_fk | Database Name | int | true | |
| external_identifier | External Identifier | char128 | true | the accession or other unique identifier of the Reporter in the referenced database |
| rep_fk | Sequence Feature | int | true | |
| Primary Key Information |
| Column Name |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| ed_fk | ExternalDatabase | ed_pk | LINKING_TABLE |
| rep_fk | Reporter | rep_pk | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| rep_fk ed_fk external_identifier |
| Index Information |
| Name | Column Name |
| ed_fk | sf_externaldblink_ed_fk |
| rep_fk | sf_externaldblink_rep_fk |
|