Table webco_4.7.public.person_role 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 int4 10
person_role_capability.person_role_oid fkcapability_authorization_capability_oid
person_role_checkout_center.person_role_oid fkcapability_checkout_center_capability_oid
person_oid int4 10
person.obj_oid fkcapability_person_oid
organization_oid int4 10
organization.obj_oid fkcapability_organization_oid
system_role_oid int4 10
system_role.obj_oid fkcapability_role_oid

Table contained 1 rows at Thu Feb 14 09:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc person_role_pkey
person_oid + organization_oid Must be unique Asc/Asc person_role_person_oid_organization_oid_key

Close relationships  within of separation: