Table testdb.public.act_ru_job 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
rev_ int4 10  √  null
type_ varchar 255
lock_exp_time_ timestamp 29,6  √  null
lock_owner_ varchar 255  √  null
exclusive_ bool 1  √  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
retries_ int4 10  √  null
exception_stack_id_ varchar 64  √  null
act_ge_bytearray.id_ act_fk_job_exception R
exception_msg_ varchar 4000  √  null
failed_act_id_ varchar 255  √  null
duedate_ timestamp 29,6  √  null
repeat_ varchar 255  √  null
repeat_offset_ int8 19  √  0
handler_type_ varchar 255  √  null
handler_cfg_ varchar 4000  √  null
deployment_id_ varchar 64  √  null
suspension_state_ int4 10 1
job_def_id_ varchar 64  √  null
priority_ int8 19 0
sequence_counter_ int8 19  √  null
tenant_id_ varchar 64  √  null
create_time_ timestamp 29,6  √  null
last_failure_log_id_ varchar 64  √  null
batch_id_ varchar 64  √  null

Table contained 0 rows at Tue Nov 19 14:56 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_ru_job_pkey
exception_stack_id_ Performance Asc act_idx_job_exception
execution_id_ Performance Asc act_idx_job_execution_id
handler_type_ + handler_cfg_ Performance Asc/Asc act_idx_job_handler
handler_type_ Performance Asc act_idx_job_handler_type
job_def_id_ Performance Asc act_idx_job_job_def_id
process_instance_id_ Performance Asc act_idx_job_procinst
root_proc_inst_id_ Performance Asc act_idx_job_root_procinst
tenant_id_ Performance Asc act_idx_job_tenant_id

Close relationships  within of separation: