Collections functions
Encryption functions
General functions
Render functions
Theme permission functions
Video functions
Resource functions

Table: daily_stat

Daily statistics, grouped by day, usergroup and activity type, for easy summaries used by analytics.

yearint(11)Year the activity took place
monthint(11)Month the activity took place
dayint(11)Day the activity took place
usergroupint(11)See table usergroup
activity_typevarchar(50)The activity type code
object_refint(11)The ID of the table in question, such as the resource ID in the case of a resource activity
countint(11)How many times this activity was carried out on the object in the day in question by any user
externaltinyint(1)Did this activity happen via an external share?

This table is empty by default.

Please see the schema overview for context. This document was last updated on the 13th of June 2021 at 05:35 (Europe/London time).