View netapp_model_view.license 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: interim-license-list-get.licenses.interim-license-cluster-info
uuid varchar 255 Globally unique ID of the license. DERIVED from {clusterUUID}.{package name}.{serial number}
resourceKey varchar 512
clusterId bigint 19
ownerNodeId bigint 19  √  null objId of Node, present only if ownerType is NODE
ownerType enum 7  √  null The entity type of the owner
ownerName varchar 255  √  null The name of the owner that owns the serial number.
package varchar 255 Name of licensed feature
serialNumber varchar 255  √  null Serial number of owning entity (cluster in RR.x)
expirationTime timestamp 19  √  null License expiration time
description varchar 255  √  null Description of the licensed package
licenseType enum 10  √  null Identifies license type
licenseTypeRaw varchar 255  √  null Identifies license type
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`license`.`objid` AS `objid`,`netapp_model`.`license`.`uuid` AS `uuid`,`netapp_model`.`license`.`resourceKey` AS `resourceKey`,`netapp_model`.`license`.`clusterId` AS `clusterId`,`netapp_model`.`license`.`ownerNodeId` AS `ownerNodeId`,`netapp_model`.`license`.`ownerType` AS `ownerType`,`netapp_model`.`license`.`ownerName` AS `ownerName`,`netapp_model`.`license`.`package` AS `package`,`netapp_model`.`license`.`serialNumber` AS `serialNumber`,`netapp_model`.`license`.`expirationTime` AS `expirationTime`,`netapp_model`.`license`.`description` AS `description`,`netapp_model`.`license`.`licenseType` AS `licenseType`,`netapp_model`.`license`.`licenseTypeRaw` AS `licenseTypeRaw`,`netapp_model`.`license`.`createtime` AS `createTime`,`netapp_model`.`license`.`updatetime` AS `updateTime` from `netapp_model`.`license` where (`netapp_model`.`license`.`objState` = 'LIVE')