...
| Column | type | description |
|---|---|---|
| ID | VARCHAR | uuid |
| GROUPER_SYNC_ID | VARCHAR | foreign key back to grouper_sync |
| SYNC_TYPE | VARCHAR | up to the sync_engine what is available. e.g. full_sync, incremental, group_sync, user_sync, daemon, etc |
| JOB_STATE | VARCHAR | RUNNING, PENDING, SUCCESS, ERROR. used for job coordination |
| LAST_SYNC_INDEX_OR_MILLIS | INTEGER | for incremental jobs, this is the last index processed, or the last timestamp processed (millis since 1970) |
| LAST_TIME_WORK_WAS_DONE | TIMESTAMP | if work was actually accomplished, this is the last time. for instance if 2 hours of incrementals have passed and no work needed to be done, then do not update this field |
| (TODO) add: JOB_STATE_LAST_UPDATED | TIMESTAMP | Heartbeat column that is updated as a job is running in a thread (e.g. every 15 seconds) |
| LAST_UPDATED | TIMESTAMP | when this record was last updated |
...