DELETE FROM privacy_data_inventory
WHERE system_name = 'banking_api'
    AND table_name IN (
        'savings_pocket_categories',
        'savings_pocket_roundup_rules',
        'savings_pocket_recurring_rules',
        'savings_pocket_members'
    );

DELETE FROM data_archival_policies
WHERE table_name IN (
    'savings_pocket_categories',
    'savings_pocket_roundup_rules',
    'savings_pocket_recurring_rules',
    'savings_pocket_members'
);

DROP TRIGGER IF EXISTS savings_pocket_members_set_updated_at ON savings_pocket_members;
DROP TABLE IF EXISTS savings_pocket_members;

DROP TRIGGER IF EXISTS savings_pocket_recurring_rules_set_updated_at ON savings_pocket_recurring_rules;
DROP TABLE IF EXISTS savings_pocket_recurring_rules;

DROP TRIGGER IF EXISTS savings_pocket_roundup_rules_set_updated_at ON savings_pocket_roundup_rules;
DROP TABLE IF EXISTS savings_pocket_roundup_rules;

DROP INDEX IF EXISTS savings_goals_provider_sync_idx;
DROP INDEX IF EXISTS savings_goals_category_idx;
ALTER TABLE savings_goals
    DROP CONSTRAINT IF EXISTS savings_goals_provider_link_check,
    DROP CONSTRAINT IF EXISTS savings_goals_color_check,
    DROP CONSTRAINT IF EXISTS savings_goals_icon_check,
    DROP COLUMN IF EXISTS provider_synced_at,
    DROP COLUMN IF EXISTS provider_sync_error,
    DROP COLUMN IF EXISTS provider_sync_status,
    DROP COLUMN IF EXISTS external_pocket_id,
    DROP COLUMN IF EXISTS provider_name,
    DROP COLUMN IF EXISTS visibility,
    DROP COLUMN IF EXISTS pocket_type,
    DROP COLUMN IF EXISTS color,
    DROP COLUMN IF EXISTS icon,
    DROP COLUMN IF EXISTS category_id;

DROP TRIGGER IF EXISTS savings_pocket_categories_set_updated_at ON savings_pocket_categories;
DROP TABLE IF EXISTS savings_pocket_categories;