Table webco_5.0.public.system_role_capability Generated by
SchemaSpy
Legend: SourceForge.net
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
obj_oid int8 19
system_role_oid int8 19
system_role.obj_oid system_role_cap_role
system_capability_oid int8 19
system_capability.obj_oid system_role_cap_auth

Table contained 159 rows at Thu Feb 14 09:10 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc system_role_capability_pkey
system_role_oid + system_capability_oid Must be unique Asc/Asc system_role_capability_system_role_oid_system_capability_oi_key

Close relationships  within of separation: