Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

Table: daily_stat

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

ColumnTypeNote
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 12th of July 2020 at 06:35 (Europe/London time).