Table Index

ManufactureLIMS


Represents MAGE Class ManufactureLIMS
Information on the physical production of arrays within the laboratory.
Includes MAGE Class ManufactureLIMSBiomaterial

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
ArrayManufacture_FeatureLIMSs BIGINT NUMBER Yes Represents 1..n association between ArrayManufacture and ManufactureLIMS
Information on the manufacture of the features.
Quality VARCHAR VARCHAR2(255) Yes MAGE attribute ManufactureLIMS.quality
A brief description of the quality of the array manufacture process.
Feature BIGINT NUMBER Yes Represents n..1 association between ManufactureLIMS and Feature
The feature whose LIMS information is being described.
BioMaterial BIGINT NUMBER Yes Represents n..1 association between ManufactureLIMS and BioMaterial
The BioMaterial used for the feature.
ManufactureLIMS_IdentifierLIMS BIGINT NUMBER Yes Represents 1..1 association between ManufactureLIMS and DatabaseEntry
Association to a LIMS data source for further information on the manufacturing process.
BioMaterialPlateIdentifier VARCHAR VARCHAR2(255) Yes MAGE attribute ManufactureLIMSBiomaterial.bioMaterialPlateIdentifier
The plate from which a biomaterial was obtained.
BioMaterialPlateRow VARCHAR VARCHAR2(255) Yes MAGE attribute ManufactureLIMSBiomaterial.bioMaterialPlateRow
The plate row from which a biomaterial was obtained. Specified by a letter.
BioMaterialPlateCol VARCHAR VARCHAR2(255) Yes MAGE attribute ManufactureLIMSBiomaterial.bioMaterialPlateCol
The plate column from which a biomaterial was obtained. Specified by a number.

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
ManufactureLIMS1 DataSetWID
ManufactureLIMS2 MAGEClass
ManufactureLIMS3 ArrayManufacture_FeatureLIMSs
ManufactureLIMS4 Quality
ManufactureLIMS5 Feature
ManufactureLIMS6 BioMaterial
ManufactureLIMS7 ManufactureLIMS_IdentifierLIMS
ManufactureLIMS8 BioMaterialPlateIdentifier
ManufactureLIMS9 BioMaterialPlateRow
ManufactureLIMS10 BioMaterialPlateCol