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 |