Block Zoola Reports Schedule Table Schema (block_zoola_reports_schedule)


Description

Scheduled reports

block_zoola_reports_schedule table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null
user.id Implied Constraint R

User ID

courseid BIGINT 19 null
course.id Implied Constraint R

Course ID

reporturi VARCHAR 1333

Zoola report URI

sendtouser BIT 0 null

Add related user's email to recipient list

emails VARCHAR 1333 null

Comma separated list of emails

subject VARCHAR 1333 null

Email subject

body LONGTEXT 2147483647 null

Email body

retry BIGINT 19 null

How many times scheduling failed

Table contained -1 rows

block_zoola_reports_schedule table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

block_zoola_reports_schedule table relationships