role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.role_id_seq'::regclass)
admap.role_id fk_ad_role C
user_role.role_id fk_ur_role C
name text 2147483647 null
organization_id int4 10 √ null
organization.id fk_role_org C

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pk_role_id Primary key Asc id
uk_role_name Must be unique Asc/Asc organization_id + name

Relationships

Close relationships within degrees of separation