Constraints

asset.id

transaction_id.id

Cascade on delete

transfer_attribute.attribute_type_id

transfer_attribute.transaction_id

transfer.id

Restrict delete

api_response_transaction.response_id

api_response_transaction.transaction_id

api_response.id

transaction_id.id

Cascade on delete

csv_import_metadata.device_id

device.id

Restrict delete

category_audit.audit_type_id

Restrict delete

qif_import_error.qif_import_id

Cascade on delete

api_session.credential_id

api_session.device_id

api_credential.id

device.id

Cascade on delete

person_audit.audit_type_id

Restrict delete

settings.last_qif_account_id

settings.default_currency_id

currency.id

Restrict delete

transfer_attribute_audit.attribute_type_id

transfer_attribute_audit.audit_type_id

Restrict delete

transfer_relationship.relationship_type_id

transfer_relationship.id2

transfer_relationship.id1

relationship_type.id

transfer.id

Restrict delete

person_account_ownership_audit.audit_type_id

Restrict delete

account.category_id

category.id

Restrict delete

account_balance_materialized_view.account_id

account_balance_materialized_view.asset_id

asset.id

Cascade on delete

qif_import_application.strategy_id

qif_import_application.qif_import_id

Null on delete

transfer.target_account_id

transfer.source_account_id

transfer.asset_id

transfer.id

asset.id

transaction_id.id

Cascade on delete

account_mapping.account_id

account_mapping.strategy_id

Cascade on delete

csv_import_application.csv_import_id

csv_import_application.strategy_id

Cascade on delete

running_balance_materialized_view.account_id

running_balance_materialized_view.asset_id

asset.id

Cascade on delete

api_request.session_id

Cascade on delete

exchange_order_audit.audit_type_id

Restrict delete

import_directory_source.device_id

import_directory_source.source_type_id

device.id

Restrict delete

qif_record.import_id

Cascade on delete

api_import_strategy_source.device_id

api_import_strategy_source.source_type_id

device.id

Restrict delete

api_response.request_id

api_response.session_id

api_request.id

Cascade on delete

person_account_ownership.account_id

person_account_ownership.person_id

person.id

Cascade on delete

api_entity_source.api_request_id

api_entity_source.api_session_id

api_entity_source.id

api_request.id

entity_source.id

Restrict delete

currency_audit.audit_type_id

Restrict delete

trade_audit.audit_type_id

Restrict delete

csv_column_metadata.import_id

Cascade on delete

api_import.session_id

Cascade on delete

device.device_make_id

device.device_model_id

device.machine_id

device.os_id

device.platform_id

device_make.id

device_model.id

machine.id

os.id

platform.id

Restrict delete

exchange_order.account_id

Cascade on delete

transfer_audit.audit_type_id

Restrict delete

account_attribute.account_id

account_attribute.attribute_type_id

Cascade on delete

exchange_order_trade.order_id

exchange_order_trade.trade_id

exchange_order.id

trade.id

Cascade on delete

csv_import_error.csv_import_id

Cascade on delete

import_directory_file.directory_id

import_directory.id

Cascade on delete

crypto.id

asset.id

Cascade on delete

csv_import_strategy_audit.audit_type_id

Restrict delete

api_import_strategy_audit.audit_type_id

Restrict delete

csv_import_strategy_source.device_id

csv_import_strategy_source.source_type_id

device.id

Restrict delete

account_merge.surviving_account_id

Cascade on delete

person_attribute_audit.attribute_type_id

person_attribute_audit.audit_type_id

Restrict delete

qif_entity_source.id

qif_entity_source.qif_import_id

entity_source.id

Restrict delete

api_credential.strategy_id

api_import_strategy.id

Null on delete

entity_source.device_id

entity_source.entity_type_id

entity_source.source_type_id

device.id

entity_type.id

Restrict delete

pending_materialized_view_changes.account_id

pending_materialized_view_changes.asset_id

asset.id

Cascade on delete

crypto_audit.audit_type_id

Restrict delete

qif_import_metadata.device_id

device.id

Restrict delete

person_attribute.attribute_type_id

person_attribute.person_id

person.id

Restrict delete

pass_through_account_audit.audit_type_id

Restrict delete

account_merge_transfer.merge_id

account_merge.id

Cascade on delete

xlsx_import_blob.csv_import_id

Cascade on delete

category.parent_id

category.id

Null on delete

csv_entity_source.csv_import_id

csv_entity_source.id

entity_source.id

Restrict delete

account_merge_attribute.merge_id

account_merge.id

Cascade on delete

currency.id

asset.id

Cascade on delete

import_directory_file_qif_import.file_id

import_directory_file_qif_import.qif_import_id

import_directory_file.id

Cascade on delete

xlsx_import_strategy.csv_import_strategy_id

Cascade on delete

api_download_coverage.session_id

Cascade on delete

import_directory.account_id

import_directory.device_id

import_directory.parent_id

import_directory.provider_type_id

device.id

import_directory.id

import_directory_provider.id

Null on delete

account_audit.audit_type_id

Restrict delete

import_directory_audit.audit_type_id

Restrict delete

import_directory_file_csv_import.csv_import_id

import_directory_file_csv_import.file_id

import_directory_file.id

Restrict delete

api_request_header.request_id

api_request.id

Cascade on delete

account_attribute_audit.attribute_type_id

account_attribute_audit.audit_type_id