View netapp_model_view.snap_mirror_history 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
objid bigint 19 Locally unique object identifier.
originid bigint 19
uuid varchar 255 A unique identifier assigned to a SnapMirror operation.
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table
snapMirrorId bigint 19 Foreign key to the snap_mirror table.
operationType enum 16  √  null The type of the operation happened on the relationship.
operationTypeRaw varchar 255  √  null The type of the operation happened on the relationship.
additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
startTime bigint 19  √  null The timestamp of the start time of the operation.
endTime bigint 19  √  null The timestamp of the end time of the operation.
result enum 10  √  null The result of the SnapMirror operation.
resultRaw varchar 255  √  null The result of the SnapMirror operation.
transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
inactive bit 0 0
createtime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`snap_mirror_history`.`objid` AS `objid`,`netapp_model`.`snap_mirror_history`.`originid` AS `originid`,`netapp_model`.`snap_mirror_history`.`uuid` AS `uuid`,`netapp_model`.`snap_mirror_history`.`resourceKey` AS `resourceKey`,`netapp_model`.`snap_mirror_history`.`clusterId` AS `clusterId`,`netapp_model`.`snap_mirror_history`.`snapMirrorId` AS `snapMirrorId`,`netapp_model`.`snap_mirror_history`.`operationType` AS `operationType`,`netapp_model`.`snap_mirror_history`.`operationTypeRaw` AS `operationTypeRaw`,`netapp_model`.`snap_mirror_history`.`additionalInfo` AS `additionalInfo`,`netapp_model`.`snap_mirror_history`.`startTime` AS `startTime`,`netapp_model`.`snap_mirror_history`.`endTime` AS `endTime`,`netapp_model`.`snap_mirror_history`.`result` AS `result`,`netapp_model`.`snap_mirror_history`.`resultRaw` AS `resultRaw`,`netapp_model`.`snap_mirror_history`.`transferSize` AS `transferSize`,`netapp_model`.`snap_mirror_history`.`inactive` AS `inactive`,`netapp_model`.`snap_mirror_history`.`createtime` AS `createtime`,`netapp_model`.`snap_mirror_history`.`updatetime` AS `updatetime` from `netapp_model`.`snap_mirror_history` where (`netapp_model`.`snap_mirror_history`.`objState` = 'LIVE')