Table testdb.public.act_hi_op_log 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
deployment_id_ varchar 64  √  null
proc_def_id_ varchar 64  √  null
proc_def_key_ varchar 255  √  null
root_proc_inst_id_ varchar 64  √  null
proc_inst_id_ varchar 64  √  null
execution_id_ varchar 64  √  null
case_def_id_ varchar 64  √  null
case_inst_id_ varchar 64  √  null
case_execution_id_ varchar 64  √  null
task_id_ varchar 64  √  null
job_id_ varchar 64  √  null
job_def_id_ varchar 64  √  null
batch_id_ varchar 64  √  null
user_id_ varchar 255  √  null
timestamp_ timestamp 29,6
operation_type_ varchar 64  √  null
operation_id_ varchar 64  √  null
entity_type_ varchar 30  √  null
property_ varchar 64  √  null
org_value_ varchar 4000  √  null
new_value_ varchar 4000  √  null
tenant_id_ varchar 64  √  null
removal_time_ timestamp 29,6  √  null
category_ varchar 64  √  null
external_task_id_ varchar 64  √  null
annotation_ varchar 4000  √  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_op_log_pkey
entity_type_ Performance Asc act_idx_hi_op_log_entity_type
operation_type_ Performance Asc act_idx_hi_op_log_op_type
proc_def_id_ Performance Asc act_idx_hi_op_log_procdef
proc_inst_id_ Performance Asc act_idx_hi_op_log_procinst
removal_time_ Performance Asc act_idx_hi_op_log_rm_time
root_proc_inst_id_ Performance Asc act_idx_hi_op_log_root_pi
task_id_ Performance Asc act_idx_hi_op_log_task
timestamp_ Performance Asc act_idx_hi_op_log_timestamp
user_id_ Performance Asc act_idx_hi_op_log_user_id