View ocum_report.volumecapacityhistorymonthview 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
volumeId bigint 19
periodEndTime timestamp 19 0000-00-00 00:00:00
sampleCount int 10 1
UsedSum bigint 19 0
Total bigint 19 0
SnapshotUsedSum bigint 19 0
SnapshotTotal bigint 19 0
DedupeSpaceSavingsSum bigint 19 0
CompressionSpaceSavingsSum bigint 19 0

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `ocum`.`volumehistorymonth`.`volumeId` AS `volumeId`,`ocum`.`volumehistorymonth`.`periodEndTime` AS `periodEndTime`,`ocum`.`volumehistorymonth`.`sampleCount` AS `sampleCount`,`ocum`.`volumehistorymonth`.`dfKBytesUsedSum` AS `UsedSum`,`ocum`.`volumehistorymonth`.`dfKBytesTotal` AS `Total`,`ocum`.`volumehistorymonth`.`dfSnapshotKBytesUsedSum` AS `SnapshotUsedSum`,`ocum`.`volumehistorymonth`.`dfSnapshotKBytesTotal` AS `SnapshotTotal`,`ocum`.`volumehistorymonth`.`dfKBytesDedupeSpaceSavingsSum` AS `DedupeSpaceSavingsSum`,`ocum`.`volumehistorymonth`.`dfKBytesCompressionSpaceSavingsSum` AS `CompressionSpaceSavingsSum` from `ocum`.`volumehistorymonth`