Table Index

Interaction


Defines a molecular interaction, such as two proteins observed to interact in a yeast-two-hybrid experiement. The interaction could involve macromolecules, small molecules or both.

Columns

Column MySQL Type Oracle Type Nullable Description
WID BIGINT NUMBER No Warehouse ID for this interaction
Type VARCHAR VARCHAR2(100) Yes Interaction type. It is recommended to use external controled vacabulary terms, such as PSI-MI Interaction Type CV.
Name VARCHAR VARCHAR2(120) Yes Name of the interaction.
DataSetWID BIGINT NUMBER No WID of the dataset the interaction is from.

Referenced By

Table Column
InteractionParticipant InteractionWID

Other Constraints

None.

Indexes

Name Columns
INTERACTION_DWID DataSetWID