| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| SampledFeatures | (Table) |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| RelationID | Integer | Primary key for a relationship table | ||||
| SamplingFeatureID | Integer | Foregn key identifier of a Sampling Feature |
|
||||
| RelationshipTypeCV | VarChar(255) | CV term describing the relationship between FeaturesOfInterst and SamplingFeatures (e.g., "IsSampleOf"). |
|
||||
| FeatureOfInterestID | Integer | Foregn key identifier of a Feature of Interest |
|
||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SampledFeatures_CV_RelationshipType | ODM2CV.CV_RelationshipType | ODM2SamplingFeatures.SampledFeatures | Term | RelationshipTypeCV |
| fk_SampledFeatures_FeatureOfInterest | ODM2SamplingFeatures.FeaturesOfInterest | ODM2SamplingFeatures.SampledFeatures | FeaturesOfInterestID | FeatureOfInterestID |
| fk_SampledFeatures_SamplingFeatures | ODM2Core.SamplingFeatures | ODM2SamplingFeatures.SampledFeatures | SamplingFeatureID | SamplingFeatureID |
| Parent Relations (none) |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| ODM2SamplingFeatures |