DELETE FROM privacy_data_inventory
WHERE system_name = 'banking_api'
    AND table_name IN (
        'provider_integrations',
        'provider_outbound_calls',
        'provider_webhook_events',
        'provider_sandbox_test_runs'
    );

DELETE FROM data_archival_policies
WHERE table_name IN (
    'provider_integrations',
    'provider_outbound_calls',
    'provider_webhook_events',
    'provider_sandbox_test_runs'
);

DROP TABLE IF EXISTS provider_sandbox_test_runs;
DROP TABLE IF EXISTS provider_webhook_events;
DROP TABLE IF EXISTS provider_outbound_calls;
DROP TRIGGER IF EXISTS provider_integrations_set_updated_at ON provider_integrations;
DROP TABLE IF EXISTS provider_integrations;