ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

FeatureActions

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	FeatureActionID	Integer				Primary key identifier
	SamplingFeatureID	Integer				Foreign key identifier for the SamplingFeature on which or at which the Action was performed
	ActionID	Integer				Foreign key identifier of the Action that was performed
	RelatedFeaturesRelationID	Integer				Foreign key identifier for the the relationship that identifies the parent SamplingFeature. This is useful when the Action is used to create a new SamplingFeature from a parent.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_FeatureActions_Actions	ODM2Core.Actions	ODM2Core.FeatureActions	ActionID	ActionID
fk_FeatureActions_RelatedFeatures	ODM2SamplingFeatures.RelatedFeatures	ODM2Core.FeatureActions	RelationID	RelatedFeaturesRelationID
fk_FeatureActions_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2Core.FeatureActions	SamplingFeatureID	SamplingFeatureID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Results_FeatureActions	ODM2Core.FeatureActions	ODM2Core.Results	FeatureActionID	FeatureActionID
fk_SpecimenBatchPostions_FeatureActions	ODM2Core.FeatureActions	ODM2LabAnalyses.SpecimenBatchPostions	FeatureActionID	FeatureActionID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Core

ODM2DataQuality

ODM2Equipment

ODM2LabAnalyses

ODM2OverviewSimplified

ODM2Provenance

ODM2SamplingFeatures

ODM2Simulation