View netapp_model_view.license_v2_entitlement_risk_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
action varchar 255  √  null Corrective action text.
actionCode enum 20  √  null Corrective action needed to reduce cluster license entitlement risk.
actionCodeRaw varchar 255  √  null Corrective action needed to reduce cluster license entitlement risk raw value.
package enum 19  √  null Name of the license package.
packageRaw varchar 255  √  null Name of the license package raw value.
risk enum 10  √  null Entitlement risk for the license package.
riskRaw varchar 255  √  null Entitlement risk for the license package raw value.
createtime bigint 19
updatetime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`license_v2_entitlement_risk`.`objid` AS `objid`,`netapp_model`.`license_v2_entitlement_risk`.`originid` AS `originid`,`netapp_model`.`license_v2_entitlement_risk`.`uuid` AS `uuid`,`netapp_model`.`license_v2_entitlement_risk`.`resourceKey` AS `resourceKey`,`netapp_model`.`license_v2_entitlement_risk`.`clusterId` AS `clusterId`,`netapp_model`.`license_v2_entitlement_risk`.`action` AS `action`,`netapp_model`.`license_v2_entitlement_risk`.`actionCode` AS `actionCode`,`netapp_model`.`license_v2_entitlement_risk`.`actionCodeRaw` AS `actionCodeRaw`,`netapp_model`.`license_v2_entitlement_risk`.`package` AS `package`,`netapp_model`.`license_v2_entitlement_risk`.`packageRaw` AS `packageRaw`,`netapp_model`.`license_v2_entitlement_risk`.`risk` AS `risk`,`netapp_model`.`license_v2_entitlement_risk`.`riskRaw` AS `riskRaw`,`netapp_model`.`license_v2_entitlement_risk`.`createtime` AS `createtime`,`netapp_model`.`license_v2_entitlement_risk`.`updatetime` AS `updatetime`,`netapp_model`.`license_v2_entitlement_risk`.`objState` AS `objState` from `netapp_model`.`license_v2_entitlement_risk`