Table testdb.public.act_id_tenant_member 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
tenant_id_ varchar 64
act_id_tenant.id_ act_fk_tenant_memb R
user_id_ varchar 64  √  null
act_id_user.id_ act_fk_tenant_memb_user R
group_id_ varchar 64  √  null
act_id_group.id_ act_fk_tenant_memb_group R

Table contained 0 rows at Tue Apr 16 13:44 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_id_tenant_member_pkey
tenant_id_ Performance Asc act_idx_tenant_memb
group_id_ Performance Asc act_idx_tenant_memb_group
user_id_ Performance Asc act_idx_tenant_memb_user
tenant_id_ + group_id_ Must be unique Asc/Asc act_uniq_tenant_memb_group
tenant_id_ + user_id_ Must be unique Asc/Asc act_uniq_tenant_memb_user

Close relationships  within of separation: