Actions - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

ActionsDescribes actions (e.g., observation, sample collection, sample analys...

PKNameData TypeNULLsA/NDefaultCommentFK

ActionIDInteger

Primariy key identifier
ActionTypeCVVarChar(255) CV term describing the type of action (e.g., observation, sample collection, sample analysis)

MethodIDInteger Foreign key identifier for the method used to complete the action

BeginDateTimeDateTime The date/time at which the action began
BeginDateTimeUTCOffsetInteger The UTCOffset for the BeginDateTime
EndDateTimeDateTime

The date/time at which the action ended
EndDateTimeUTCOffsetInteger

The UTCOffset of for the EndDateTime
ActionDescriptionVarChar(5000)

Text that describes the action
ActionFileLinkVarChar(255)

A URL or path to a file created by or used by the Action, such as instrument output or configuration.


NameParent TableChild TableParent ColumnsChild Columns
fk_Actions_CV_ActionTypeODM2CV.CV_ActionTypeODM2Core.ActionsNameActionTypeCV
fk_Actions_MethodsODM2Core.MethodsODM2Core.ActionsMethodIDMethodID

NameParent TableChild TableParent ColumnsChild Columns
fk_ActionAnnotations_ActionsODM2Core.ActionsODM2Annotations.ActionAnnotationsActionIDActionID
fk_ActionPeople_ActionsODM2Core.ActionsODM2Core.ActionByActionIDActionID
fk_FeatureActions_ActionsODM2Core.ActionsODM2Core.FeatureActionsActionIDActionID
fk_RelatedActions_ActionsODM2Core.ActionsODM2Core.RelatedActionsActionIDActionID
fk_RelatedActions_Actions_AreRelatedODM2Core.ActionsODM2Core.RelatedActionsActionIDRelatedActionID
fk_CalibrationActions_ActionsODM2Core.ActionsODM2Equipment.CalibrationActionsActionIDActionID
fk_EquipmentActions_ActionsODM2Core.ActionsODM2Equipment.EquipmentUsedActionIDActionID
fk_MaintenanceActions_ActionsODM2Core.ActionsODM2Equipment.MaintenanceActionsActionIDActionID
fk_ActionExtensionPropertyValues_ActionsODM2Core.ActionsODM2ExtensionProperties.ActionExtensionPropertyValuesActionIDActionID
fk_ActionDirectives_ActionsODM2Core.ActionsODM2LabAnalyses.ActionDirectivesActionIDActionID
fk_Simulations_ActionsODM2Core.ActionsODM2Simulation.SimulationsActionIDActionID

Diagram Name
ODM2Annotations
ODM2Core
ODM2DataQuality
ODM2Equipment
ODM2ExtensionProperties
ODM2LabAnalyses
ODM2OverviewSimplified
ODM2Provenance
ODM2Simulation