Table testdb.public.act_ru_case_execution 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
act_ru_case_execution.case_inst_id_ act_fk_case_exe_case_inst R
act_ru_case_execution.parent_id_ act_fk_case_exe_parent R
act_ru_case_sentry_part.case_exec_id_ act_fk_case_sentry_case_exec R
act_ru_case_sentry_part.case_inst_id_ act_fk_case_sentry_case_inst R
act_ru_task.case_execution_id_ act_fk_task_case_exe R
act_ru_variable.case_execution_id_ act_fk_var_case_exe R
act_ru_variable.case_inst_id_ act_fk_var_case_inst R
rev_ int4 10  √  null
case_inst_id_ varchar 64  √  null
act_ru_case_execution.id_ act_fk_case_exe_case_inst R
super_case_exec_ varchar 64  √  null
super_exec_ varchar 64  √  null
business_key_ varchar 255  √  null
parent_id_ varchar 64  √  null
act_ru_case_execution.id_ act_fk_case_exe_parent R
case_def_id_ varchar 64  √  null
act_re_case_def.id_ act_fk_case_exe_case_def R
act_id_ varchar 255  √  null
prev_state_ int4 10  √  null
current_state_ int4 10  √  null
required_ bool 1  √  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_ru_case_execution_pkey
case_def_id_ Performance Asc act_idx_case_exe_case_def
case_inst_id_ Performance Asc act_idx_case_exe_case_inst
parent_id_ Performance Asc act_idx_case_exe_parent
business_key_ Performance Asc act_idx_case_exec_buskey
tenant_id_ Performance Asc act_idx_case_exec_tenant_id

Close relationships  within of separation: