Table testdb.public.act_hi_job_log Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id_ varchar 64
timestamp_ timestamp 29,6
job_id_ varchar 64
job_duedate_ timestamp 29,6  √  null
job_retries_ int4 10  √  null
job_priority_ int8 19 0
job_exception_msg_ varchar 4000  √  null
job_exception_stack_id_ varchar 64  √  null
job_state_ int4 10  √  null
job_def_id_ varchar 64  √  null
job_def_type_ varchar 255  √  null
job_def_configuration_ varchar 255  √  null
act_id_ varchar 255  √  null
failed_act_id_ varchar 255  √  null
execution_id_ varchar 64  √  null
root_proc_inst_id_ varchar 64  √  null
process_instance_id_ varchar 64  √  null
process_def_id_ varchar 64  √  null
process_def_key_ varchar 255  √  null
deployment_id_ varchar 64  √  null
sequence_counter_ int8 19  √  null
tenant_id_ varchar 64  √  null
hostname_ varchar 255  √  null
removal_time_ timestamp 29,6  √  null
batch_id_ varchar 64  √  null

Table contained 0 rows at Mon Dec 23 18:09 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_hi_job_log_pkey
job_exception_stack_id_ Performance Asc act_idx_hi_job_log_ex_stack
job_def_configuration_ Performance Asc act_idx_hi_job_log_job_conf
job_def_id_ Performance Asc act_idx_hi_job_log_job_def_id
process_def_key_ Performance Asc act_idx_hi_job_log_proc_def_key
process_def_id_ Performance Asc act_idx_hi_job_log_procdef
process_instance_id_ Performance Asc act_idx_hi_job_log_procinst
removal_time_ Performance Asc act_idx_hi_job_log_rm_time
root_proc_inst_id_ Performance Asc act_idx_hi_job_log_root_pi
tenant_id_ Performance Asc act_idx_hi_job_log_tenant_id