Table testdb.public.act_ru_identitylink 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
group_id_ varchar 255  √  null
type_ varchar 255  √  null
user_id_ varchar 255  √  null
task_id_ varchar 64  √  null
act_ru_task.id_ act_fk_tskass_task R
proc_def_id_ varchar 64  √  null
act_re_procdef.id_ act_fk_athrz_procedef R
tenant_id_ varchar 64  √  null

Table contained 0 rows at Tue Nov 19 14:56 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_ru_identitylink_pkey
proc_def_id_ Performance Asc act_idx_athrz_procedef
group_id_ Performance Asc act_idx_ident_lnk_group
user_id_ Performance Asc act_idx_ident_lnk_user
task_id_ Performance Asc act_idx_tskass_task

Close relationships  within of separation: