Table testdb.public.act_hi_detail 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
type_ varchar 255
proc_def_key_ varchar 255  √  null
proc_def_id_ varchar 64  √  null
root_proc_inst_id_ varchar 64  √  null
proc_inst_id_ varchar 64  √  null
execution_id_ varchar 64  √  null
case_def_key_ varchar 255  √  null
case_def_id_ varchar 64  √  null
case_inst_id_ varchar 64  √  null
case_execution_id_ varchar 64  √  null
task_id_ varchar 64  √  null
act_inst_id_ varchar 64  √  null
var_inst_id_ varchar 64  √  null
name_ varchar 255
var_type_ varchar 64  √  null
rev_ int4 10  √  null
time_ timestamp 29,6
bytearray_id_ varchar 64  √  null
double_ float8 17,17  √  null
long_ int8 19  √  null
text_ varchar 4000  √  null
text2_ varchar 4000  √  null
sequence_counter_ int8 19  √  null
tenant_id_ varchar 64  √  null
operation_id_ varchar 64  √  null
removal_time_ timestamp 29,6  √  null
initial_ bool 1  √  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_detail_pkey
act_inst_id_ Performance Asc act_idx_hi_detail_act_inst
bytearray_id_ Performance Asc act_idx_hi_detail_bytear
case_execution_id_ Performance Asc act_idx_hi_detail_case_exec
case_inst_id_ Performance Asc act_idx_hi_detail_case_inst
name_ Performance Asc act_idx_hi_detail_name
proc_def_key_ Performance Asc act_idx_hi_detail_proc_def_key
proc_inst_id_ Performance Asc act_idx_hi_detail_proc_inst
removal_time_ Performance Asc act_idx_hi_detail_rm_time
root_proc_inst_id_ Performance Asc act_idx_hi_detail_root_pi
bytearray_id_ + task_id_ Performance Asc/Asc act_idx_hi_detail_task_bytear
task_id_ Performance Asc act_idx_hi_detail_task_id
tenant_id_ Performance Asc act_idx_hi_detail_tenant_id
time_ Performance Asc act_idx_hi_detail_time
var_inst_id_ Performance Asc act_idx_hi_detail_var_inst_id