usr_work_ou_map

182 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('permission.usr_work_ou_map_id_seq'::regclass)
usr int4 10 null
usr.id usr_work_ou_map_usr_fkey C
work_ou int4 10 null
org_unit.id usr_work_ou_map_work_ou_fkey C

Indexes

Constraint Name Type Sort Column(s)
usr_work_ou_map_pkey Primary key Asc id
usr_work_ou_once Must be unique Asc/Asc usr + work_ou

Relationships

Close relationships within degrees of separation