Block Zoola Reports Schedule Table Schema (block_zoola_reports_schedule)


Description

Reports scheduled from an event

block_zoola_reports_schedule table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
eventcfgid BIGINT 19 0
block_zoola_reports_eventcfg.id bloczoolreposche_eve2_fk R

Foreign key to block_zoola_reports_eventcfg
userid BIGINT 19 null
user.id Implied Constraint R

User ID
courseid BIGINT 19 null
course.id Implied Constraint R

Course ID
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
bloczoolreposche_eve_ix Performance Asc eventcfgid

block_zoola_reports_schedule table relationships

Close relationships within degrees of separation