DataSetHierarchy

Defines a dataset containment hierarchy. If a dataset contains another, either directly or indirectly, a row exists for that dataset pair in this table. A dataset always contains itself; therefore each dataset is included in at least one row in this table. A dataset may contain any number of datasets, and be contained in any number of datasets. To query for an object in a containing dataset whose datasetwid is NN, regardless of which contained dataset it is in, use a query like the following:
select wid from DataSetHierarchy h, Protein p where h.superwid=NN and h.subwid=p.datasetwid and p.name='some name'

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
SuperWID	BIGINT	NUMBER	No	Reference to the containing DataSet.
SubWID	BIGINT	NUMBER	No	Reference to the contained DataSet.

Referenced By

None.

Other Constraints

None.

Indexes

Name	Columns
DATASETHIERARCHY_SuperWID	SuperWID
DATASETHIERARCHY_SubWID	SubWID