View netapp_model_view.user_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 UUID of the quota. Equal to the {VolumeUUID}.{QtreeUUID}.{QuotaType}.{QuotaTarget}.{UserHash} Not returned from ZAPI
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
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 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
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

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