Table ocum.annotation 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
id bigint 19  √ 
annotationmanualresourcemapping.annotationValueId AnnotationManualResourceMapping_annotationValueId_FK C
annotationresourceobject.annotation_id AnnotationResourceObject_annotation_id_FK C
annotationrule.annotationValueId AnnotationRule_annotationValueId_FK C
name varchar 255
type_id bigint 19
annotationtype.id Annotation_type_id_FK C
isBuiltIn bit 1
legacyName varchar 255  √  null

Table contained 3 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
type_id + name Must be unique Asc/Asc Annotation_typeId_name_UQ

Close relationships  within of separation: