GeneX-2.0 DB: ProtocolApplicationLink Table
GeneX-2.0 DB: ProtocolApplicationLink Table
Table TypeInheritsComment
SUBSETnone 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 NameFull NameData TypeNot NULLComment
other_fkother_fkinttruethe 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_fkProtocol Applicationinttrue
table_nameTable Namechar32trueThe table to which the entry specified by other_fk belongs.

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
proto_app_fkProtocolApplicationproto_app_pkLINKING_TABLE

Unique Column Information
Column Names
other_fk proto_app_fk

Index Information
NameColumn Name
other_fkpalink_other_fk
proto_app_fkpalink_pa_fk