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