View netapp_model_view.change_delete_detail 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 0
deleteTime bigint 19 The time that the object was deleted
objectType varchar 255 Type of the object that was deleted
objId bigint 19 ID of the object that was deleted
clusterId bigint 19 ID of the cluster associated to the deleted object
nodeId bigint 19  √  null ID of the node associated to the object or NULL if object is not a child of node
vserverId bigint 19  √  null ID of the vserver associated to the object or NULL if object is not a child of vserver
aggregateId bigint 19  √  null ID of the aggregate associated to the object or NULL if object is not a child of aggregate
volumeId bigint 19  √  null ID of the volume associated to the object or NULL if object is not a child of volume
name varchar 255  √  null
ancestorDeleted bit 0  √  null True if the object's node, vserver, aggregate or volume was also removed in the same transaction

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`change_delete_detail`.`id` AS `id`,`netapp_model`.`change_delete_detail`.`deleteTime` AS `deleteTime`,`netapp_model`.`change_delete_detail`.`objectType` AS `objectType`,`netapp_model`.`change_delete_detail`.`objId` AS `objId`,`netapp_model`.`change_delete_detail`.`clusterId` AS `clusterId`,`netapp_model`.`change_delete_detail`.`nodeId` AS `nodeId`,`netapp_model`.`change_delete_detail`.`vserverId` AS `vserverId`,`netapp_model`.`change_delete_detail`.`aggregateId` AS `aggregateId`,`netapp_model`.`change_delete_detail`.`volumeId` AS `volumeId`,`netapp_model`.`change_delete_detail`.`name` AS `name`,`netapp_model`.`change_delete_detail`.`ancestorDeleted` AS `ancestorDeleted` from `netapp_model`.`change_delete_detail`