Table d44civi_9xzwf.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 enum 7  √  Daily Scheduled job run frequency.
last_run datetime 19  √  null When was this cron entry last 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 16 rows at Wed Nov 11 17:14 EST 2015

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: