GUS Schema >> DoTS::Interaction

Table used to hold interactions

column nulls? type description
INTERAction_ID no NUMBER(10,0) Primary key, used to uniquely identify an interaction Edit
INTERAction_TYPE_ID no DoTS::InteractionType (NUMBER(5,0) )Foreign key to InteractionType, specifies the type of interaction Edit
EFFECTOR_Action_TYPE_ID no DoTS::EffectorActionType (NUMBER(5,0) ) Edit
EFFECTOR_ROW_SET_ID no DoTS::RowSet (NUMBER(10,0) ) Edit
TARGET_ROW_SET_ID no DoTS::RowSet (NUMBER(10,0) ) Edit
HAS_DIRECTION no NUMBER(1,0) Edit
DIRECTION_IS_KNOWN no NUMBER(1,0) Set to 1 if the direction of the interaction is known; 0 otherwise. Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) )Foreign key to SRes::ExternalDatabaseRelease; this attribute is used when the interaction has been loaded from an external source Edit
SOURCE_ID STRING(32) The primary identifier of the interaction in the external database specified by external_db_release_id Edit
REVIEW_STATUS_ID SRes::ReviewStatus (NUMBER(12,0) ) Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Interaction
     DoTS::InteractionInteractionLOE
     DoTS::PathwayInteraction

Subclasses: