View netapp_model_view.node_license_usage_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.
originid bigint 19
uuid varchar 255 A unique identifier assigned to a LicenseV2EntitlementRisk operation.
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table
inUse bit 0  √  null Usage status for the node.
isLicensed bit 0  √  null Whether the node has a node-liked license
nodeName varchar 255  √  null Name of the node.
serialNumber varchar 255  √  null Node Serial Number.
licenseV2EntitlementRiskId bigint 19 Foreign key to license_v2_entitlement_risk table.
nodeId bigint 19 Foreign key to node table.
createtime bigint 19
updatetime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`node_license_usage`.`objid` AS `objid`,`netapp_model`.`node_license_usage`.`originid` AS `originid`,`netapp_model`.`node_license_usage`.`uuid` AS `uuid`,`netapp_model`.`node_license_usage`.`resourceKey` AS `resourceKey`,`netapp_model`.`node_license_usage`.`clusterId` AS `clusterId`,`netapp_model`.`node_license_usage`.`inUse` AS `inUse`,`netapp_model`.`node_license_usage`.`isLicensed` AS `isLicensed`,`netapp_model`.`node_license_usage`.`nodeName` AS `nodeName`,`netapp_model`.`node_license_usage`.`serialNumber` AS `serialNumber`,`netapp_model`.`node_license_usage`.`licenseV2EntitlementRiskId` AS `licenseV2EntitlementRiskId`,`netapp_model`.`node_license_usage`.`nodeId` AS `nodeId`,`netapp_model`.`node_license_usage`.`createtime` AS `createtime`,`netapp_model`.`node_license_usage`.`updatetime` AS `updatetime`,`netapp_model`.`node_license_usage`.`objState` AS `objState` from `netapp_model`.`node_license_usage`