Reaction

Defines a chemical reaction. The reaction could be enzyme catalyzed
or occur spontaneously. The reaction could involve small molecules, macromolecules,
or a combination of the two. Every reaction will be stored in the warehouse in
a given direction, for example, every reaction that has an assigned EC number is
written in a direction assigned by the enzyme commission. In physiological settings,
the reaction could occur in the direction the reaction is stored, the reverse direction,
or both directions.
Restrictions: Reaction only stores fully qualified EC numbers, e.g., NOT of the form "X.Y.Z.-"

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse ID for this entiry
Name	VARCHAR	VARCHAR2(250)	Yes	Name of reaction
DeltaG	VARCHAR	VARCHAR2(50)	Yes	Delta G subzero prime value for this reaction
ECNumber	VARCHAR	VARCHAR2(50)	Yes	Official enzyme-commission-number.
ECNumberProposed	VARCHAR	VARCHAR2(50)	Yes	Proposed enzyme-commission-number
Spontaneous	CHAR(1)	CHAR(1)	Yes	'T' if the reaction occurs spontaneously, else 'F'
DataSetWID	BIGINT	NUMBER	No	WID of the dataset the reaction is from

Referenced By

Table	Column
EnzymaticReaction	ReactionWID
PathwayReaction	PriorReactionWID
Product	ReactionWID
Reactant	ReactionWID
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
REACTION_DWID	DataSetWID
REACTION_DeltaG	DeltaG
REACTION_ECNumber	ECNumber
REACTION_ECNumberProposed	ECNumberProposed