organizations_ext_organizationuser


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('organizations_ext_organizationuser_id_seq'::regclass)
organizations_ext_organizationowner.organization_user_id organizations_ext_or_organization_user_id_d9d30739_fk_organizat R
teams_team_members.organizationuser_id teams_team_members_n_organizationuser_id_96fbcfb6_fk_organizat R
created timestamptz 35,6 null
modified timestamptz 35,6 null
role int2 5 null
organization_id int4 10 null
organizations_ext_organization.id organizations_ext_or_organization_id_f5a7ee4a_fk_organizat R
user_id int4 10 √ null
users_user.id organizations_ext_or_user_id_d255140d_fk_users_use R
email varchar 254 √ null

Indexes

Constraint Name Type Sort Column(s)
organizations_ext_organizationuser_pkey Primary key Asc id
organizations_ext_organi_email_organization_id_22b69941_uniq Must be unique Asc/Asc email + organization_id
organizations_ext_organi_user_id_organization_id_60b380fc_uniq Must be unique Asc/Asc user_id + organization_id
organizations_ext_organizationuser_organization_id_f5a7ee4a Performance Asc organization_id
organizations_ext_organizationuser_user_id_d255140d Performance Asc user_id

Check Constraints

Constraint Name Constraint
organizations_ext_organizationuser_role_check ((role >= 0))

Relationships

Close relationships within degrees of separation