Table studip24.cronjobs_schedules Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
schedule_id char 32
cronjobs_logs.schedule_id Implied Constraint R
task_id char 32
cronjobs_tasks.task_id Implied Constraint R
active bit 0 0
title varchar 255  √  null
description varchar 4096  √  null
parameters text 65535  √  null
priority enum 6 normal
type enum 9 periodic
minute tinyint 3  √  null
hour tinyint 3  √  null
day tinyint 3  √  null
month tinyint 3  √  null
day_of_week bit 0  √  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
chdate int unsigned 10

Table contained 0 rows at Do Aug 02 14:46 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
schedule_id Primary key Asc PRIMARY
task_id Performance Asc task_id

Close relationships: