Table testdb.public.act_ru_authorization 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
type_ int4 10
group_id_ varchar 255  √  null
user_id_ varchar 255  √  null
resource_type_ int4 10
resource_id_ varchar 255  √  null
perms_ int4 10  √  null
removal_time_ timestamp 29,6  √  null
root_proc_inst_id_ varchar 64  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_ru_authorization_pkey
group_id_ Performance Asc act_idx_auth_group_id
resource_id_ Performance Asc act_idx_auth_resource_id
removal_time_ Performance Asc act_idx_auth_rm_time
root_proc_inst_id_ Performance Asc act_idx_auth_root_pi
type_ + group_id_ + resource_type_ + resource_id_ Must be unique Asc/Asc/Asc/Asc act_uniq_auth_group
type_ + user_id_ + resource_type_ + resource_id_ Must be unique Asc/Asc/Asc/Asc act_uniq_auth_user