Table Index

FactorValue


Represents MAGE Class FactorValue
The value for a ExperimentalFactor

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
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.
ExperimentalFactor BIGINT NUMBER Yes Represents 1..n association between ExperimentalFactor and FactorValue
The pairing of BioAssay FactorValues with the ExperimentDesign ExperimentFactor.
ExperimentalFactor2 BIGINT NUMBER Yes Represents n..1 association between FactorValue and ExperimentalFactor
The pairing of BioAssay FactorValues with the ExperimentDesign ExperimentFactor.
FactorValue_Measurement BIGINT NUMBER Yes Represents 1..1 association between FactorValue and Measurement
The measured value for this factor.
FactorValue_Value BIGINT NUMBER Yes Represents 1..1 association between FactorValue and OntologyEntry
Allows a more complex value to be specified for a FactorValue than a simple Measurement.

Referenced By

Table Column
BioAssayWIDFactorValueWID FactorValueWID

Other Constraints

None.

Indexes

Name Columns
FactorValue1 DataSetWID
FactorValue2 Identifier
FactorValue3 Name
FactorValue4 ExperimentalFactor
FactorValue5 ExperimentalFactor2
FactorValue6 FactorValue_Measurement
FactorValue7 FactorValue_Value