# task_log

0 rows

### Description

The log table for all tasks

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
type | SMALLINT | 5 |  |  | null |  |  | The type of task. Scheduled task = 0; Adhoc task = 1.
component | VARCHAR | 255 |  |  |  |  |  | The component that the task belongs to
classname | VARCHAR | 255 |  |  |  |  |  | The class of the task being run
userid | BIGINT | 19 |  |  | null |  |
user.id | tasklog_use2_fkR
| The userid that the task was configured to run as (Adhoc tasks only)
timestart | DECIMAL | 20,10 |  |  | null |  |  | The start time of the task
timeend | DECIMAL | 20,10 |  |  | null |  |  | The end time of the task
dbreads | BIGINT | 19 |  |  | null |  |  | The number of DB reads performed during the task.
dbwrites | BIGINT | 19 |  |  | null |  |  | The number of DB writes performed during the task.
result | TINYINT | 3 |  |  | null |  |  | Whether the task was successful or not. 0 = pass; 1 = fail.
output | LONGTEXT | 2147483647 |  |  | null |  |  |
hostname | VARCHAR | 255 | √ |  | null |  |  | Hostname where the task was executed
pid | BIGINT | 19 | √ |  | null |  |  | PHP process ID that was running the task

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
tasklog_cla_ix | Performance | Asc | classname
tasklog_tim_ix | Performance | Asc | timestart
tasklog_use_ix | Performance | Asc | userid

### Relationships