Annotation Repository Schema

The annotation repository schema supports the following functions:

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

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`.