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

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_FeatureActions_Actions	ODM2Core.Actions	ODM2Core.FeatureActions	ActionID	ActionID
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

Used in Diagrams

Diagram Name

ODM2Core

ODM2DataQuality

ODM2Equipment

ODM2LabAnalyses

ODM2OverviewSimplified

ODM2Provenance

ODM2Simulation