Breadcrumbs

Annotation Repository Schema

The annotation repository schema supports the following functions:

  • Add/delete an annotation

  • Update an annotation's symbol

  • Update an annotation's description

  • Enforce the uniqueness of annotation symbols

  • Add/delete database assignments

  • Add/delete field assignments

  • Add/delete field value assignments

  • Add/delete cell assignments

  • Update assignments with a new annotation symbol

The annotation repository schema is represented in the following database entity diagram:

worddavb63da9ba92bf1edbe4176c0ad7ff40a5.png

The tables in the annotation repository schema are:

Table

Description

Primary Key

Foreign Key

AnnotationDetails

Stores annotation symbols and descriptions.

AnnotationID

 

DbAssignment

Stores database annotation assignments.

 

Refers to the primary key in the AnnotationDetails table.

FieldAssignment

Stores field annotation assignments.

UniqueCode

AnnotationID. Refers to the primary key in AnnotationDetails.

FieldValueCodeAssignment

Stores field value annotation assignments.

UniqueCode

AnnotationID. Refers to the primary key in AnnotationDetails.

Annotation

Stores the joins between AnnotationDetails and CellAssignment.

AnnotationAssignID

AnnotationID. Refers to the primary key in AnnotationDetails.

CellAssignment

Stores cell assignment.

All records that share the same AnnotationAssignID will be used to identify the position of cells. When a measure is used, ValueSetName and FieldValueCode must be left empty (") and not be set to null.

 

AnnotationAssignID. Refers to the primary key in Annotation.