Table d47civi_0z3xa.civicrm_job_log 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 log entry Id
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_job_log_domain_id R
Which Domain is this scheduled job for
run_time timestamp 19 CURRENT_TIMESTAMP Log entry date
job_id int unsigned 10  √  null Pointer to job id - not a FK though, just for logging purposes
name varchar 255  √  null Title of the job
command varchar 255  √  null Full path to file containing job script
description varchar 255  √  null Title line of log entry
data text 65535  √  null Potential extended data for specific job run (e.g. tracebacks).

Table contained 0 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_log_domain_id

Close relationships  within of separation: