PathwayReaction

A pathway is defined as a set of reaction pairs or a collection of molecular interactions between molecules. This table stores not only the relationships between pathway and reactions, but also relationships between molecular interaction network/pathway and interactions. For each pair of reactions R1 and R2, R1 directly precedes R2 in the pathway. Some reactions in a pathway may be considered hypothetical, probably because the presence of the enzyme has not been demonstrated. To specify an interaction is a part of a molecular interaction network/pathway, use R2 to represents a molecular interaction, leave R1 blank.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
PathwayWID	BIGINT	NUMBER	No	WID of a pathway
ReactionWID	BIGINT	NUMBER	No	WID of a reaction, R2, in the pathway
PriorReactionWID	BIGINT	NUMBER	Yes	WID, R1, of a predecessor reaction of R2
Hypothetical	CHAR(1)	CHAR(1)	No	'F' if R2 proven to exist, 'T' otherwise.

Referenced By

None.

Other Constraints

None.

Indexes

Name	Columns
PR_PATHWID_REACTIONWID	PathwayWID, ReactionWID
PR_REACTIONWID	ReactionWID
PR_PRIORWID	PriorReactionWID