View opm.provisioning_policy_view 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
id bigint 19 0
uuid varchar 512
name varchar 255  √  null
description text 65535  √  null Provisioning policy used for workload provisioning.
spaceThinProvisioned bit 0 Specifies whether to use thin-provisioning for storage items.
deduplication enum 10 INLINE Specifies whether or not and what type of deduplication to be applied on the provisioned data.
compression enum 10 INLINE Specifies whether or not and what type of compression to be applied on the provisioned data.
systemDefined bit 0 0 Indicates if this is a system-provided provisioningg policy.
createTime bigint 19
updateTime bigint 19
workloadCount bigint 19 0

Analyzed at Tue Apr 23 04:58 EDT 2019

View Definition:
select `p`.`id` AS `id`,`p`.`uuid` AS `uuid`,`p`.`name` AS `name`,`p`.`description` AS `description`,`p`.`spaceThinProvisioned` AS `spaceThinProvisioned`,`p`.`deduplication` AS `deduplication`,`p`.`compression` AS `compression`,`p`.`systemDefined` AS `systemDefined`,`p`.`createTime` AS `createTime`,`p`.`updateTime` AS `updateTime`,count(`w`.`provisioningPolicyId`) AS `workloadCount` from (`opm`.`provisioning_policy` `p` left join `opm`.`workload_provision_mapping` `w` on((`w`.`provisioningPolicyId` = `p`.`id`))) group by `p`.`name`
 
Possibly Referenced Tables/Views: