verify/transactions_type_code_fkey.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

-- 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;