ArrayDesign

Represents MAGE Class ArrayDesign
Describes the design of an gene expression layout. In some cases this might be virtual and, for instance, represent the output from analysis software at the composite level without reporters or features.
Includes MAGE Class PhysicalArrayDesign

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.
Version	VARCHAR	VARCHAR2(255)	Yes	MAGE attribute ArrayDesign.version The version of this design.
NumberOfFeatures	SMALLINT	NUMBER	Yes	MAGE attribute ArrayDesign.numberOfFeatures The number of features for this array
SurfaceType	BIGINT	NUMBER	Yes	Represents 1..1 association between PhysicalArrayDesign and OntologyEntry The type of surface from a controlled vocabulary that would include terms such as non-absorptive, absorptive, etc.

Referenced By

Table	Column
DesignElementGroup	ArrayDesign_FeatureGroups
ZoneGroup	PhysicalArrayDesign_ZoneGroups
Array_	ArrayDesign
ParameterizableApplication	ArrayDesign
ArrayDesignWIDReporterGroupWID	ArrayDesignWID
ArrayDesignWIDCompositeGrpWID	ArrayDesignWID
ArrayDesignWIDContactWID	ArrayDesignWID

Other Constraints

None.

Indexes

Name	Columns
ArrayDesign1	DataSetWID
ArrayDesign2	MAGEClass
ArrayDesign3	Identifier
ArrayDesign4	Name
ArrayDesign5	Version
ArrayDesign6	NumberOfFeatures
ArrayDesign7	SurfaceType