View netapp_model_view.metrocluster_operation 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 Globally unique ID of the operation
resourceKey varchar 255
clusterId bigint 19 Reference to a locally unique object identifier CLUSTER table
nodeId bigint 19  √  null
startTime bigint 19  √  null Time when the operation started
endTime bigint 19  √  null Time when the operation ended
errorList text 65535  √  null A comma separated list of errors encountered during the operation
jobId bigint 19  √  null Identifier for the job
operation enum 30  √  null Name of the operation
operationRaw varchar 255  √  null Name of the operation
state enum 37  √  null State of the operation
stateRaw varchar 255  √  null State of the operation
createtime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`metrocluster_operation`.`objid` AS `objid`,`netapp_model`.`metrocluster_operation`.`originid` AS `originid`,`netapp_model`.`metrocluster_operation`.`uuid` AS `uuid`,`netapp_model`.`metrocluster_operation`.`resourceKey` AS `resourceKey`,`netapp_model`.`metrocluster_operation`.`clusterId` AS `clusterId`,`netapp_model`.`metrocluster_operation`.`nodeID` AS `nodeId`,`netapp_model`.`metrocluster_operation`.`startTime` AS `startTime`,`netapp_model`.`metrocluster_operation`.`endTime` AS `endTime`,`netapp_model`.`metrocluster_operation`.`errorList` AS `errorList`,`netapp_model`.`metrocluster_operation`.`jobId` AS `jobId`,`netapp_model`.`metrocluster_operation`.`operation` AS `operation`,`netapp_model`.`metrocluster_operation`.`operationRaw` AS `operationRaw`,`netapp_model`.`metrocluster_operation`.`state` AS `state`,`netapp_model`.`metrocluster_operation`.`stateRaw` AS `stateRaw`,`netapp_model`.`metrocluster_operation`.`createtime` AS `createtime`,`netapp_model`.`metrocluster_operation`.`updatetime` AS `updatetime` from `netapp_model`.`metrocluster_operation` where (`netapp_model`.`metrocluster_operation`.`objState` = 'LIVE')