View netapp_model_view.quota_policy_rule 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-list-entries-iter.quota-entry
uuid varchar 255 UUID of the quota. Equal to the {VolumeUUID}.{QtreeUUID}.{QuotaPolicyUUID}.{QuotaType}.{QuotaTargetHash}. 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 policy rule belongs to
qtreeId bigint 19  √  null Reference to the qtree to which this quota policy rule applies
quotaPolicyId bigint 19  √  null Reference to the quota policy to which this quota policy rule 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
quotaTypeRaw varchar 255  √  null Raw value for type of quota
diskLimit bigint 19  √  null Maximum amount of disk space, in kilobytes, allowed for the quota target (hard disk space limit)
isDiskLimitUnlimited bit 0  √  null True if there is no disk limit
fileLimit bigint 19  √  null Maximum number of files allowed for the quota target (hard files limit)
isFileLimitUnlimited bit 0  √  null True if there is no file limit
softDiskLimit bigint 19  √  null Soft disk space limit, in kilobytes, for the quota target
isSoftDiskLimitUnlimited bit 0  √  null True if there is no soft disk limit
softFileLimit bigint 19  √  null Soft file limit, in number of files, for the quota target
isSoftFileLimitUnlimited bit 0  √  null True if there is no soft file limit
threshold bigint 19  √  null Disk space threshold, in kilobytes, for the quota target
isThresholdUnlimited bit 0  √  null True if there is no threshold limit
isPerformUserMapping bit 0  √  null If the value is true, user mapping will be performed for this rule
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`quota_policy_rule`.`objid` AS `objid`,`netapp_model`.`quota_policy_rule`.`uuid` AS `uuid`,`netapp_model`.`quota_policy_rule`.`resourceKey` AS `resourceKey`,`netapp_model`.`quota_policy_rule`.`clusterId` AS `clusterId`,`netapp_model`.`quota_policy_rule`.`vserverId` AS `vserverId`,`netapp_model`.`quota_policy_rule`.`volumeId` AS `volumeId`,`netapp_model`.`quota_policy_rule`.`qtreeId` AS `qtreeId`,`netapp_model`.`quota_policy_rule`.`quotaPolicyId` AS `quotaPolicyId`,`netapp_model`.`quota_policy_rule`.`quotaTarget` AS `quotaTarget`,`netapp_model`.`quota_policy_rule`.`quotaType` AS `quotaType`,`netapp_model`.`quota_policy_rule`.`quotaTypeRaw` AS `quotaTypeRaw`,`netapp_model`.`quota_policy_rule`.`diskLimit` AS `diskLimit`,`netapp_model`.`quota_policy_rule`.`isDiskLimitUnlimited` AS `isDiskLimitUnlimited`,`netapp_model`.`quota_policy_rule`.`fileLimit` AS `fileLimit`,`netapp_model`.`quota_policy_rule`.`isFileLimitUnlimited` AS `isFileLimitUnlimited`,`netapp_model`.`quota_policy_rule`.`softDiskLimit` AS `softDiskLimit`,`netapp_model`.`quota_policy_rule`.`isSoftDiskLimitUnlimited` AS `isSoftDiskLimitUnlimited`,`netapp_model`.`quota_policy_rule`.`softFileLimit` AS `softFileLimit`,`netapp_model`.`quota_policy_rule`.`isSoftFileLimitUnlimited` AS `isSoftFileLimitUnlimited`,`netapp_model`.`quota_policy_rule`.`threshold` AS `threshold`,`netapp_model`.`quota_policy_rule`.`isThresholdUnlimited` AS `isThresholdUnlimited`,`netapp_model`.`quota_policy_rule`.`isPerformUserMapping` AS `isPerformUserMapping`,`netapp_model`.`quota_policy_rule`.`createtime` AS `createTime`,`netapp_model`.`quota_policy_rule`.`updatetime` AS `updateTime` from `netapp_model`.`quota_policy_rule` where (`netapp_model`.`quota_policy_rule`.`objState` = 'LIVE')