ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Annotations

Contains text annotations added to one or more records within various ...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	AnnotationID	Integer				Primary key for Annotations.
	AnnotationTypeCV	VarChar(255)				CV for types of annotations.
	AnnotationCode	VarChar(50)				A short text code that identifies the annotation (e.g., "A' for "Approved data").
	AnnotationText	VarChar(500)				Full text of the annotation.
	AnnotationDateTime	DateTime				Date and time at which the annotation was created.
	AnnotationUTCOffset	Integer				UTCOffset for the annotation creation date/time.
	AnnotationLink	VarChar(255)
	AnnotatorID	Integer				Foregn key identifier for the person that created the annotation
	CitationID	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Annotations_Citations	ODM2Provenance.Citations	ODM2Annotations.Annotations	CitationID	CitationID
fk_Annotations_CV_AnnotationType	ODM2CV.CV_AnnotationType	ODM2Annotations.Annotations	Name	AnnotationTypeCV
fk_Annotations_People	ODM2Core.People	ODM2Annotations.Annotations	PersonID	AnnotatorID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ActionAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ActionAnnotations	AnnotationID	AnnotationID
fk_CategoricalResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.CategoricalResultValueAnnotations	AnnotationID	AnnotationID
fk_EquipmentAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.EquipmentAnnotations	AnnotationID	AnnotationID
fk_ResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.MeasurementResultValueAnnotations	AnnotationID	AnnotationID
fk_MethodAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.MethodAnnotations	AnnotationID	AnnotationID
fk_PointCoverageResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.PointCoverageResultValueAnnotations	AnnotationID	AnnotationID
fk_ProfileResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ProfileResultValueAnnotations	AnnotationID	AnnotationID
fk_ResultAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ResultAnnotations	AnnotationID	AnnotationID
fk_SamplingFeatureAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SamplingFeatureAnnotations	AnnotationID	AnnotationID
fk_SectionResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SectionResultValueAnnotations	AnnotationID	AnnotationID
fk_SpectraResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SpectraResultValueAnnotations	AnnotationID	AnnotationID
fk_TimeSeriesResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TimeSeriesResultValueAnnotations	AnnotationID	AnnotationID
fk_TrajectoryResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TrajectoryResultValueAnnotations	AnnotationID	AnnotationID
fk_TransectResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TransectResultValueAnnotations	AnnotationID	AnnotationID
fk_RelatedAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Provenance.RelatedAnnotations	AnnotationID	AnnotationID
fk_RelatedAnnotations_Annotations_AreRelated	ODM2Annotations.Annotations	ODM2Provenance.RelatedAnnotations	AnnotationID	RelatedAnnotationID

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2Provenance

ODM2Simulation