View ocum_report_birt.aggregatecapacityutilizationhistory 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
aggregateId bigint 19
periodEndTime timestamp 19 0000-00-00 00:00:00
dfKBytesUsedSum bigint 19 0

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `ocum`.`aggregatehistoryyear`.`aggregateId` AS `aggregateId`,`ocum`.`aggregatehistoryyear`.`periodEndTime` AS `periodEndTime`,`ocum`.`aggregatehistoryyear`.`dfKBytesUsedSum` AS `dfKBytesUsedSum` from `ocum`.`aggregatehistoryyear` where (cast(`ocum`.`aggregatehistoryyear`.`periodEndTime` as date) >= (now() - interval 13 month)) order by `ocum`.`aggregatehistoryyear`.`periodEndTime`