ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SamplingFeatureAnnotations

Notes for or groups of one or more Sampling Features.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	SamplingFeatureID	Integer				Foreign key of the SamplingFeature being annotated.
	AnnotationID	Integer				Foreign key of the Annotation applied to the SamplingFeature.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SamplingFeatureAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SamplingFeatureAnnotations	AnnotationID	AnnotationID
fk_SamplingFeatureAnnotations_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2Annotations.SamplingFeatureAnnotations	SamplingFeatureID	SamplingFeatureID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2Annotations