FeatureActions - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: FeatureActions

Columns

PKNameData TypeNULLAutoDefaultCommentFK

FeatureActionIDInteger

nextval('"ODMXCore"."FeatureActions_FeatureActionID_seq"'::regclass)Primary key identifier
SamplingFeatureIDInteger Foreign key identifier for the SamplingFeature on which or at which the Action was performed

ActionIDInteger Foreign key identifier of the Action that was performed

RelatedFeaturesRelationIDInteger

Foreign key identifier for 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

NameParent TableChild TableParent ColumnsChild Columns
fk_FeatureActions_ActionsODMXCore.ActionsODMXCore.FeatureActionsActionIDActionID
fk_FeatureActions_RelatedFeaturesODMXSamplingFeatures.RelatedFeaturesODMXCore.FeatureActionsRelationIDRelatedFeaturesRelationID
fk_FeatureActions_SamplingFeaturesODMXCore.SamplingFeaturesODMXCore.FeatureActionsSamplingFeatureIDSamplingFeatureID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXCore
ODMXDataQuality
ODMXEquipment
ODMXLabAnalyses
ODMXOverviewSimplified
ODMXProvenance
ODMXSamplingFeatures
ODMXSimulation