Skip to content

Instantly share code, notes, and snippets.

@nestorw
Created February 28, 2018 19:52
Show Gist options
  • Save nestorw/cf1573d82bdf817c71266451b06a291e to your computer and use it in GitHub Desktop.
Save nestorw/cf1573d82bdf817c71266451b06a291e to your computer and use it in GitHub Desktop.
[Hyrax Analytics tables] #hyrax

Both of these tables might be able to be combined and we could add a stat_type field to discern them.

foreign keys for work_id, fileset_id, and depositor_id will help with summing up counts for aggrigate reporting.

file_stats

  • id
  • file_id
  • work_id
  • fileset_id
  • depositor_id
  • date
  • downloads
  • views

work_stats

  • id
  • work_id
  • depositor_id
  • date
  • views
  • unique_visitors

Work and file status tables coming soon...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment