View ocum.resourcepoollivelistdtoview 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
name varchar 255
resourceKey varchar 512
description longtext 2147483647  √  null
snapLockType longtext 2147483647  √  null
capacityTotal bigint 19
capacityUsed bigint 19
capacityUsedPercent decimal 26,4  √  null
capacityAvailable bigint 19

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`resourcepool`.`id` AS `id`,`ocum`.`resourcepool`.`objectName` AS `name`,`ocum`.`resourcepool`.`resourceKey` AS `resourceKey`,`ocum`.`resourcepool`.`description` AS `description`,`ocum`.`resourcepool`.`snapLockType` AS `snapLockType`,`ocum`.`resourcepool`.`capacityTotal` AS `capacityTotal`,`ocum`.`resourcepool`.`capacityUsed` AS `capacityUsed`,(case when (`ocum`.`resourcepool`.`capacityTotal` = 0) then 0 else ((`ocum`.`resourcepool`.`capacityUsed` / `ocum`.`resourcepool`.`capacityTotal`) * 100) end) AS `capacityUsedPercent`,`ocum`.`resourcepool`.`capacityAvailable` AS `capacityAvailable` from `ocum`.`resourcepool`
 
Possibly Referenced Tables/Views: