View netapp_model_view.volume_move_job_full 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
uuid varchar 255 The job uuid of the move job. ZAPI: volume-move-get-iter volume-move-info job-uuid
resourceKey varchar 512
volumeId bigint 19
sourceAggregateId bigint 19
destinationAggregateId bigint 19
clusterId bigint 19
jobIdentifier bigint 19  √  null The ui job id of the move job. ZAPI: volume-move-get-iter volume-move-info job-id
startTime timestamp 19  √  null The date and time in cluster timezone when the volume move started. ZAPI: volume-move-get-iter volume-move-info start-timestamp
completionTime timestamp 19  √  null The date and time in cluster timezone when the volume move completed (successfully or otherwise). ZAPI: volume-move-get-iter volume-move-info actual-completion-timestamp
phase enum 21  √  null The phase of the move operation. ZAPI: volume-move-get-iter volume-move-info phase
phaseRaw varchar 255  √  null
state enum 11  √  null The state of the volume move at the time of issuing the command and the system gathering up the information about the move. ZAPI: volume-move-get-iter volume-move-info state
stateRaw varchar 255  √  null
details varchar 255  √  null This field contains details about any warnings, errors and state of the move operation. ZAPI: volume-move-get-iter volume-move-info details
percentComplete int 10  √  null The amount of work to move the volume completed thus far in terms of percentage. ZAPI: volume-move-get-iter volume-move-info percent-complete
estimatedCompletionTime timestamp 19  √  null The approximate date and time in the cluster time zone when the entire volume move operation is expected to complete. ZAPI: volume-move-get-iter volume-move-info estimated-completion-time
inactive bit 0 0
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`volume_move_job`.`objid` AS `objid`,`netapp_model`.`volume_move_job`.`uuid` AS `uuid`,`netapp_model`.`volume_move_job`.`resourceKey` AS `resourceKey`,`netapp_model`.`volume_move_job`.`volumeId` AS `volumeId`,`netapp_model`.`volume_move_job`.`sourceAggregateId` AS `sourceAggregateId`,`netapp_model`.`volume_move_job`.`destinationAggregateId` AS `destinationAggregateId`,`netapp_model`.`volume_move_job`.`clusterId` AS `clusterId`,`netapp_model`.`volume_move_job`.`jobIdentifier` AS `jobIdentifier`,`netapp_model`.`volume_move_job`.`startTime` AS `startTime`,`netapp_model`.`volume_move_job`.`completionTime` AS `completionTime`,`netapp_model`.`volume_move_job`.`phase` AS `phase`,`netapp_model`.`volume_move_job`.`phaseRaw` AS `phaseRaw`,`netapp_model`.`volume_move_job`.`state` AS `state`,`netapp_model`.`volume_move_job`.`stateRaw` AS `stateRaw`,`netapp_model`.`volume_move_job`.`details` AS `details`,`netapp_model`.`volume_move_job`.`percentComplete` AS `percentComplete`,`netapp_model`.`volume_move_job`.`estimatedCompletionTime` AS `estimatedCompletionTime`,`netapp_model`.`volume_move_job`.`inactive` AS `inactive`,`netapp_model`.`volume_move_job`.`createtime` AS `createTime`,`netapp_model`.`volume_move_job`.`updatetime` AS `updateTime`,`netapp_model`.`volume_move_job`.`objState` AS `objState` from `netapp_model`.`volume_move_job`