ODMX [ODMX_DBWrench_Schema.xml]
Describes methods used to perform actions recorded in ODM (e.g., observation methods, sample analysis methods, sample preparation methods, etc.)
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| MethodID | Integer |
| nextval('"ODMXCore"."Methods_MethodID_seq"'::regclass) | Primary key identifier | ||
| MethodTypeCV | VarChar() | CV term describing the type of method (e.g., sample collection, laboratory analytical, field, sample prepratation, etc.) |
|
||||
| MethodCode | VarChar() | A text code identifiying the method (e.g., EPA 650.2) | |||||
| MethodName | VarChar() | Full text name of the method | |||||
| MethodDescription | VarChar() |
| Full text description of the method | ||||
| MethodLink | VarChar() |
| A URL to a full description of the method | ||||
| OrganizationID | Integer |
| Foreign key identifier for the Organization with which the method is affiliated |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Methods_CV_MethodType | ODMXCV.CV_MethodType | ODMXCore.Methods | Term | MethodTypeCV |
| fk_Methods_Organizations | ODMXCore.Organizations | ODMXCore.Methods | OrganizationID | OrganizationID |
(none)
| Name | Table | Columns |
| uc_MethodCode | ODMXCore.Methods | MethodCode |
| Diagram Name |
| ODMXAnnotations |
| ODMXCore |
| ODMXEquipment |
| ODMXExtensionProperties |
| ODMXExternalIdentifiers |
| ODMXLabAnalyses |
| ODMXOverviewSimplified |
| ODMXProvenance |
| ODMXSimulation |