graphs/sql/safe_haven/req01.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE banking_transactions_poc
(
    id serial PRIMARY KEY,
    sender varchar(22) NOT NULL,
    receiver varchar(22) NOT NULL,
    amount numeric(16, 2) NOT NULL,
    CHECK (sender SIMILAR TO 'RR[0-9]{2}[A-Z]{4}[0-9]{14}'),
    CHECK (receiver SIMILAR TO 'RR[0-9]{2}[A-Z]{4}[0-9]{14}'),
    CHECK (sender != receiver),
    CHECK (amount > 0)
);