Constraints

20 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
banned_users_per_streamer_banned_by_fkey
banned_users_per_streamer.banned_by
users.user_id
Restrict delete
banned_users_per_streamer_streamer_id_fkey
banned_users_per_streamer.streamer_id
users.user_id
Restrict delete
banned_users_per_streamer_user_id_fkey
banned_users_per_streamer.user_id
users.user_id
Restrict delete
subscribers_streamer_id_fkey
subscribers.streamer_id
users.user_id
Restrict delete
subscribers_user_id_fkey
subscribers.user_id
users.user_id
Restrict delete
user_roles_streamer_id_fkey
user_roles.streamer_id
users.user_id
Null on delete
user_roles_role_id_fkey
user_roles.role_id
roles.role_id
Restrict delete
user_roles_user_id_fkey
user_roles.user_id
users.user_id
Restrict delete
chat_message_edit_histories_message_id_fkey
chat_message_edit_histories.message_id
chat_messages.message_id
Restrict delete
role_permissions_permission_id_fkey
role_permissions.permission_id
permissions.permission_id
Restrict delete
role_permissions_role_id_fkey
role_permissions.role_id
roles.role_id
Restrict delete
streams_streamer_id_fkey
streams.streamer_id
users.user_id
Restrict delete
stream_statistics_in_time_stream_id_fkey
stream_statistics_in_time.stream_id
streams.stream_id
Restrict delete
stream_statistics_in_time_stream_statistic_type_id_fkey
stream_statistics_in_time.stream_statistic_type_id
stream_statistics_types.stream_statistic_type_id
Restrict delete
chat_messages_user_id_fkey
chat_messages.user_id
users.user_id
Restrict delete
chat_messages_stream_id_fkey
chat_messages.stream_id
streams.stream_id
Restrict delete
sessions_user_id_fkey
sessions.user_id
users.user_id
Restrict delete
refresh_tokens_replaced_by_id_fkey
refresh_tokens.replaced_by_id
refresh_tokens.token_id
Null on delete
refresh_tokens_session_id_fkey
refresh_tokens.session_id
sessions.session_id
Restrict delete
refresh_tokens_user_id_fkey
refresh_tokens.user_id
users.user_id
Restrict delete

Check Constraints

Table Constraint Name Constraint