ODMX [ODMX_DBWrench_Schema.xml]
This has the specimen collection information
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SpecimenCollectionID | Integer |
| Primary Key for the Specimen Collection | |||
| SpecimenCollectionCV | VarChar() | A CV term defining the specimen collection |
|
||||
| SpecimenCollectionFile | VarChar() |
| |||||
| SpecimenCollectionName | VarChar() |
| The name of the specimen collection | ||||
| SpecimenCollectionNote | VarChar() |
| Note describing details on the specimen collection | ||||
| ParentSpecimenCollectionID | Integer |
| The ID of the Parent Specimen Collection |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SpecimenCollection_CV_SpecimenCollection | ODMXCV.CV_SpecimenCollection | ODMXSamplingFeatures.SpecimenCollection | Term | SpecimenCollectionCV |
| fk_SpecimenCollection_SpecimenCollection | ODMXSamplingFeatures.SpecimenCollection | ODMXSamplingFeatures.SpecimenCollection | SpecimenCollectionID | ParentSpecimenCollectionID |
(none)
| Diagram Name |
| ODMXSamplingFeatures |