View ocum_report.userquota 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 UUID of the quota. Equal to the {VolumeUUID}.{QtreeUUID}.{QuotaType}.{QuotaTarget}.{UserHash} Not returned from ZAPI
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 For an explicit quota, this value is specified in the /etc/quotas file and the domain in the QUOTA_TARGET_DOMAIN directive is in effect. Multiple targets are comma separated. For a derived quota, the field is blank.
quotaType enum 10  √  null Type of quota
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
users varchar 1024  √  null Specifies all associated users of the quota in ordered CSV style strings

Analyzed at Tue Apr 23 04:52 EDT 2019

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