Table testdb.public.act_hi_actinst 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
parent_act_inst_id_ varchar 64  √  null
proc_def_key_ varchar 255  √  null
proc_def_id_ varchar 64
root_proc_inst_id_ varchar 64  √  null
proc_inst_id_ varchar 64
execution_id_ varchar 64
act_id_ varchar 255
task_id_ varchar 64  √  null
call_proc_inst_id_ varchar 64  √  null
call_case_inst_id_ varchar 64  √  null
act_name_ varchar 255  √  null
act_type_ varchar 255
assignee_ varchar 255  √  null
start_time_ timestamp 29,6
end_time_ timestamp 29,6  √  null
duration_ int8 19  √  null
act_inst_state_ int4 10  √  null
sequence_counter_ int8 19  √  null
tenant_id_ varchar 64  √  null
removal_time_ timestamp 29,6  √  null

Table contained 0 rows at Tue Apr 16 13:44 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_hi_actinst_pkey
execution_id_ + act_id_ + end_time_ + id_ Performance Asc/Asc/Asc/Asc act_idx_hi_act_inst_comp
end_time_ Performance Asc act_idx_hi_act_inst_end
proc_def_key_ Performance Asc act_idx_hi_act_inst_proc_def_key
proc_inst_id_ + act_id_ Performance Asc/Asc act_idx_hi_act_inst_procinst
removal_time_ Performance Asc act_idx_hi_act_inst_rm_time
start_time_ + end_time_ Performance Asc/Asc act_idx_hi_act_inst_start_end
proc_def_id_ + proc_inst_id_ + act_id_ + end_time_ + act_inst_state_ Performance Asc/Asc/Asc/Asc/Asc act_idx_hi_act_inst_stats
tenant_id_ Performance Asc act_idx_hi_act_inst_tenant_id
root_proc_inst_id_ Performance Asc act_idx_hi_actinst_root_pi
proc_def_id_ + end_time_ Performance Asc/Asc act_idx_hi_ai_pdefid_end_time