summaryrefslogtreecommitdiff
path: root/graphs/sql/safe_haven/req01.sql
diff options
context:
space:
mode:
Diffstat (limited to 'graphs/sql/safe_haven/req01.sql')
-rw-r--r--graphs/sql/safe_haven/req01.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/graphs/sql/safe_haven/req01.sql b/graphs/sql/safe_haven/req01.sql
new file mode 100644
index 0000000..4c0d403
--- /dev/null
+++ b/graphs/sql/safe_haven/req01.sql
@@ -0,0 +1,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)
+);