Table ocum.eventtype 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
customeventtype.id CustomEventType_id_FK C
eventtypecategoryclosureassociation.eventType_id EventTypeCategoryClosureAssociation_eventType_id_FK C
eventtypesourcetypes.eventType_id EventTypeSourceTypes_eventType_id_FK C
eventtypevalue.type_id EventTypeValue_type_id_FK C
objVersion int 10
objType varchar 100
name varchar 128
ignoresDuplicates bit 1
maxDuplicatesToIgnore int 10  √  null
isMultiCurrent bit 1
isAutoReset bit 1
allowsBuiltInAlert bit 1
parentCategory_id bigint 19  √  null
eventtypecategorycontainer.id EventType_parentCategory_id_FK N
impactArea varchar 60  √  null
category varchar 60  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
category Performance Asc EventType_category_IX
name Must be unique Asc EventType_name_UQ
parentCategory_id Performance Asc EventType_parentCategory_id_FK

Close relationships  within of separation: