job


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 √ null
name varchar 6 √ null
description varchar 1 √ null
source varchar 6 √ null
is_system_source bool 1 √ null
type varchar 15 √ null
export_type_specific_parameters jsonb 2147483647 √ null
status varchar 10 √ null
files jsonb 2147483647 √ null
start_time timestamp 29,6 √ null
end_time timestamp 29,6 √ null
created_date timestamp 29,6 √ null
created_by_user_id uuid 2147483647 √ null
created_by_username varchar 6 √ null
updated_date timestamp 29,6 √ null
updated_by_user_id uuid 2147483647 √ null
updated_by_username varchar 6 √ null
output_format varchar 28 √ null
error_details varchar 1 √ null
batch_status varchar 9 √ null
exit_status jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
job_pkey Primary key Asc __id
job___origin_idx Performance Asc __origin
job___source_idx Performance Asc __source
job___start_idx Performance Asc __start
job_batch_status_idx Performance Asc batch_status
job_created_by_user_id_idx Performance Asc created_by_user_id
job_created_by_username_idx Performance Asc created_by_username
job_created_date_idx Performance Asc created_date
job_description_idx Performance Asc description
job_end_time_idx Performance Asc end_time
job_error_details_idx Performance Asc error_details
job_id_idx Performance Asc id
job_is_system_source_idx Performance Asc is_system_source
job_name_idx Performance Asc name
job_output_format_idx Performance Asc output_format
job_source_idx Performance Asc source
job_start_time_idx Performance Asc start_time
job_status_idx Performance Asc status
job_type_idx Performance Asc type
job_updated_by_user_id_idx Performance Asc updated_by_user_id
job_updated_by_username_idx Performance Asc updated_by_username
job_updated_date_idx Performance Asc updated_date

Diagram producer might be missing

No diagrams were produced please see application output for any errors