Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
|||||
| version | BIGINT | 19 | null |
|
|
||||||
| argument | LONGTEXT | 2147483647 | null |
|
|
||||||
| end | DATETIME | 19 | √ | null |
|
|
|||||
| message | LONGTEXT | 2147483647 | null |
|
|
||||||
| method | VARCHAR | 255 | null |
|
|
||||||
| name | VARCHAR | 100 | null |
|
|
||||||
| service | VARCHAR | 50 | null |
|
|
||||||
| start | DATETIME | 19 | null |
|
|
||||||
| status | VARCHAR | 255 | null |
|
|
||||||
| notify_on_complete | BIT | 1 | √ | null |
|
|
|||||
| user_id | INT | 10 | √ | null |
|
|
|||||
| attempt | INT | 10 | √ | null |
|
|
|||||
| notify_user_id | INT | 10 | √ | null |
|
|
|||||
| failed_lines | LONGTEXT | 2147483647 | null |
|
|
||||||
| failure_count | INT | 10 | null |
|
|
||||||
| success_count | INT | 10 | null |
|
|
||||||
| last_run | DATETIME | 23 | √ | null |
|
|
|||||
| file_name | VARCHAR | 255 | √ | null |
|
|
|||||
| success_lines | LONGTEXT | 2147483647 | null |
|
|
||||||
| business_hours_approved | BIT | 1 | √ | null |
|
|
|||||
| params | LONGTEXT | 2147483647 | √ | null |
|
|
|||||
| complete_method | VARCHAR | 50 | √ | null |
|
|
|||||
| result_data | LONGTEXT | 2147483647 | √ | null |
|
|
|||||
| container | VARCHAR | 80 | LEGACY |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK5322EBDB255B47AD | Performance | Asc | notify_user_id |
| FK5322EBDB28C762A3 | Performance | Asc | user_id |
| IX_sys_admin_job_container_status | Performance | Asc/Asc | container + status |
| IX_sys_admin_job_status | Performance | Asc | status |

