| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| Methods | Describes methods used to perform actions recorded in ODM (e.g., obser... |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| MethodID | Integer |
| nextval('"ODM2Core"."Methods_MethodID_seq"'::regclass) | Primary key identifier | ||
| MethodTypeCV | VarChar(255) | CV term describing the type of method (e.g., sample collection, laboratory analytical, field, sample prepratation, etc.) |
|
||||
| MethodCode | VarChar(50) | A text code identifiying the method (e.g., EPA 650.2) | |||||
| MethodName | VarChar(255) | Full text name of the method | |||||
| MethodDescription | VarChar(5000) |
| Full text description of the method | ||||
| MethodLink | VarChar(255) |
| A URL to a full description of the method | ||||
| OrganizationID | Integer |
| Foreign key identifier for the Organization with which the method is affiliated |
|
|||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Methods_CV_MethodType | ODM2CV.CV_MethodType | ODM2Core.Methods | Term | MethodTypeCV |
| fk_Methods_Organizations | ODM2Core.Organizations | ODM2Core.Methods | OrganizationID | OrganizationID |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_MethodAnnotations_Methods | ODM2Core.Methods | ODM2Annotations.MethodAnnotations | MethodID | MethodID |
| fk_Actions_Methods | ODM2Core.Methods | ODM2Core.Actions | MethodID | MethodID |
| fk_InstrumentOutputQuantityKind_Methods | ODM2Core.Methods | ODM2Equipment.InstrumentOutputQuantityKind | MethodID | InstrumentMethodID |
| fk_MethodExtensionPropertyValues_Methods | ODM2Core.Methods | ODM2ExtensionProperties.MethodExtensionPropertyValues | MethodID | MethodID |
| fk_MethodExternalIdentifiers_Methods | ODM2Core.Methods | ODM2ExternalIdentifiers.MethodExternalIdentifiers | MethodID | MethodID |
| fk_MethodCitations_Methods | ODM2Core.Methods | ODM2Provenance.MethodCitations | MethodID | MethodID |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| ODM2Annotations |
| ODM2Core |
| ODM2Equipment |
| ODM2ExtensionProperties |
| ODM2ExternalIdentifiers |
| ODM2LabAnalyses |
| ODM2OverviewSimplified |
| ODM2Provenance |
| ODM2Simulation |