diff options
Diffstat (limited to 'verify/transactions_type_code_fkey.sql')
-rw-r--r-- | verify/transactions_type_code_fkey.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/verify/transactions_type_code_fkey.sql b/verify/transactions_type_code_fkey.sql new file mode 100644 index 0000000..bb2841c --- /dev/null +++ b/verify/transactions_type_code_fkey.sql @@ -0,0 +1,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; |