cronjobs_schedules

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
schedule_id CHAR 32
cronjobs_logs.schedule_id Implied ConstraintR
task_id CHAR 32
cronjobs_tasks.task_id Implied ConstraintR
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

Relationships