View ocum_report.volumecapacityhistoryyearview 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`.`volumehistoryyear`.`volumeId` AS `volumeId`,`ocum`.`volumehistoryyear`.`periodEndTime` AS `periodEndTime`,`ocum`.`volumehistoryyear`.`sampleCount` AS `sampleCount`,`ocum`.`volumehistoryyear`.`dfKBytesUsedSum` AS `UsedSum`,`ocum`.`volumehistoryyear`.`dfKBytesTotal` AS `Total`,`ocum`.`volumehistoryyear`.`dfSnapshotKBytesUsedSum` AS `SnapshotUsedSum`,`ocum`.`volumehistoryyear`.`dfSnapshotKBytesTotal` AS `SnapshotTotal`,`ocum`.`volumehistoryyear`.`dfKBytesDedupeSpaceSavingsSum` AS `DedupeSpaceSavingsSum`,`ocum`.`volumehistoryyear`.`dfKBytesCompressionSpaceSavingsSum` AS `CompressionSpaceSavingsSum` from `ocum`.`volumehistoryyear`