Table | job_history_records |
|---|---|
Description | Job Transaction History |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| job_id | integer, foreign key | Job ID | jobs:id | | |
| record_key | varchar(64) | Record Key | As defined by the Plugin | ||
| person_id | integer, foreign key | Person ID this record applies to | people:id | ||
| external_identity_id | integer, foreign key | External Identity ID this record applies to | external_identities:id | ||
comment | varchar(256) | Description of the job task | |||
| status | varchar(2) | Status of the job task |
|