ODMX [ODMX_DBWrench_Schema.xml]
Describes parrent/child relationships among Sampling Features
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| RelationID | Integer |
| nextval('"ODMXSamplingFeatures"."RelatedFeatures_RelationID_seq"'::regclass) | Primary key for a relationship table (i.e. named "Related..."). | ||
| SamplingFeatureID | Integer | Foregn key identifier of a Sampling Feature |
|
||||
| RelationshipTypeCV | VarChar() | CV term describing the relationship between SamplingFeatures (e.g., "IsChildOf", "IsFractionOf" or "IsCompositeOf"). |
|
||||
| RelatedFeatureID | Integer | Foreign key identifier of a Sampling Feature that is the parent of the current Sampling Feature |
|
||||
| SpatialOffsetID | Integer |
| Foreign key identifier of a spatial offset from the feature parent |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_FeatureParents_SamplingFeatures | ODMXCore.SamplingFeatures | ODMXSamplingFeatures.RelatedFeatures | SamplingFeatureID | SamplingFeatureID |
| fk_FeatureParents_SpatialOffsets | ODMXSamplingFeatures.SpatialOffsets | ODMXSamplingFeatures.RelatedFeatures | SpatialOffsetID | SpatialOffsetID |
| fk_RelatedFeatures_CV_RelationshipType | ODMXCV.CV_RelationshipType | ODMXSamplingFeatures.RelatedFeatures | Term | RelationshipTypeCV |
| fk_RelatedFeatures_SamplingFeatures | ODMXCore.SamplingFeatures | ODMXSamplingFeatures.RelatedFeatures | SamplingFeatureID | RelatedFeatureID |
(none)
| Diagram Name |
| ODMXOverviewSimplified |
| ODMXSamplingFeatures |