Table d47civi_0z3xa.civicrm_job 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
id int unsigned 10  √  Job Id
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_job_domain_id R
Which Domain is this scheduled job for
run_frequency varchar 8  √  Daily Scheduled job run frequency.
last_run datetime 19  √  null When was this cron entry last run
scheduled_run_date timestamp 19  √  null When is this cron entry scheduled to run
name varchar 255  √  null Title of the job
description varchar 255  √  null Description of the job
api_entity varchar 255  √  null Entity of the job api call
api_action varchar 255  √  null Action of the job api call
parameters text 65535  √  null List of parameters to the command.
is_active tinyint 3  √  null Is this job active?

Table contained 19 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
domain_id Performance Asc FK_civicrm_job_domain_id

Close relationships  within of separation: