Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
schedule_id | CHAR | 32 |
|
|
||||||
task_id | CHAR | 32 |
|
|
||||||
active | BIT | 1 | 0 |
|
|
|||||
title | VARCHAR | 255 | √ | null |
|
|
||||
description | VARCHAR | 4096 | √ | null |
|
|
||||
parameters | TEXT | 65535 | √ | null |
|
|
||||
priority | enum('low', 'normal', 'high') | 6 | normal |
|
|
|||||
type | enum('periodic', 'once') | 8 | periodic |
|
|
|||||
minute | TINYINT | 3 | √ | null |
|
|
||||
hour | TINYINT | 3 | √ | null |
|
|
||||
day | TINYINT | 3 | √ | null |
|
|
||||
month | TINYINT | 3 | √ | null |
|
|
||||
day_of_week | BIT | 1 | √ | null |
|
|
||||
next_execution | INT UNSIGNED | 10 | 0 |
|
|
|||||
last_execution | INT UNSIGNED | 10 | √ | null |
|
|
||||
last_result | TEXT | 65535 | √ | null |
|
|
||||
execution_count | BIGINT UNSIGNED | 20 | 0 |
|
|
|||||
mkdate | INT UNSIGNED | 10 | null |
|
|
|||||
chdate | INT UNSIGNED | 10 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | schedule_id |
task_id | Performance | Asc | task_id |