ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

RelatedFeatures

Describes parrent/child relationships among Sampling Features

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	RelationID	Integer				Primary key for a relationship table (i.e. named "Related...").
	SamplingFeatureID	Integer				Foregn key identifier of a Sampling Feature
	RelationshipTypeCV	VarChar(255)				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

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_FeatureParents_FeaturesParent	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.RelatedFeatures	SamplingFeatureID	RelatedFeatureID
fk_FeatureParents_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.RelatedFeatures	SamplingFeatureID	SamplingFeatureID
fk_FeatureParents_SpatialOffsets	ODM2SamplingFeatures.SpatialOffsets	ODM2SamplingFeatures.RelatedFeatures	SpatialOffsetID	SpatialOffsetID
fk_RelatedFeatures_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2SamplingFeatures.RelatedFeatures	Name	RelationshipTypeCV

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_FeatureActions_RelatedFeatures	ODM2SamplingFeatures.RelatedFeatures	ODM2Core.FeatureActions	RelationID	RelatedFeaturesRelationID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2SamplingFeatures