View ocum.volumetransferrateweeklyview 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
totalTransferSize decimal 46,3  √  null
endTime varchar 24  √  null
day varchar 9  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select round((sum(`volumedatatransferstatusview`.`transferSize`) / 1024),3) AS `totalTransferSize`,date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') AS `endTime`,dayname(cast(`volumedatatransferstatusview`.`transferEndTime` as date)) AS `day` from `ocum`.`volumedatatransferstatusview` where ((cast(`volumedatatransferstatusview`.`transferEndTime` as date) >= (curdate() - interval 7 day)) and (cast(`volumedatatransferstatusview`.`transferEndTime` as date) < curdate())) group by date_format(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00'),'%H:00:00'),weekday(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00')),cast(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') as date),dayname(cast(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') as date)) order by `endTime`
 
Possibly Referenced Tables/Views: