Table ocum.annotationtype 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  √ 
annotation.type_id Annotation_type_id_FK C
annotationrule.annotationTypeId AnnotationRule_annotationTypeId_FK C
name varchar 255
description varchar 1024
isBuiltIn bit 1
createdByUsername varchar 255  √  null
createdOnTimestamp timestamp 19  √  CURRENT_TIMESTAMP
legacyName varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
name Must be unique Asc AnnotationType_name_UQ

Close relationships  within of separation: