Constraints

27 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
events_created_by_fkey
events.created_by
users.id
Restrict delete
events_organization_id_fkey
events.organization_id
organizations.id
Restrict delete
user_auth_tokens_user_id_fkey
user_auth_tokens.user_id
users.id
Cascade on delete
projects_local_owner_fkey
projects.local_owner
users.id
Restrict delete
projects_created_by_fkey
projects.created_by
users.id
Restrict delete
projects_organization_id_fkey
projects.organization_id
organizations.id
Restrict delete
projects_updated_by_fkey
projects.updated_by
users.id
Restrict delete
projects_archived_by_fkey
projects.archived_by
users.id
Restrict delete
organization_members_created_by_fkey
organization_members.created_by
users.id
Restrict delete
organization_members_organization_id_fkey
organization_members.organization_id
organizations.id
Restrict delete
organization_members_updated_by_fkey
organization_members.updated_by
users.id
Restrict delete
organization_members_user_id_fkey
organization_members.user_id
users.id
Restrict delete
gallery_project_id_fkey
gallery.project_id
projects.id
Restrict delete
heroku_resources_organization_id_fkey
heroku_resources.organization_id
organizations.id
Restrict delete
project_tokens_created_by_fkey
project_tokens.created_by
users.id
Restrict delete
project_tokens_revoked_by_fkey
project_tokens.revoked_by
users.id
Restrict delete
project_tokens_project_id_fkey
project_tokens.project_id
projects.id
Restrict delete
user_profiles_user_id_fkey
user_profiles.user_id
users.id
Cascade on delete
user_profiles_team_organization_id_fkey
user_profiles.team_organization_id
organizations.id
Cascade on delete
clever_cloud_resources_organization_id_fkey
clever_cloud_resources.organization_id
organizations.id
Restrict delete
organizations_deleted_by_fkey
organizations.deleted_by
users.id
Restrict delete
organizations_created_by_fkey
organizations.created_by
users.id
Restrict delete
organizations_updated_by_fkey
organizations.updated_by
users.id
Restrict delete
organization_invitations_created_by_fkey
organization_invitations.created_by
users.id
Restrict delete
organization_invitations_organization_id_fkey
organization_invitations.organization_id
organizations.id
Restrict delete
organization_invitations_answered_by_fkey
organization_invitations.answered_by
users.id
Restrict delete
user_tokens_user_id_fkey
user_tokens.user_id
users.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint