Pathway

Pathways are graphs of reactions, grouped together according to a
higher biological function they perform. Some pathways may be
"template", "reference", "model" or "sum of organisms" pathways. Those
pathways do not contain an BioSourceWID reference, and have the type
field set to "R" (Reference/Model/Theoretical). For real organisms,
the type is "O".

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse ID for this pathway
Name	VARCHAR	VARCHAR2(255)	No	Name of the pathway *Enumerated Values:* unknown - Name assigned when it is unknown or missing
Type	CHAR(1)	CHAR(1)	No	Type of pathway (see comment above)
BioSourceWID	BIGINT	NUMBER	Yes	BioSource this pathway occurs in
DataSetWID	BIGINT	NUMBER	No	WID of the dataset the pathway is from

Referenced By

Table	Column
PathwayLink	Pathway1WID
PathwayLink	Pathway2WID
PathwayReaction	PathwayWID
SuperPathway	SubPathwayWID
SuperPathway	SuperPathwayWID
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
PATHWAY_BSWID_WID_DWID	BioSourceWID, WID, DataSetWID
PATHWAY_TYPE_WID_DWID	TYPE, WID, DataSetWID
PATHWAY_DWID	DataSetWID
PATHWAY_Name	Name