ODMXCore - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: ODMXCore

Tables

Table NameComment
ActionByAffiliates people with actions and describes thier role in the action.
ActionsDescribes actions (e.g., observation, sample collection, sample analysis, field visits, field activities, etc.)
AffiliationsDescribes affiliations of people with organizations.
DatasetsDescribes groupings of observation results that can be considered "datasets"
DatasetsResultsLists the Results that are grouped into a DataSet
ExternalConnectiona table which allows us to link Actions, People and Sampling Features to external data and events
FeatureActions
ImageEquipmentBridgeBridge between equipment and bridge
ImagePersonsBridgeBridge table linking images to persons
ImagesA table to store image data
ImageSamplingFeatureBridgeBridge table between sampling features and Images
InstrumentActions
MethodsDescribes methods used to perform actions recorded in ODM (e.g., observation methods, sample analysis methods, sample preparation methods, etc.)
OrganizationsDescribes organizations - as in research groups, companies, universities, etc.
OrganizationSamplingFeatureBridgeBridge table between organizations and sampling features
PersonsDescribes people.
ProcessingLevelsDescribes the processing level of Results
RelatedActionsDescribes Actions that are related to one another.
ResultsDescribes the results of observation actions (e.g., groups of one or more numeric data values that result from an observation action)
SamplingFeaturesDescribes the sampling features on which observations are made.
SamplingFeaturesAliases
TaxonomicClassifiers
VariableMapping
VariablesStores information about measured properties.
VariablesTaxonomicClassifiersBridgeBridge table between Variables and Taxonomic Classifiers

Procedures

(none)

Views

(none)

Sequences

NameComment
ActionBy_BridgeID_seqDbWrench Autogenerated Sequence.
Actions_ActionID_seqDbWrench Autogenerated Sequence.
Affiliations_AffiliationID_seqDbWrench Autogenerated Sequence.
Datasets_DatasetID_seqDbWrench Autogenerated Sequence.
DatasetsResults_BridgeID_seqDbWrench Autogenerated Sequence.
FeatureActions_FeatureActionID_seqDbWrench Autogenerated Sequence.
Methods_MethodID_seqDbWrench Autogenerated Sequence.
Organizations_OrganizationID_seqDbWrench Autogenerated Sequence.
People_PersonID_seqDbWrench Autogenerated Sequence.
ProcessingLevels_ProcessingLevelID_seqDbWrench Autogenerated Sequence.
RelatedActions_RelationID_seqDbWrench Autogenerated Sequence.
Results_ResultID_seqDbWrench Autogenerated Sequence.
SamplingFeatures_SamplingFeatureID_seqDbWrench Autogenerated Sequence.
TaxonomicClassifiers_TaxonomicClassifierID_seqDbWrench Autogenerated Sequence.
Units_UnitsID_seqDbWrench Autogenerated Sequence.
Variables_VariableID_seqDbWrench Autogenerated Sequence.