SamplingFeatureAnnotations - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: SamplingFeatureAnnotations

Notes for or groups of one or more Sampling Features.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

BridgeIDInteger

nextval('"ODMXAnnotations"."SamplingFeatureAnnotations_BridgeID_seq"'::regclass)Primary key for a bridge table, enabling many-to-many joins.
SamplingFeatureIDInteger Foreign key of the SamplingFeature being annotated.

AnnotationIDInteger Foreign key of the Annotation applied to the SamplingFeature.


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_SamplingFeatureAnnotations_AnnotationsODMXAnnotations.AnnotationsODMXAnnotations.SamplingFeatureAnnotationsAnnotationIDAnnotationID
fk_SamplingFeatureAnnotations_SamplingFeaturesODMXCore.SamplingFeaturesODMXAnnotations.SamplingFeatureAnnotationsSamplingFeatureIDSamplingFeatureID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXAnnotations