Table testdb.public.cor_uaa_role 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
c_type varchar 20
c_pk int8 19
cor_uaa_role_role.c_grant_id fk_uaa_grant_role R
cor_uaa_role_role.c_role_id fk_uaa_role_grant R
cor_uaa_role_user.c_role_id fk_uaa_role_user R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_description varchar 1024  √  null
c_name varchar 255
c_immutable bool 1  √  null

Table contained 0 rows at Sat Sep 28 21:17 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc cor_uaa_role_pkey
c_name Must be unique Asc uc_uaa_role
c_pid Must be unique Asc uk_p15j9hfo67f9rpemrxaixc1c5

Close relationships  within of separation: