View ocum_report.qtreequota 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 Locally unique object identifier. ZAPIs: quota-report-iter.quota
uuid varchar 255  √  null
clusterId bigint 19
svmId 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

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `qtree_quota`.`objid` AS `id`,`qtree_quota`.`uuid` AS `uuid`,`qtree_quota`.`clusterId` AS `clusterId`,`qtree_quota`.`vserverId` AS `svmId`,`qtree_quota`.`volumeId` AS `volumeId`,`qtree_quota`.`qtreeId` AS `qtreeId`,`qtree_quota`.`quotaTarget` AS `quotaTarget`,`qtree_quota`.`diskLimit` AS `diskLimit`,`qtree_quota`.`diskLimitUnlimited` AS `diskLimitUnlimited`,`qtree_quota`.`diskUsed` AS `diskUsed`,`qtree_quota`.`diskUsedUnlimited` AS `diskUsedUnlimited`,`qtree_quota`.`fileLimit` AS `fileLimit`,`qtree_quota`.`fileLimitUnlimited` AS `fileLimitUnlimited`,`qtree_quota`.`fileUsed` AS `fileUsed`,`qtree_quota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`qtree_quota`.`softDiskLimit` AS `softDiskLimit`,`qtree_quota`.`softDiskLimitUnlimited` AS `softDiskLimitUnlimited`,`qtree_quota`.`softFileLimit` AS `softFileLimit`,`qtree_quota`.`softFileLimitUnlimited` AS `softFileLimitUnlimited`,`qtree_quota`.`threshold` AS `threshold`,`qtree_quota`.`thresholdUnlimited` AS `thresholdUnlimited` from `netapp_model_view`.`qtree_quota`