Task Adhoc Table Schema (task_adhoc)


Description

List of adhoc tasks waiting to run.

task_adhoc table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
local_ld_import_logs_status.adhoctaskid localdimpologsstat_adh2_fk R
component VARCHAR 255

The component that triggered this adhoc task.
classname VARCHAR 255

The name of the class extending adhoc_task to run when this task is executed.
nextruntime BIGINT 19 null
faildelay BIGINT 19 √ null
customdata LONGTEXT 2147483647 √ null

Custom data to be passed to the adhoc task. Must be serialisable using json_encode()
userid BIGINT 19 √ null
user.id taskadho_use2_fk R
blocking TINYINT 3 0

Table contained -1 rows

task_adhoc table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
taskadho_nex_ix Performance Asc nextruntime
taskadho_use_ix Performance Asc userid

task_adhoc table relationships

Close relationships within degrees of separation