organization_users

0 rows


Description

Organization membership and role information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int8 19 null
users.id organization_users_user_id_fkeyR
organization_id int8 19 null
organizations.id organization_users_organization_id_fkeyC
role_id int4 10 null
roles.id organization_users_role_id_fkeyR
created_time timestamptz 35,6 null
modified_time timestamptz 35,6 null
created_by int8 19 null
users.id organization_users_created_by_fkeyR
modified_by int8 19 null
users.id organization_users_modified_by_fkeyR

Indexes

Constraint Name Type Sort Column(s)
organization_users_pkey Primary key Asc/Asc user_id + organization_id
organization_users_contact_uk Must be unique Asc organization_id
organization_users_organization_id_idx Performance Asc organization_id

Relationships

Close relationships within degrees of separation