View tariqa3.app_log_pagesaccessperyear 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
Year int 10  √  null
Page text 65535  √  null
Accessed bigint 19 0

Analyzed at Wed Apr 25 13:30 CEST 2012

View Definition:
select year(`d`.`time`) AS `Year`,`d`.`value` AS `Page`,count(`d`.`value`) AS `Accessed` from (`tariqa3`.`app_log_details` `d` join `tariqa3`.`app_log` `l` on((`d`.`log_id` = `l`.`log_id`))) where ((`d`.`key` = 'module') and (`access_type`(`l`.`url`) = 'page') and (not(`operator`(`l`.`user_id`)))) group by 1,2 order by 1,2 desc
 
Possibly Referenced Tables/Views: