Constraints

33 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
shared_query_id_owned_by_fkey
shared_query.id_owned_by
user.uuid
Restrict delete
shared_query_id_database_fkey
shared_query.id_database
database_info.uuid
Cascade on delete
user_security_filter_user_uuid_fkey
user_security_filter.user_uuid
user.uuid
Cascade on delete
periodic_statement_status_id_managed_table_fkey
periodic_statement_status.id_managed_table
managed_table.uuid
Cascade on delete
filemon_configid_fkey
filemon.configid
filemon_config.id
Cascade on delete
user_session_id_owned_by_fkey
user_session.id_owned_by
user.uuid
Restrict delete
user_session_user_id_fkey
user_session.user_id
user.uuid
Restrict delete
managed_table_id_owned_by_fkey
managed_table.id_owned_by
user.uuid
Restrict delete
managed_table_id_schema_fkey
managed_table.id_schema
schema_info.uuid
Cascade on delete
managed_table_extconn_uuid_fkey
managed_table.extconn_uuid
connection.uuid
Cascade on delete
saved_query_id_schema_fkey
saved_query.id_schema
schema_info.uuid
Cascade on delete
saved_query_id_owned_by_fkey
saved_query.id_owned_by
user.uuid
Restrict delete
user_id_owned_by_fkey
user.id_owned_by
user.uuid
Restrict delete
user_roles_id_role_fkey
user_roles.id_role
role.uuid
Restrict delete
user_roles_id_user_fkey
user_roles.id_user
user.uuid
Cascade on delete
connection_id_owned_by_fkey
connection.id_owned_by
user.uuid
Restrict delete
connection_id_database_fkey
connection.id_database
database_info.uuid
Cascade on delete
role_id_database_fkey
role.id_database
database_info.uuid
Cascade on delete
role_id_owned_by_fkey
role.id_owned_by
user.uuid
Restrict delete
managed_table_column_id_managed_table_fkey
managed_table_column.id_managed_table
managed_table.uuid
Cascade on delete
dashboard_id_owned_by_fkey
dashboard.id_owned_by
user.uuid
Restrict delete
dashboard_id_database_fkey
dashboard.id_database
database_info.uuid
Cascade on delete
role_permission_role_uuid_fkey
role_permission.role_uuid
role.uuid
Cascade on delete
macro_id_schema_fkey
macro.id_schema
schema_info.uuid
Cascade on delete
macro_id_owned_by_fkey
macro.id_owned_by
user.uuid
Restrict delete
database_info_id_owned_by_fkey
database_info.id_owned_by
user.uuid
Restrict delete
schema_info_id_database_fkey
schema_info.id_database
database_info.uuid
Cascade on delete
schema_info_id_owned_by_fkey
schema_info.id_owned_by
user.uuid
Restrict delete
query_snapshot_data_query_uuid_fkey
query_snapshot_data.query_uuid
query_snapshot.uuid
Cascade on delete
role_security_filter_role_uuid_fkey
role_security_filter.role_uuid
role.uuid
Cascade on delete
widget_dashboard_uuid_fkey
widget.dashboard_uuid
dashboard.uuid
Cascade on delete
widget_tableid_fkey
widget.tableid
managed_table.uuid
Restrict delete
widget_queryid_fkey
widget.queryid
saved_query.uuid
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected