Table testdb.public.act_ru_variable 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
rev_ int4 10  √  null
type_ varchar 255
name_ varchar 255
execution_id_ varchar 64  √  null
act_ru_execution.id_ act_fk_var_exe R
proc_inst_id_ varchar 64  √  null
act_ru_execution.id_ act_fk_var_procinst R
proc_def_id_ varchar 64  √  null
case_execution_id_ varchar 64  √  null
act_ru_case_execution.id_ act_fk_var_case_exe R
case_inst_id_ varchar 64  √  null
act_ru_case_execution.id_ act_fk_var_case_inst R
task_id_ varchar 64  √  null
batch_id_ varchar 64  √  null
act_ru_batch.id_ act_fk_var_batch R
bytearray_id_ varchar 64  √  null
act_ge_bytearray.id_ act_fk_var_bytearray R
double_ float8 17,17  √  null
long_ int8 19  √  null
text_ varchar 4000  √  null
text2_ varchar 4000  √  null
var_scope_ varchar 64  √  null
sequence_counter_ int8 19  √  null
is_concurrent_local_ 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_variable_pkey
batch_id_ Performance Asc act_idx_batch_id
bytearray_id_ Performance Asc act_idx_var_bytearray
case_execution_id_ Performance Asc act_idx_var_case_exe
case_inst_id_ Performance Asc act_idx_var_case_inst_id
execution_id_ Performance Asc act_idx_var_exe
proc_inst_id_ Performance Asc act_idx_var_procinst
task_id_ Performance Asc act_idx_variable_task_id
task_id_ + name_ + type_ Performance Asc/Asc/Asc act_idx_variable_task_name_type
tenant_id_ Performance Asc act_idx_variable_tenant_id
var_scope_ + name_ Must be unique Asc/Asc act_uniq_variable

Close relationships  within of separation: