Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Job log entry Id |
|||
| domain_id | INT UNSIGNED | 10 | null |
|
|
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). |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_job_log_domain_id | Performance | Asc | domain_id |
Relationships
Close relationships within degrees of separation
