View netapp_model_view.qtree_quota 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: quota-report-iter.quota
uuid varchar 255  √  null
resourceKey varchar 512  √  null
clusterId bigint 19
vserverId bigint 19
volumeId bigint 19 Reference to the volume to which this quota belongs to
qtreeId bigint 19  √  null Reference to the qtree to which this quota applies
quotaTarget varchar 512  √  null
diskLimit bigint 19  √  null Maximum amount of disk space, in kilobytes, allowed for the quota target (hard disk space limit)
diskLimitUnlimited bit 0 1 True if there is no disk limit
diskUsed bigint 19  √  null Current amount of disk space, in kilobytes, used by the quota target
diskUsedUnlimited bit 0 1 True if there is no limit fot the disk used
fileLimit bigint 19  √  null Maximum number of files allowed for the quota target
fileLimitUnlimited bit 0 1 True if there is no file limit
fileUsed bigint 19  √  null Current number of files used by the quota target
fileUsedUnlimited bit 0 1 True if there is no limit for file used
softDiskLimit bigint 19  √  null Soft disk space limit, in kilobytes, for the quota target
softDiskLimitUnlimited bit 0 1 True if there is no soft disk limit
softFileLimit bigint 19  √  null Soft file limit, in number of files, for the quota target
softFileLimitUnlimited bit 0 1 True if there is no soft file limit
threshold bigint 19  √  null Disk space threshold, in kilobytes, for the quota target
thresholdUnlimited bit 0 1 True if there is no threshold limit
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`qtree_quota`.`objid` AS `objid`,`netapp_model`.`qtree_quota`.`uuid` AS `uuid`,`netapp_model`.`qtree_quota`.`resourceKey` AS `resourceKey`,`netapp_model`.`qtree_quota`.`clusterId` AS `clusterId`,`netapp_model`.`qtree_quota`.`vserverId` AS `vserverId`,`netapp_model`.`qtree_quota`.`volumeId` AS `volumeId`,`netapp_model`.`qtree_quota`.`qtreeId` AS `qtreeId`,`netapp_model`.`qtree_quota`.`quotaTarget` AS `quotaTarget`,`netapp_model`.`qtree_quota`.`diskLimit` AS `diskLimit`,`netapp_model`.`qtree_quota`.`diskLimitUnlimited` AS `diskLimitUnlimited`,`netapp_model`.`qtree_quota`.`diskUsed` AS `diskUsed`,`netapp_model`.`qtree_quota`.`diskUsedUnlimited` AS `diskUsedUnlimited`,`netapp_model`.`qtree_quota`.`fileLimit` AS `fileLimit`,`netapp_model`.`qtree_quota`.`fileLimitUnlimited` AS `fileLimitUnlimited`,`netapp_model`.`qtree_quota`.`fileUsed` AS `fileUsed`,`netapp_model`.`qtree_quota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`netapp_model`.`qtree_quota`.`softDiskLimit` AS `softDiskLimit`,`netapp_model`.`qtree_quota`.`softDiskLimitUnlimited` AS `softDiskLimitUnlimited`,`netapp_model`.`qtree_quota`.`softFileLimit` AS `softFileLimit`,`netapp_model`.`qtree_quota`.`softFileLimitUnlimited` AS `softFileLimitUnlimited`,`netapp_model`.`qtree_quota`.`threshold` AS `threshold`,`netapp_model`.`qtree_quota`.`thresholdUnlimited` AS `thresholdUnlimited`,`netapp_model`.`qtree_quota`.`createtime` AS `createTime`,`netapp_model`.`qtree_quota`.`updatetime` AS `updateTime` from `netapp_model`.`qtree_quota` where (`netapp_model`.`qtree_quota`.`objState` = 'LIVE')