View ocum_report.volumerelationshiphistoryaggweekhourview 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
aggTransferSize decimal 41  √  null
endTime varchar 13  √  null
dayCount int 10  √  null
endDate date 10  √  null
day varchar 9  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select sum(`volumerelationshiphistoryview`.`transferSize`) AS `aggTransferSize`,date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00') AS `endTime`,weekday(`volumerelationshiphistoryview`.`endTime`) AS `dayCount`,cast(`volumerelationshiphistoryview`.`endTime` as date) AS `endDate`,dayname(cast(`volumerelationshiphistoryview`.`endTime` as date)) AS `day` from `ocum_report`.`volumerelationshiphistoryview` where ((cast(`volumerelationshiphistoryview`.`endTime` as date) >= (curdate() - interval 7 day)) and (cast(`volumerelationshiphistoryview`.`endTime` as date) < curdate())) group by date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00'),weekday(`volumerelationshiphistoryview`.`endTime`),cast(`volumerelationshiphistoryview`.`endTime` as date),dayname(cast(`volumerelationshiphistoryview`.`endTime` as date)) order by date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00')
 
Possibly Referenced Tables/Views: