GeneX Development Supported By
|
GeneX-2.0 DB: ProtocolApplicationLink Table
|
GeneX-2.0 DB: ProtocolApplicationLink Table
|
| Table Type | Inherits | Comment |
| SUBSET | none | The ProtocolApplicationLink table allows many protocols used in an application to be specified. As many protocols as are appropriate to describe the application may be used, and the same protocol may be used in the different applications (a many-to-many relationship). |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| other_fk | other_fk | int | true | the foreign key to the table using the protocol. We do not make this a foreign key constraint in the DB because this can apply to many different tables. |
| proto_app_fk | Protocol Application | int | true | |
| table_name | Table Name | char32 | true | The table to which the entry specified by other_fk belongs. |
| Primary Key Information |
| Column Name |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| proto_app_fk | ProtocolApplication | proto_app_pk | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| other_fk proto_app_fk |
| Index Information |
| Name | Column Name |
| other_fk | palink_other_fk |
| proto_app_fk | palink_pa_fk |
|