Table testdb.public.act_hi_decinst 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
dec_def_id_ varchar 64
dec_def_key_ varchar 255
dec_def_name_ varchar 255  √  null
proc_def_key_ varchar 255  √  null
proc_def_id_ varchar 64  √  null
proc_inst_id_ varchar 64  √  null
case_def_key_ varchar 255  √  null
case_def_id_ varchar 64  √  null
case_inst_id_ varchar 64  √  null
act_inst_id_ varchar 64  √  null
act_id_ varchar 255  √  null
eval_time_ timestamp 29,6
removal_time_ timestamp 29,6  √  null
collect_value_ float8 17,17  √  null
user_id_ varchar 255  √  null
root_dec_inst_id_ varchar 64  √  null
root_proc_inst_id_ varchar 64  √  null
dec_req_id_ varchar 64  √  null
dec_req_key_ varchar 255  √  null
tenant_id_ varchar 64  √  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_decinst_pkey
act_id_ Performance Asc act_idx_hi_dec_inst_act
act_inst_id_ Performance Asc act_idx_hi_dec_inst_act_inst
case_inst_id_ Performance Asc act_idx_hi_dec_inst_ci
dec_def_id_ Performance Asc act_idx_hi_dec_inst_id
dec_def_key_ Performance Asc act_idx_hi_dec_inst_key
proc_inst_id_ Performance Asc act_idx_hi_dec_inst_pi
dec_req_id_ Performance Asc act_idx_hi_dec_inst_req_id
dec_req_key_ Performance Asc act_idx_hi_dec_inst_req_key
removal_time_ Performance Asc act_idx_hi_dec_inst_rm_time
root_dec_inst_id_ Performance Asc act_idx_hi_dec_inst_root_id
root_proc_inst_id_ Performance Asc act_idx_hi_dec_inst_root_pi
tenant_id_ Performance Asc act_idx_hi_dec_inst_tenant_id
eval_time_ Performance Asc act_idx_hi_dec_inst_time