EnzymaticReaction

Defines an association between a reaction and an enzyme that catalyzes
that reaction (ProteinWID). In the case where we are defining an
association between a subunit of a larger enzyme complex, and a
reaction catalyzed by that subunit only when the subunit is part of
that larger complex, ComplexWID specifies that larger complex (assumes
that complex is in the warehouse).
This table requires a WID as it is referenced in multiple linking tables
to associate alternate compounds, cofactors, etc., to allow for multiple
valued attributes of the enzymatic reaction.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	WID of this enzymatic reaction
ReactionWID	BIGINT	NUMBER	No	WID of the catalyzed reaction
ProteinWID	BIGINT	NUMBER	No	WID of the enzyme
ComplexWID	BIGINT	NUMBER	Yes	WID of protein of which ProteinWID must be a subunit of for this reaction
ReactionDirection	VARCHAR	VARCHAR2(30)	Yes	Reaction Direction Enumeration *Enumerated Values:* reversible - Reaction occurs in both directions in physiological settings. physiol-left-to-right - Reaction occurs in the left-to-right direction in physiological settings. physiol-right-to-left - Reaction occurs in the right-to-left direction in physiological settings. irreversible-left-to-right - For all practical purposes, the reaction occurs only in the left-to-right direction in physiological settings, because of chemical properties of the reaction. irreversible-right-to-left - For all practical purposes, the reaction occurs only in the right-to-left direction in physiological settings, because of chemical properties of the reaction.
DataSetWID	BIGINT	NUMBER	No	WID of the dataset the reaction is from

Referenced By

Table	Column
EnzReactionCofactor	EnzymaticReactionWID
EnzReactionAltCompound	EnzymaticReactionWID
EnzReactionInhibitorActivator	EnzymaticReactionWID
Entry	OtherWID
Support	OtherWID
RelatedTerm	OtherWID
CitationWIDOtherWID	OtherWID
CommentTable	OtherWID
CrossReference	OtherWID
CrossReference	CrossWID
Description	OtherWID
DBID	OtherWID
SynonymTable	OtherWID
ToolAdvice	OtherWID

Other Constraints

None.

Indexes

Name	Columns
ER_DATASETWID	DataSetWID
ER_REAWID	REACTIONWID
ER_PROWID	PROTEINWID
ER_COMWID	COMPLEXWID
ER_DIRWID	REACTIONDIRECTION