sys_admin_job


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
sys_users.user_id FK5322EBDB28C762A3 R
attempt INT 10 √ null
notify_user_id INT 10 √ null
sys_users.user_id FK5322EBDB255B47AD R
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

Relationships

Close relationships within degrees of separation