BioAssayData

Represents MAGE Class BioAssayData
Represents the dataset created when the BioAssays are created. BioAssayData is the entry point to the values. Because the actual values are represented by a different object, BioDataValues, which can be memory intensive, the annotation of the transformation can be gotten separate from the data.
Includes MAGE Class DerivedBioAssayData
Includes MAGE Class MeasuredBioAssayData

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse identifier for this entity
DataSetWID	BIGINT	NUMBER	No	Reference to the data set from which the entity came from
MAGEClass	VARCHAR	VARCHAR2(100)	No	Discriminator column specifies type of object this row represents
Identifier	VARCHAR	VARCHAR2(255)	Yes	MAGE attribute Identifiable.identifier An identifier is an unambiguous string that is unique within the scope (i.e. a document, a set of related documents, or a repository) of its use.
Name	VARCHAR	VARCHAR2(255)	Yes	MAGE attribute Identifiable.name The potentially ambiguous common identifier.
BioAssayDimension	BIGINT	NUMBER	Yes	Represents n..1 association between BioAssayData and BioAssayDimension The BioAssays of the BioAssayData.
DesignElementDimension	BIGINT	NUMBER	Yes	Represents n..1 association between BioAssayData and DesignElementDimension The DesignElements of the BioAssayData.
QuantitationTypeDimension	BIGINT	NUMBER	Yes	Represents n..1 association between BioAssayData and QuantitationTypeDimension The QuantitationTypes of the BioAssayData.
BioAssayData_BioDataValues	BIGINT	NUMBER	Yes	Represents 1..1 association between BioAssayData and BioDataValues The data values of the BioAssayData.
ProducerTransformation	BIGINT	NUMBER	Yes	Represents 1..1 association between DerivedBioAssayData and Transformation The association between the DerivedBioAssayData and the Transformation event that produced it.

Referenced By

Table	Column
BioEvent	DerivedBioAssayDataTarget
BioAssayDataCluster	ClusterBioAssayData
ExperimentWIDBioAssayDataWID	BioAssayDataWID
TransformWIDBioAssayDataWID	BioAssayDataWID
DerivBioAWIDDerivBioADataWID	DerivedBioAssayDataWID
MeasBAssayWIDMeasBAssayDataWID	MeasuredBioAssayDataWID

Other Constraints

None.

Indexes

Name	Columns
BioAssayData1	DataSetWID
BioAssayData2	MAGEClass
BioAssayData3	Identifier
BioAssayData4	Name
BioAssayData5	BioAssayDimension
BioAssayData6	DesignElementDimension
BioAssayData7	QuantitationTypeDimension
BioAssayData8	BioAssayData_BioDataValues
BioAssayData9	ProducerTransformation