Table testdb.public.act_ru_task 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_identitylink.task_id_ act_fk_tskass_task R
rev_ int4 10  √  null
execution_id_ varchar 64  √  null
act_ru_execution.id_ act_fk_task_exe R
proc_inst_id_ varchar 64  √  null
act_ru_execution.id_ act_fk_task_procinst R
proc_def_id_ varchar 64  √  null
act_re_procdef.id_ act_fk_task_procdef R
case_execution_id_ varchar 64  √  null
act_ru_case_execution.id_ act_fk_task_case_exe R
case_inst_id_ varchar 64  √  null
case_def_id_ varchar 64  √  null
act_re_case_def.id_ act_fk_task_case_def R
name_ varchar 255  √  null
parent_task_id_ varchar 64  √  null
description_ varchar 4000  √  null
task_def_key_ varchar 255  √  null
owner_ varchar 255  √  null
assignee_ varchar 255  √  null
delegation_ varchar 64  √  null
priority_ int4 10  √  null
create_time_ timestamp 29,6  √  null
last_updated_ timestamp 29,6  √  null
due_date_ timestamp 29,6  √  null
follow_up_date_ timestamp 29,6  √  null
suspension_state_ int4 10  √  null
tenant_id_ varchar 64  √  null
task_state_ varchar 64  √  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_ru_task_pkey
assignee_ Performance Asc act_idx_task_assignee
case_def_id_ Performance Asc act_idx_task_case_def_id
case_execution_id_ Performance Asc act_idx_task_case_exec
create_time_ Performance Asc act_idx_task_create
execution_id_ Performance Asc act_idx_task_exec
last_updated_ Performance Asc act_idx_task_last_updated
owner_ Performance Asc act_idx_task_owner
proc_def_id_ Performance Asc act_idx_task_procdef
proc_inst_id_ Performance Asc act_idx_task_procinst
tenant_id_ Performance Asc act_idx_task_tenant_id

Close relationships  within of separation: