person_role

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
person_role_capability.person_role_oid fkcapability_authorization_capability_oidC
person_role_checkout_center.person_role_oid fkcapability_checkout_center_capability_oidC
person_oid int8 19 null
person.obj_oid fkcapability_person_oidC
organization_oid int8 19 null
organization.obj_oid fkcapability_organization_oidC
system_role_oid int8 19 null
system_role.obj_oid fkcapability_role_oidC

Indexes

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

Relationships

Close relationships within degrees of separation