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:
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 . Refers to the primary key in Annotation . |