Table testdb.public.act_id_user 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_id_membership.user_id_ act_fk_memb_user R
act_id_tenant_member.user_id_ act_fk_tenant_memb_user R
rev_ int4 10  √  null
first_ varchar 255  √  null
last_ varchar 255  √  null
email_ varchar 255  √  null
pwd_ varchar 255  √  null
salt_ varchar 255  √  null
lock_exp_time_ timestamp 29,6  √  null
attempts_ int4 10  √  null
picture_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_id_user_pkey

Close relationships  within of separation: