Table mob_odm2.odm2.annotations Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
annotationid serial 10  √  nextval('odm2.annotations_annotationid_seq'::regclass)
actionannotations.annotationid fk_actionannotations_annotations C
categoricalresultvalueannotations.annotationid fk_categoricalresultvalueannotations_annotations C
equipmentannotations.annotationid fk_equipmentannotations_annotations C
measurementresultvalueannotations.annotationid fk_resultvalueannotations_annotations C
methodannotations.annotationid fk_methodannotations_annotations C
pointcoverageresultvalueannotations.annotationid fk_pointcoverageresultvalueannotations_annotations C
profileresultvalueannotations.annotationid fk_profileresultvalueannotations_annotations C
relatedannotations.annotationid fk_relatedannotations_annotations C
relatedannotations.relatedannotationid fk_relatedannotations_annotations_arerelated C
resultannotations.annotationid fk_resultannotations_annotations C
samplingfeatureannotations.annotationid fk_samplingfeatureannotations_annotations C
sectionresultvalueannotations.annotationid fk_sectionresultvalueannotations_annotations C
spectraresultvalueannotations.annotationid fk_spectraresultvalueannotations_annotations C
timeseriesresultvalueannotations.annotationid fk_timeseriesresultvalueannotations_annotations C
trajectoryresultvalueannotations.annotationid fk_trajectoryresultvalueannotations_annotations C
transectresultvalueannotations.annotationid fk_transectresultvalueannotations_annotations C
annotationtypecv varchar 255
cv_annotationtype.name fk_annotations_cv_annotationtype C
annotationcode varchar 50  √  null
annotationtext varchar 500
annotationdatetime timestamp 29,6  √  null
annotationutcoffset int4 10  √  null
annotationlink varchar 255  √  null
annotatorid int4 10  √  null
people.personid fk_annotations_people C
citationid int4 10  √  null
citations.citationid fk_annotations_citations C

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
annotationid Primary key Asc annotations_pkey

Close relationships  within of separation: