Table opm.coherence_change_record 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  √ 
clusterId bigint 19
objName varchar 255
objKey varchar 255  √  null object resource key
objType smallint 5
element_type_definition.id objType_cr R
parentName varchar 255 parent object name
changeType enum 7
status enum 12
isMappedObjInCoherence bit 1  √  b'1' 1 means the mapped object is in this table, 0 means it is in netapp_model
mappedObjType smallint 5  √  null
element_type_definition.id mappedObjType_cr R
type of the mapped object
mappedId bigint 19  √  null coherence_change_record table id, OR netapp_model table object id, of the mapped object, depends on isMappedObjInCoherence
updateTime timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
clusterId Performance Asc clusterId
mappedObjType Performance Asc mappedObjType_cr
objKey Performance Asc objKey
objType Performance Asc objType_cr

Close relationships  within of separation: