Table testdb.public.act_hi_caseinst 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
case_inst_id_ varchar 64
business_key_ varchar 255  √  null
case_def_id_ varchar 64
create_time_ timestamp 29,6
close_time_ timestamp 29,6  √  null
duration_ int8 19  √  null
state_ int4 10  √  null
create_user_id_ varchar 255  √  null
super_case_instance_id_ varchar 64  √  null
super_process_instance_id_ varchar 64  √  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_caseinst_pkey
case_inst_id_ Must be unique Asc act_hi_caseinst_case_inst_id__key
business_key_ Performance Asc act_idx_hi_cas_i_buskey
close_time_ Performance Asc act_idx_hi_cas_i_close
tenant_id_ Performance Asc act_idx_hi_cas_i_tenant_id