Table testdb.public.act_re_procdef 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_execution.proc_def_id_ act_fk_exe_procdef R
act_ru_identitylink.proc_def_id_ act_fk_athrz_procedef R
act_ru_incident.proc_def_id_ act_fk_inc_procdef R
act_ru_task.proc_def_id_ act_fk_task_procdef R
rev_ int4 10  √  null
category_ varchar 255  √  null
name_ varchar 255  √  null
key_ varchar 255
version_ int4 10
deployment_id_ varchar 64  √  null
resource_name_ varchar 4000  √  null
dgrm_resource_name_ varchar 4000  √  null
has_start_form_key_ bool 1  √  null
suspension_state_ int4 10  √  null
tenant_id_ varchar 64  √  null
version_tag_ varchar 64  √  null
history_ttl_ int4 10  √  null
startable_ bool 1 true

Table contained 1 rows at Mon Dec 23 18:09 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_re_procdef_pkey
deployment_id_ Performance Asc act_idx_procdef_deployment_id
tenant_id_ Performance Asc act_idx_procdef_tenant_id
version_tag_ Performance Asc act_idx_procdef_ver_tag

Close relationships  within of separation: