Constraints

6 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_uaa_pw_user
cor_uaa_user_password.c_username
cor_uaa_user.c_username
Restrict delete
fk_uaa_role_grant
cor_uaa_role_role.c_role_id
cor_uaa_role.c_pk
Restrict delete
fk_uaa_grant_role
cor_uaa_role_role.c_grant_id
cor_uaa_role.c_pk
Restrict delete
fk_uaa_user_email
cor_uaa_email.c_user_pk
cor_uaa_user.c_pk
Restrict delete
fk_uaa_user_role
cor_uaa_role_user.c_user_id
cor_uaa_user.c_pk
Restrict delete
fk_uaa_role_user
cor_uaa_role_user.c_role_id
cor_uaa_role.c_pk
Restrict delete

Check Constraints

Table Constraint Name Constraint
cor_uaa_user cor_uaa_user_c_gender_check ((c_gender)::text = ANY ((ARRAY['MALE'::character varying, 'FEMALE'::character varying, 'GENDERLESS'::character varying])::text[]))