-- Verify kakeibo:transactions_type_code_fkey on pg

BEGIN;

DO $$
  BEGIN
    ASSERT (SELECT 1
              FROM information_schema.table_constraints
             WHERE table_schema = 'kakeibo'
               AND table_name = 'transactions'
               AND constraint_type = 'FOREIGN KEY'
               AND constraint_name = 'transactions_type_code_fkey');
  END
$$;

ROLLBACK;
