Table Index

Reactant

Associates a reaction with a chemical that is consumed by the reaction.

Columns

Column MySQL Type Oracle Type Nullable Description
ReactionWID BIGINT NUMBER No Warehouse identifier of the reaction that this reactant is part of
OtherWID BIGINT NUMBER No Reference to the chemical or protein that is the reactant.
Coefficient SMALLINT NUMBER No The amount of this reactant used in the reation

Denormalized References

Column References
OtherWID Chemical : WID
OtherWID Protein : WID

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
REACTANT_WID ReactionWID
REACTANT_OTHERWID OTHERWID
REACTANT_COEFFICIENT Coefficient