deploy/transactions_type_code_fkey.sql


1
2
3
4
5
6
7
8
9
10
11
12

-- Deploy kakeibo:transactions_type_code_fkey to pg
-- requires: transactions
-- requires: types

BEGIN;

ALTER TABLE kakeibo.transactions
  ADD CONSTRAINT transactions_type_code_fkey
  FOREIGN KEY (type_code)
  REFERENCES kakeibo.types (code);

COMMIT;