View netapp_model_view.quota_user_full 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.quota-users.quota-user
originid bigint 19
uuid varchar 255 UUID of the quota. Equal to the {QuotaUUID}.{quotaUserName} Not returned from ZAPI
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
userQuotaId bigint 19 Reference to the userquota to which this user belongs to
quotaUserId varchar 255  √  null The id of the user. The quota-user-type determines the format. For uid and gid, the format is an integer. For sid, the format is the usual style
quotaUserName varchar 255  √  null Name of the user, group, or sid
quotaUserType enum 10  √  null Type of quota user
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`quota_user`.`objid` AS `objid`,`netapp_model`.`quota_user`.`originid` AS `originid`,`netapp_model`.`quota_user`.`uuid` AS `uuid`,`netapp_model`.`quota_user`.`resourceKey` AS `resourceKey`,`netapp_model`.`quota_user`.`clusterId` AS `clusterId`,`netapp_model`.`quota_user`.`vserverId` AS `vserverId`,`netapp_model`.`quota_user`.`userQuotaId` AS `userQuotaId`,`netapp_model`.`quota_user`.`quotaUserId` AS `quotaUserId`,`netapp_model`.`quota_user`.`quotaUserName` AS `quotaUserName`,`netapp_model`.`quota_user`.`quotaUserType` AS `quotaUserType`,`netapp_model`.`quota_user`.`createtime` AS `createTime`,`netapp_model`.`quota_user`.`updatetime` AS `updateTime`,`netapp_model`.`quota_user`.`objState` AS `objState` from `netapp_model`.`quota_user`