View netapp_model_view.qtree_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 Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
uuid varchar 255  √  null
resourceKey varchar 512  √  null
name varchar 255  √  null
qtreeIdentifier int 10  √  null ID of the qtree within its volume. This is not globally unique
clusterId bigint 19
volumeId bigint 19
vserverId bigint 19
status enum 12  √  null State of the Qtree
statusRaw varchar 256  √  null
securityStyle enum 11  √  null Security style of the Qtree
securityStyleRaw varchar 256  √  null
oplocks varchar 255  √  null Is opportunistic locking enabled on this Qtree
exportPolicyId bigint 19  √  null
isExportPolicyInherited bit 0  √  null Indicating if the qtree inherits the export policy of the parent volume
mode varchar 255  √  null The file permission bits of the qtree.
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`.`qtree`.`objid` AS `objid`,`netapp_model`.`qtree`.`uuid` AS `uuid`,`netapp_model`.`qtree`.`resourceKey` AS `resourceKey`,`netapp_model`.`qtree`.`name` AS `name`,`netapp_model`.`qtree`.`qtreeIdentifier` AS `qtreeIdentifier`,`netapp_model`.`qtree`.`clusterId` AS `clusterId`,`netapp_model`.`qtree`.`volumeId` AS `volumeId`,`netapp_model`.`qtree`.`vserverId` AS `vserverId`,`netapp_model`.`qtree`.`status` AS `status`,`netapp_model`.`qtree`.`statusRaw` AS `statusRaw`,`netapp_model`.`qtree`.`securityStyle` AS `securityStyle`,`netapp_model`.`qtree`.`securityStyleRaw` AS `securityStyleRaw`,`netapp_model`.`qtree`.`oplocks` AS `oplocks`,`netapp_model`.`qtree`.`exportPolicyId` AS `exportPolicyId`,`netapp_model`.`qtree`.`isExportPolicyInherited` AS `isExportPolicyInherited`,`netapp_model`.`qtree`.`mode` AS `mode`,`netapp_model`.`qtree`.`createtime` AS `createTime`,`netapp_model`.`qtree`.`updatetime` AS `updateTime`,`netapp_model`.`qtree`.`objState` AS `objState` from `netapp_model`.`qtree`