Table Index

PathwayLink


This table allows us to state that two pathways are neighbors in
a biologically significant sense, because they share a substrate
in common. This link between two pathways is represented by the WIDs of the
interacting pathways, and of the chemical compound that they share.

Columns

Column MySQL Type Oracle Type Nullable Description
Pathway1WID BIGINT NUMBER No WID of one of the linked pathways
Pathway2WID BIGINT NUMBER No WID of the other linked pathways
ChemicalWID BIGINT NUMBER No WID of the linking chemical

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
PATHLINK_P1WID_P2WID_CHEMWID PATHWAY1WID, PATHWAY2WID, CHEMICALWID
PATHLINK_P2WID PATHWAY2WID
PATHLINK_CHEMWID CHEMICALWID