docs: improve documentation

author: Joel-Haeberli <haebu@rubigen.ch> 2024-03-24 21:53:55 +0100
committer: Joel-Haeberli <haebu@rubigen.ch> 2024-03-24 21:53:55 +0100
commit: 8d788b2b6a319deef49f267b8966bfe226bcbc20 (patch)
tree: 936ea8866cc51a52c0e45f29594c726f8f0bfea0 /schemaspy
parent: 0c79ae99713e6d4d6d31bd621a949617ebfe503a (diff)
download: cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.tar.gz
cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.tar.bz2
cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.zip
179 files changed, 591 insertions, 296 deletions
diff --git a/schemaspy/nonce2ecash-erd/anomalies.html b/schemaspy/c2ec-erd/anomalies.html
index 03cbe02..2a13ebd 100644
--- a/schemaspy/nonce2ecash-erd/anomalies.html
+++ b/schemaspy/c2ec-erd/anomalies.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
diff --git a/schemaspy/nonce2ecash-erd/anomalies.js b/schemaspy/c2ec-erd/anomalies.js
index e69de29..e69de29 100644
--- a/schemaspy/nonce2ecash-erd/anomalies.js
+++ b/schemaspy/c2ec-erd/anomalies.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css
index 31d8882..31d8882 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css.map b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css.map
index d876f60..d876f60 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css.map
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.css.map
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css
index 5e39401..5e39401 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css.map b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css.map
index 94813e9..94813e9 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css.map
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap-theme.min.css.map
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.css b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.css
index 6167622..6167622 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.css.map b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.css.map
index f010c82..f010c82 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.css.map
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.css.map
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css
index ed3905e..ed3905e 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css.map b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css.map
index 6c7fa40..6c7fa40 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css.map
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/css/bootstrap.min.css.map
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.eot b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.eot
index b93a495..b93a495 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.eot
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.eot
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.svg b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.svg
index 94fb549..94fb549 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.svg
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.svg
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.ttf b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.ttf
index 1413fc6..1413fc6 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.ttf
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.ttf
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff
index 9e61285..9e61285 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff2 b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff2
index 64539b5..64539b5 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff2
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/fonts/glyphicons-halflings-regular.woff2
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/bootstrap.js b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/bootstrap.js
index 8a2e99a..8a2e99a 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/bootstrap.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/bootstrap.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/bootstrap.min.js b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/bootstrap.min.js
index 9bcd2fc..9bcd2fc 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/bootstrap.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/bootstrap.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/npm.js b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/npm.js
index bf6aa80..bf6aa80 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/bootstrap/js/npm.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/bootstrap/js/npm.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/AdminLTE.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/AdminLTE.css
index 77b8760..77b8760 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/AdminLTE.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/AdminLTE.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/AdminLTE.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/AdminLTE.min.css
index 193bd5d..193bd5d 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/AdminLTE.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/AdminLTE.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.css
index 02513c7..02513c7 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.min.css
index 59cf7f2..59cf7f2 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-bootstrap-social.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.css
index 54426af..54426af 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.min.css
index 4751478..4751478 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-fullcalendar.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.css
index 4636a2c..4636a2c 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.min.css
index e09368f..e09368f 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-select2.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.css
index bdbdcd0..bdbdcd0 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.min.css
index 1614073..1614073 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/alt/AdminLTE-without-plugins.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black-light.css
index c6a2501..c6a2501 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black-light.min.css
index 5f5894c..5f5894c 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black.css
index 977b02e..977b02e 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black.min.css
index 42a2224..42a2224 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-black.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-black.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue-light.css
index 7e63a6f..7e63a6f 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue-light.min.css
index c41ca33..c41ca33 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue.css
index 603b65f..603b65f 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue.min.css
index 44524fe..44524fe 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-blue.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-blue.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green-light.css
index b230659..b230659 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green-light.min.css
index 7d26a13..7d26a13 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green.css
index ff750cc..ff750cc 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green.min.css
index c331d6d..c331d6d 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-green.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-green.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple-light.css
index cfcb148..cfcb148 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple-light.min.css
index d8389dd..d8389dd 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple.css
index cb21dd7..cb21dd7 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple.min.css
index 8989118..8989118 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-purple.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-purple.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red-light.css
index 146bd3b..146bd3b 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red-light.min.css
index 106940c..106940c 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red.css
index 6a94895..6a94895 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red.min.css
index ecfb406..ecfb406 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-red.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-red.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.css
index 1d8a6fe..1d8a6fe 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.min.css
index 6136284..6136284 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow-light.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow.css
index 7834ba1..7834ba1 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow.min.css b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow.min.css
index b251e24..b251e24 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/css/skins/skin-yellow.min.css
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/css/skins/skin-yellow.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/app.js b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/app.js
index 8759426..8759426 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/app.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/app.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/app.min.js b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/app.min.js
index 4851def..4851def 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/app.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/app.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/demo.js b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/demo.js
index b18b9bb..b18b9bb 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/demo.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/demo.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/pages/dashboard.js b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/pages/dashboard.js
index 0f7c007..0f7c007 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/pages/dashboard.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/pages/dashboard.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/pages/dashboard2.js b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/pages/dashboard2.js
index cc67785..cc67785 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/dist/js/pages/dashboard2.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/dist/js/pages/dashboard2.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/fastclick/fastclick.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/fastclick/fastclick.js
index 3af4f9d..3af4f9d 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/fastclick/fastclick.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/fastclick/fastclick.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/fastclick/fastclick.min.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/fastclick/fastclick.min.js
index 131e29e..131e29e 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/fastclick/fastclick.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/fastclick/fastclick.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js
index b8c4187..b8c4187 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.js
index 31ee9cd..31ee9cd 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js
index 5824d12..5824d12 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.js
index 90caed3..90caed3 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.js
diff --git a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js b/schemaspy/c2ec-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js
index 7531ab3..7531ab3 100644
--- a/schemaspy/nonce2ecash-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js
+++ b/schemaspy/c2ec-erd/bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/anchor-js/anchor.min.js b/schemaspy/c2ec-erd/bower/anchor-js/anchor.min.js
index 35575f1..35575f1 100644
--- a/schemaspy/nonce2ecash-erd/bower/anchor-js/anchor.min.js
+++ b/schemaspy/c2ec-erd/bower/anchor-js/anchor.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/codemirror/codemirror.css b/schemaspy/c2ec-erd/bower/codemirror/codemirror.css
index b008351..b008351 100644
--- a/schemaspy/nonce2ecash-erd/bower/codemirror/codemirror.css
+++ b/schemaspy/c2ec-erd/bower/codemirror/codemirror.css
diff --git a/schemaspy/nonce2ecash-erd/bower/codemirror/codemirror.js b/schemaspy/c2ec-erd/bower/codemirror/codemirror.js
index b1bdaba..b1bdaba 100644
--- a/schemaspy/nonce2ecash-erd/bower/codemirror/codemirror.js
+++ b/schemaspy/c2ec-erd/bower/codemirror/codemirror.js
diff --git a/schemaspy/nonce2ecash-erd/bower/codemirror/sql.js b/schemaspy/c2ec-erd/bower/codemirror/sql.js
index 7a7c796..7a7c796 100644
--- a/schemaspy/nonce2ecash-erd/bower/codemirror/sql.js
+++ b/schemaspy/c2ec-erd/bower/codemirror/sql.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/css/dataTables.bootstrap.css b/schemaspy/c2ec-erd/bower/datatables.net-bs/css/dataTables.bootstrap.css
index 2bbb3ef..2bbb3ef 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/css/dataTables.bootstrap.css
+++ b/schemaspy/c2ec-erd/bower/datatables.net-bs/css/dataTables.bootstrap.css
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/css/dataTables.bootstrap.min.css b/schemaspy/c2ec-erd/bower/datatables.net-bs/css/dataTables.bootstrap.min.css
index 66a70ab..66a70ab 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/css/dataTables.bootstrap.min.css
+++ b/schemaspy/c2ec-erd/bower/datatables.net-bs/css/dataTables.bootstrap.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/js/dataTables.bootstrap.js b/schemaspy/c2ec-erd/bower/datatables.net-bs/js/dataTables.bootstrap.js
index f69acdc..f69acdc 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/js/dataTables.bootstrap.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-bs/js/dataTables.bootstrap.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/js/dataTables.bootstrap.min.js b/schemaspy/c2ec-erd/bower/datatables.net-bs/js/dataTables.bootstrap.min.js
index 98661c6..98661c6 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-bs/js/dataTables.bootstrap.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-bs/js/dataTables.bootstrap.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.css b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.css
index 3d14edb..3d14edb 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.css
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.css
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css
index 1ff4119..1ff4119 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.js
index 0dc7b5b..0dc7b5b 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js
index dc28bac..dc28bac 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.colVis.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.colVis.js
index 04f3ece..04f3ece 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.colVis.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.colVis.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.colVis.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.colVis.min.js
index 1e59b8b..1e59b8b 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.colVis.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.colVis.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.flash.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.flash.js
index 3cb100c..3cb100c 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.flash.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.flash.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.flash.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.flash.min.js
index 9ba7fe4..9ba7fe4 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.flash.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.flash.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.html5.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.html5.js
index f27aadf..f27aadf 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.html5.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.html5.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.html5.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.html5.min.js
index 9cd4cee..9cd4cee 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.html5.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.html5.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.print.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.print.js
index 2352e5a..2352e5a 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.print.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.print.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.print.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.print.min.js
index 9f56d44..9f56d44 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/buttons.print.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/buttons.print.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/dataTables.buttons.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/dataTables.buttons.js
index 02ceacb..02ceacb 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/dataTables.buttons.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/dataTables.buttons.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/dataTables.buttons.min.js b/schemaspy/c2ec-erd/bower/datatables.net-buttons/dataTables.buttons.min.js
index b7a807e..b7a807e 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net-buttons/dataTables.buttons.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net-buttons/dataTables.buttons.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/datatables.net/jquery.dataTables.min.js b/schemaspy/c2ec-erd/bower/datatables.net/jquery.dataTables.min.js
index dc969ee..dc969ee 100644
--- a/schemaspy/nonce2ecash-erd/bower/datatables.net/jquery.dataTables.min.js
+++ b/schemaspy/c2ec-erd/bower/datatables.net/jquery.dataTables.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.css b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.css
index ee906a8..ee906a8 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.css
+++ b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.css
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.css.map b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.css.map
index 60763a8..60763a8 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.css.map
+++ b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.css.map
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.min.css b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.min.css
index 540440c..540440c 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/css/font-awesome.min.css
+++ b/schemaspy/c2ec-erd/bower/font-awesome/css/font-awesome.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/FontAwesome.otf b/schemaspy/c2ec-erd/bower/font-awesome/fonts/FontAwesome.otf
index 401ec0f..401ec0f 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/FontAwesome.otf
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/FontAwesome.otf
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.eot b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.eot
index e9f60ca..e9f60ca 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.eot
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.eot
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.svg b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.svg
index 855c845..855c845 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.svg
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.svg
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.ttf b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.ttf
index 35acda2..35acda2 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.ttf
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.ttf
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.woff b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.woff
index 400014a..400014a 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.woff
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.woff
diff --git a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.woff2 b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.woff2
index 4d13fc6..4d13fc6 100644
--- a/schemaspy/nonce2ecash-erd/bower/font-awesome/fonts/fontawesome-webfont.woff2
+++ b/schemaspy/c2ec-erd/bower/font-awesome/fonts/fontawesome-webfont.woff2
diff --git a/schemaspy/nonce2ecash-erd/bower/html5shiv/html5shiv.min.js b/schemaspy/c2ec-erd/bower/html5shiv/html5shiv.min.js
index 355afd1..355afd1 100644
--- a/schemaspy/nonce2ecash-erd/bower/html5shiv/html5shiv.min.js
+++ b/schemaspy/c2ec-erd/bower/html5shiv/html5shiv.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/css/ionicons.css b/schemaspy/c2ec-erd/bower/ionicons/css/ionicons.css
index 885aa6b..885aa6b 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/css/ionicons.css
+++ b/schemaspy/c2ec-erd/bower/ionicons/css/ionicons.css
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/css/ionicons.min.css b/schemaspy/c2ec-erd/bower/ionicons/css/ionicons.min.css
index baba9e9..baba9e9 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/css/ionicons.min.css
+++ b/schemaspy/c2ec-erd/bower/ionicons/css/ionicons.min.css
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.eot b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.eot
index 92a3f20..92a3f20 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.eot
+++ b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.eot
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.svg b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.svg
index 49fc8f3..49fc8f3 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.svg
+++ b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.svg
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.ttf b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.ttf
index c4e4632..c4e4632 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.ttf
+++ b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.ttf
diff --git a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.woff b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.woff
index 5f3a14e..5f3a14e 100644
--- a/schemaspy/nonce2ecash-erd/bower/ionicons/fonts/ionicons.woff
+++ b/schemaspy/c2ec-erd/bower/ionicons/fonts/ionicons.woff
diff --git a/schemaspy/nonce2ecash-erd/bower/jquery/jquery.js b/schemaspy/c2ec-erd/bower/jquery/jquery.js
index d2d8ca4..d2d8ca4 100644
--- a/schemaspy/nonce2ecash-erd/bower/jquery/jquery.js
+++ b/schemaspy/c2ec-erd/bower/jquery/jquery.js
diff --git a/schemaspy/nonce2ecash-erd/bower/js-xlsx/xlsx.full.min.js b/schemaspy/c2ec-erd/bower/js-xlsx/xlsx.full.min.js
index 93667e9..93667e9 100644
--- a/schemaspy/nonce2ecash-erd/bower/js-xlsx/xlsx.full.min.js
+++ b/schemaspy/c2ec-erd/bower/js-xlsx/xlsx.full.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/pdfmake/pdfmake.min.js b/schemaspy/c2ec-erd/bower/pdfmake/pdfmake.min.js
index 352962b..352962b 100644
--- a/schemaspy/nonce2ecash-erd/bower/pdfmake/pdfmake.min.js
+++ b/schemaspy/c2ec-erd/bower/pdfmake/pdfmake.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/pdfmake/vfs_fonts.js b/schemaspy/c2ec-erd/bower/pdfmake/vfs_fonts.js
index 9634f7d..9634f7d 100644
--- a/schemaspy/nonce2ecash-erd/bower/pdfmake/vfs_fonts.js
+++ b/schemaspy/c2ec-erd/bower/pdfmake/vfs_fonts.js
diff --git a/schemaspy/nonce2ecash-erd/bower/respond/respond.min.js b/schemaspy/c2ec-erd/bower/respond/respond.min.js
index 80a7b69..80a7b69 100644
--- a/schemaspy/nonce2ecash-erd/bower/respond/respond.min.js
+++ b/schemaspy/c2ec-erd/bower/respond/respond.min.js
diff --git a/schemaspy/nonce2ecash-erd/bower/salvattore/salvattore.css b/schemaspy/c2ec-erd/bower/salvattore/salvattore.css
index f037b65..f037b65 100644
--- a/schemaspy/nonce2ecash-erd/bower/salvattore/salvattore.css
+++ b/schemaspy/c2ec-erd/bower/salvattore/salvattore.css
diff --git a/schemaspy/nonce2ecash-erd/bower/salvattore/salvattore.min.js b/schemaspy/c2ec-erd/bower/salvattore/salvattore.min.js
index 32f5cf6..32f5cf6 100644
--- a/schemaspy/nonce2ecash-erd/bower/salvattore/salvattore.min.js
+++ b/schemaspy/c2ec-erd/bower/salvattore/salvattore.min.js
diff --git a/schemaspy/nonce2ecash-erd/column.js b/schemaspy/c2ec-erd/column.js
index 58343de..58343de 100644
--- a/schemaspy/nonce2ecash-erd/column.js
+++ b/schemaspy/c2ec-erd/column.js
diff --git a/schemaspy/nonce2ecash-erd/columns.html b/schemaspy/c2ec-erd/columns.html
index 557e6d3..7f23e1e 100644
--- a/schemaspy/nonce2ecash-erd/columns.html
+++ b/schemaspy/c2ec-erd/columns.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -111,46 +111,88 @@
                 <script>
                     var tableData = [
     {
+        "tableName": "terminal",
+        "tableFileName": "terminal",
+        "tableType": "Table",
+        "keyClass": "foreignKey",
+        "keyTitle": "Foreign Key",
+        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>provider_id",
+        "type": "int8",
+        "length": 19,
+        "nullable": "",
+        "autoUpdated": "",
+        "defaultValue": "null",
+        "comments": "<p>Indicates the terminal provider to which the terminal belongs<\/p>"
+    },
+    {
         "tableName": "terminal_provider",
         "tableFileName": "terminal_provider",
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "name",
-        "type": "varchar",
-        "length": 50,
+        "name": "backend_base_url",
+        "type": "text",
+        "length": 2147483647,
+        "nullable": "",
+        "autoUpdated": "",
+        "defaultValue": "null",
+        "comments": "<p>URL of the provider backend for transaction proofing<\/p>"
+    },
+    {
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
+        "tableType": "Table",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "provider_transaction_id",
+        "type": "text",
+        "length": 2147483647,
         "nullable": "√",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Transaction identifier supplied by the provider for backend request<\/p>"
     },
     {
-        "tableName": "terminal",
-        "tableFileName": "terminal",
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
         "tableType": "Table",
-        "keyClass": "primaryKey",
-        "keyTitle": "Primary Key",
-        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id",
-        "type": "int8",
-        "length": 19,
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "reserve_pub_key",
+        "type": "bytea",
+        "length": 2147483647,
         "nullable": "",
-        "autoUpdated": "√",
+        "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Reserve public key for the reserve which will hold the withdrawal amount after completion<\/p>"
     },
     {
-        "tableName": "terminal_provider",
-        "tableFileName": "terminal_provider",
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
         "tableType": "Table",
-        "keyClass": "primaryKey",
-        "keyTitle": "Primary Key",
-        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "withdrawal_status",
+        "type": "\"c2ec\".\"withdrawal_operation_status\"",
+        "length": 2147483647,
+        "nullable": "",
+        "autoUpdated": "",
+        "defaultValue": "'pending'::c2ec.withdrawal_operation_status",
+        "comments": "<p>Status of the withdrawal process<\/p>"
+    },
+    {
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
+        "tableType": "Table",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "registration_ts",
         "type": "int8",
         "length": 19,
         "nullable": "",
-        "autoUpdated": "√",
+        "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Timestamp of when the withdrawal request was registered<\/p>"
     },
     {
         "tableName": "withdrawal",
@@ -164,49 +206,35 @@
         "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
-    },
-    {
-        "tableName": "terminal",
-        "tableFileName": "terminal",
-        "tableType": "Table",
-        "keyClass": "",
-        "keyTitle": "",
-        "name": "remarks",
-        "type": "varchar",
-        "length": 255,
-        "nullable": "√",
-        "autoUpdated": "",
-        "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>ID of the terminal that initiated the withdrawal<\/p>"
     },
     {
-        "tableName": "terminal_provider",
-        "tableFileName": "terminal_provider",
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "remarks",
-        "type": "varchar",
-        "length": 255,
+        "name": "last_retry_ts",
+        "type": "int8",
+        "length": 19,
         "nullable": "√",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Timestamp of the last retry attempt<\/p>"
     },
     {
         "tableName": "terminal",
         "tableFileName": "terminal",
         "tableType": "Table",
-        "keyClass": "foreignKey",
-        "keyTitle": "Foreign Key",
-        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>provider_id",
+        "keyClass": "primaryKey",
+        "keyTitle": "Primary Key",
+        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>terminal_id",
         "type": "int8",
         "length": 19,
         "nullable": "",
-        "autoUpdated": "",
+        "autoUpdated": "√",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Uniquely identifies a terminal<\/p>"
     },
     {
         "tableName": "withdrawal",
@@ -214,27 +242,41 @@
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "withdrawal_status",
-        "type": "withdrawal_operation_status",
+        "name": "fees",
+        "type": "\"c2ec\".\"taler_amount_currency\"",
+        "length": 2147483647,
+        "nullable": "√",
+        "autoUpdated": "",
+        "defaultValue": "null",
+        "comments": "<p>Fees associated with the withdrawal, including exchange and provider fees<\/p>"
+    },
+    {
+        "tableName": "terminal_provider",
+        "tableFileName": "terminal_provider",
+        "tableType": "Table",
+        "keyClass": "indexedColumn",
+        "keyTitle": "Indexed",
+        "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>name",
+        "type": "text",
         "length": 2147483647,
         "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Name of the provider, used for selection in transaction proofing<\/p>"
     },
     {
-        "tableName": "terminal",
-        "tableFileName": "terminal",
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "access_token",
+        "name": "wopid",
         "type": "bytea",
         "length": 2147483647,
-        "nullable": "√",
+        "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>The wopid (withdrawal operation id) is a nonce generated by the terminal requesting a withdrawal. The wopid identifies a specific withdrawal spawning all involved systems.<\/p>"
     },
     {
         "tableName": "withdrawal",
@@ -242,13 +284,27 @@
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "registration_ts",
-        "type": "int8",
-        "length": 19,
-        "nullable": "√",
+        "name": "retry_counter",
+        "type": "int4",
+        "length": 10,
+        "nullable": "",
+        "autoUpdated": "",
+        "defaultValue": "0",
+        "comments": "<p>Number of retry attempts<\/p>"
+    },
+    {
+        "tableName": "terminal",
+        "tableFileName": "terminal",
+        "tableType": "Table",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "access_token",
+        "type": "bytea",
+        "length": 2147483647,
+        "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>The access token of the terminal used for authentication against the c2ec API<\/p>"
     },
     {
         "tableName": "terminal",
@@ -259,24 +315,52 @@
         "name": "active",
         "type": "bool",
         "length": 1,
-        "nullable": "√",
+        "nullable": "",
         "autoUpdated": "",
         "defaultValue": "true",
-        "comments": ""
+        "comments": "<p>Indicates if the terminal is active or deactivated<\/p>"
     },
     {
-        "tableName": "withdrawal",
-        "tableFileName": "withdrawal",
+        "tableName": "terminal_provider",
+        "tableFileName": "terminal_provider",
         "tableType": "Table",
         "keyClass": "primaryKey",
         "keyTitle": "Primary Key",
-        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>withdrawal_id",
-        "type": "bytea",
+        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>provider_terminal_id",
+        "type": "int8",
+        "length": 19,
+        "nullable": "",
+        "autoUpdated": "√",
+        "defaultValue": "null",
+        "comments": "<p>Uniquely identifies a provider<\/p>"
+    },
+    {
+        "tableName": "terminal_provider",
+        "tableFileName": "terminal_provider",
+        "tableType": "Table",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "backend_credentials",
+        "type": "text",
         "length": 2147483647,
         "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Credentials used to access the backend of the provider<\/p>"
+    },
+    {
+        "tableName": "terminal",
+        "tableFileName": "terminal",
+        "tableType": "Table",
+        "keyClass": "",
+        "keyTitle": "",
+        "name": "description",
+        "type": "text",
+        "length": 2147483647,
+        "nullable": "√",
+        "autoUpdated": "",
+        "defaultValue": "null",
+        "comments": "<p>Description to help identify the terminal. This may include the location and an identifier of the terminal.<\/p>"
     },
     {
         "tableName": "withdrawal",
@@ -284,13 +368,27 @@
         "tableType": "Table",
         "keyClass": "",
         "keyTitle": "",
-        "name": "reserve_pub_key",
+        "name": "completion_proof",
         "type": "bytea",
         "length": 2147483647,
         "nullable": "√",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Proof of transaction upon final completion delivered by the providers system<\/p>"
+    },
+    {
+        "tableName": "withdrawal",
+        "tableFileName": "withdrawal",
+        "tableType": "Table",
+        "keyClass": "primaryKey",
+        "keyTitle": "Primary Key",
+        "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>withdrawal_id",
+        "type": "int8",
+        "length": 19,
+        "nullable": "",
+        "autoUpdated": "√",
+        "defaultValue": "null",
+        "comments": "<p>The withdrawal id is used a technical id used by the wire gateway to sequentially select new transactions<\/p>"
     },
     {
         "tableName": "withdrawal",
@@ -299,12 +397,12 @@
         "keyClass": "",
         "keyTitle": "",
         "name": "amount",
-        "type": "varchar",
-        "length": 50,
-        "nullable": "√",
+        "type": "\"c2ec\".\"taler_amount_currency\"",
+        "length": 2147483647,
+        "nullable": "",
         "autoUpdated": "",
         "defaultValue": "null",
-        "comments": ""
+        "comments": "<p>Effective amount to be put into the reserve after completion<\/p>"
     }
 ];
                     var config = {
diff --git a/schemaspy/nonce2ecash-erd/constraint.js b/schemaspy/c2ec-erd/constraint.js
index 216c1a8..216c1a8 100644
--- a/schemaspy/nonce2ecash-erd/constraint.js
+++ b/schemaspy/c2ec-erd/constraint.js
diff --git a/schemaspy/nonce2ecash-erd/constraints.html b/schemaspy/c2ec-erd/constraints.html
index 641fa8b..59e68b9 100644
--- a/schemaspy/nonce2ecash-erd/constraints.html
+++ b/schemaspy/c2ec-erd/constraints.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -115,7 +115,7 @@
                                         <td>
                                             <table border='0' cellspacing='0' cellpadding='0'>
                                                 <tr>
-                                                    <td><a href='tables/terminal_provider.html'>terminal_provider</a><span>.id</span></td>
+                                                    <td><a href='tables/terminal_provider.html'>terminal_provider</a><span>.provider_terminal_id</span></td>
                                                 </tr>
                                             </table>
                                         </td>
@@ -133,7 +133,7 @@
                                         <td>
                                             <table border='0' cellspacing='0' cellpadding='0'>
                                                 <tr>
-                                                    <td><a href='tables/terminal.html'>terminal</a><span>.id</span></td>
+                                                    <td><a href='tables/terminal.html'>terminal</a><span>.terminal_id</span></td>
                                                 </tr>
                                             </table>
                                         </td>
@@ -180,8 +180,8 @@
                                     </tr>
                                     <tr>
                                         <td><a href='tables/withdrawal.html'>withdrawal</a></td>
-                                        <td>withdrawal_withdrawal_id_check</td>
-                                        <td>((length(withdrawal_id) &#61; 32))</td>
+                                        <td>withdrawal_wopid_check</td>
+                                        <td>((length(wopid) &#61; 32))</td>
                                     </tr>
                                 </tbody>
                             </table>
diff --git a/schemaspy/nonce2ecash-erd/deletionOrder.txt b/schemaspy/c2ec-erd/deletionOrder.txt
index bb05739..bb05739 100644
--- a/schemaspy/nonce2ecash-erd/deletionOrder.txt
+++ b/schemaspy/c2ec-erd/deletionOrder.txt
diff --git a/schemaspy/nonce2ecash-erd/diagrams/orphans/orphans.dot b/schemaspy/c2ec-erd/diagrams/orphans/orphans.dot
index 1756ef5..1756ef5 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/orphans/orphans.dot
+++ b/schemaspy/c2ec-erd/diagrams/orphans/orphans.dot
diff --git a/schemaspy/nonce2ecash-erd/diagrams/summary/relationships.real.compact.dot b/schemaspy/c2ec-erd/diagrams/summary/relationships.real.compact.dot
index 816df9c..41c2f12 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/summary/relationships.real.compact.dot
+++ b/schemaspy/c2ec-erd/diagrams/summary/relationships.real.compact.dot
@@ -4,7 +4,7 @@ digraph "compactRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
@@ -17,7 +17,8 @@ digraph "compactRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">provider_terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
@@ -29,8 +30,8 @@ digraph "compactRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="75" HEIGHT="16"><B>withdrawal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD></TR>
     </TABLE>>
@@ -38,6 +39,6 @@ digraph "compactRelationshipsDiagram" {
     target="_top"
     tooltip="withdrawal"
   ];
-  "terminal":"provider_id":w -> "terminal_provider":"id":e [arrowhead=none dir=back arrowtail=crowodot];
-  "withdrawal":"terminal_id":w -> "terminal":"id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "terminal":"provider_id":w -> "terminal_provider":"provider_terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"terminal_id":w -> "terminal":"terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
 }
diff --git a/schemaspy/nonce2ecash-erd/diagrams/summary/relationships.real.large.dot b/schemaspy/c2ec-erd/diagrams/summary/relationships.real.large.dot
index 02b4a79..2029c99 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/summary/relationships.real.large.dot
+++ b/schemaspy/c2ec-erd/diagrams/summary/relationships.real.large.dot
@@ -4,10 +4,10 @@ digraph "largeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="access_token" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">access_token</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="active" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">active</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="remarks" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">remarks</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">description</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
@@ -19,9 +19,10 @@ digraph "largeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="remarks" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">remarks</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">provider_terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="backend_base_url" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_base_url</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="backend_credentials" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_credentials</TD></TR></TABLE></TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
     URL="tables/terminal_provider.html"
@@ -32,18 +33,24 @@ digraph "largeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="75" HEIGHT="16"><B>withdrawal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="reserve_pub_key" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="registration_ts" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">registration_ts</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="amount" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">amount</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_status" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="wopid" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">wopid</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="reserve_pub_key" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="registration_ts" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">registration_ts</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="amount" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">amount</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="fees" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">fees</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="withdrawal_status" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_transaction_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">provider_transaction_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="last_retry_ts" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">last_retry_ts</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="retry_counter" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">retry_counter</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="completion_proof" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">completion_proof</TD></TR></TABLE></TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD></TR>
     </TABLE>>
     URL="tables/withdrawal.html"
     target="_top"
     tooltip="withdrawal"
   ];
-  "terminal":"provider_id":w -> "terminal_provider":"id":e [arrowhead=none dir=back arrowtail=crowodot];
-  "withdrawal":"terminal_id":w -> "terminal":"id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "terminal":"provider_id":w -> "terminal_provider":"provider_terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"terminal_id":w -> "terminal":"terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
 }
diff --git a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal.1degree.dot b/schemaspy/c2ec-erd/diagrams/tables/terminal.1degree.dot
index 18b61ab..b25e363 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal.1degree.dot
+++ b/schemaspy/c2ec-erd/diagrams/tables/terminal.1degree.dot
@@ -1,15 +1,15 @@
 digraph "oneDegreeRelationshipsDiagram" {
   graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
-  "terminal":"provider_id":w -> "terminal_provider":"id":e [arrowhead=none dir=back arrowtail=crowodot];
-  "withdrawal":"terminal_id":w -> "terminal":"id.type":e [arrowhead=none dir=back arrowtail=crowodot];
+  "terminal":"provider_id":w -> "terminal_provider":"provider_terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"terminal_id":w -> "terminal":"terminal_id.type":e [arrowhead=none dir=back arrowtail=crowodot];
   "terminal" [
    label=<
     <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD><TD PORT="id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD><TD PORT="terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
       <TR><TD PORT="access_token" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">access_token</TD></TR></TABLE></TD><TD PORT="access_token.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
       <TR><TD PORT="active" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">active</TD></TR></TABLE></TD><TD PORT="active.type" ALIGN="LEFT">bool[1]</TD></TR>
-      <TR><TD PORT="remarks" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">remarks</TD></TR></TABLE></TD><TD PORT="remarks.type" ALIGN="LEFT">varchar[255]</TD></TR>
+      <TR><TD PORT="description" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">description</TD></TR></TABLE></TD><TD PORT="description.type" ALIGN="LEFT">text[2147483647]</TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD><TD PORT="provider_id.type" ALIGN="LEFT">int8[19]</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
@@ -21,7 +21,8 @@ digraph "oneDegreeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">provider_terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
@@ -33,8 +34,8 @@ digraph "oneDegreeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="75" HEIGHT="16"><B>withdrawal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="withdrawal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD></TR>
     </TABLE>>
diff --git a/schemaspy/c2ec-erd/diagrams/tables/terminal_provider.1degree.dot b/schemaspy/c2ec-erd/diagrams/tables/terminal_provider.1degree.dot
new file mode 100644
index 0000000..9bd2940
--- /dev/null
+++ b/schemaspy/c2ec-erd/diagrams/tables/terminal_provider.1degree.dot
@@ -0,0 +1,31 @@
+digraph "oneDegreeRelationshipsDiagram" {
+  graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
+  "terminal":"provider_id":w -> "terminal_provider":"provider_terminal_id.type":e [arrowhead=none dir=back arrowtail=crowodot];
+  "terminal" [
+   label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
+    </TABLE>>
+    URL="terminal.html"
+    target="_top"
+    tooltip="terminal"
+  ];
+  "terminal_provider" [
+   label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="provider_terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">provider_terminal_id</TD></TR></TABLE></TD><TD PORT="provider_terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="name" COLSPAN="2" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">name</TD></TR></TABLE></TD><TD PORT="name.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="backend_base_url" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_base_url</TD></TR></TABLE></TD><TD PORT="backend_base_url.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="backend_credentials" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_credentials</TD></TR></TABLE></TD><TD PORT="backend_credentials.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
+    </TABLE>>
+    URL="terminal_provider.html"
+    target="_top"
+    tooltip="terminal_provider"
+  ];
+}
diff --git a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal_provider.2degrees.dot b/schemaspy/c2ec-erd/diagrams/tables/terminal_provider.2degrees.dot
index f2fc5a1..c3ca87c 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal_provider.2degrees.dot
+++ b/schemaspy/c2ec-erd/diagrams/tables/terminal_provider.2degrees.dot
@@ -1,12 +1,12 @@
 digraph "twoDegreesRelationshipsDiagram" {
   graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
-  "terminal":"provider_id":w -> "terminal_provider":"id.type":e [arrowhead=none dir=back arrowtail=crowodot];
-  "withdrawal":"elipses":w -> "terminal":"id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "terminal":"provider_id":w -> "terminal_provider":"provider_terminal_id.type":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"elipses":w -> "terminal":"terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
   "terminal" [
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
@@ -19,9 +19,10 @@ digraph "twoDegreesRelationshipsDiagram" {
    label=<
     <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">id</TD></TR></TABLE></TD><TD PORT="id.type" ALIGN="LEFT">int8[19]</TD></TR>
-      <TR><TD PORT="name" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">name</TD></TR></TABLE></TD><TD PORT="name.type" ALIGN="LEFT">varchar[50]</TD></TR>
-      <TR><TD PORT="remarks" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">remarks</TD></TR></TABLE></TD><TD PORT="remarks.type" ALIGN="LEFT">varchar[255]</TD></TR>
+      <TR><TD PORT="provider_terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">provider_terminal_id</TD></TR></TABLE></TD><TD PORT="provider_terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="name" COLSPAN="2" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">name</TD></TR></TABLE></TD><TD PORT="name.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="backend_base_url" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_base_url</TD></TR></TABLE></TD><TD PORT="backend_base_url.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="backend_credentials" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="139" HEIGHT="16">backend_credentials</TD></TR></TABLE></TD><TD PORT="backend_credentials.type" ALIGN="LEFT">text[2147483647]</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
     </TABLE>>
     URL="terminal_provider.html"
diff --git a/schemaspy/nonce2ecash-erd/diagrams/tables/withdrawal.1degree.dot b/schemaspy/c2ec-erd/diagrams/tables/withdrawal.1degree.dot
index c22809d..8d16940 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/tables/withdrawal.1degree.dot
+++ b/schemaspy/c2ec-erd/diagrams/tables/withdrawal.1degree.dot
@@ -1,11 +1,11 @@
 digraph "oneDegreeRelationshipsDiagram" {
   graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
-  "withdrawal":"terminal_id":w -> "terminal":"id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"terminal_id":w -> "terminal":"terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
   "terminal" [
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
@@ -18,12 +18,18 @@ digraph "oneDegreeRelationshipsDiagram" {
    label=<
     <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="75" HEIGHT="16"><B>withdrawal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD><TD PORT="withdrawal_id.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
-      <TR><TD PORT="reserve_pub_key" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD><TD PORT="reserve_pub_key.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
-      <TR><TD PORT="registration_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">registration_ts</TD></TR></TABLE></TD><TD PORT="registration_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
-      <TR><TD PORT="amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">amount</TD></TR></TABLE></TD><TD PORT="amount.type" ALIGN="LEFT">varchar[50]</TD></TR>
-      <TR><TD PORT="withdrawal_status" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD><TD PORT="withdrawal_status.type" ALIGN="LEFT">withdrawal_operation_status[2147483647]</TD></TR>
-      <TR><TD PORT="terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">terminal_id</TD></TR></TABLE></TD><TD PORT="terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="withdrawal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD><TD PORT="withdrawal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="wopid" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">wopid</TD></TR></TABLE></TD><TD PORT="wopid.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
+      <TR><TD PORT="reserve_pub_key" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD><TD PORT="reserve_pub_key.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
+      <TR><TD PORT="registration_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">registration_ts</TD></TR></TABLE></TD><TD PORT="registration_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">amount</TD></TR></TABLE></TD><TD PORT="amount.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;taler_amount_currency&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="fees" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">fees</TD></TR></TABLE></TD><TD PORT="fees.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;taler_amount_currency&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="withdrawal_status" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD><TD PORT="withdrawal_status.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;withdrawal_operation_status&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">terminal_id</TD></TR></TABLE></TD><TD PORT="terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="provider_transaction_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">provider_transaction_id</TD></TR></TABLE></TD><TD PORT="provider_transaction_id.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="last_retry_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">last_retry_ts</TD></TR></TABLE></TD><TD PORT="last_retry_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="retry_counter" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">retry_counter</TD></TR></TABLE></TD><TD PORT="retry_counter.type" ALIGN="LEFT">int4[10]</TD></TR>
+      <TR><TD PORT="completion_proof" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">completion_proof</TD></TR></TABLE></TD><TD PORT="completion_proof.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 &gt;</TD></TR>
     </TABLE>>
     URL="withdrawal.html"
diff --git a/schemaspy/nonce2ecash-erd/diagrams/tables/withdrawal.2degrees.dot b/schemaspy/c2ec-erd/diagrams/tables/withdrawal.2degrees.dot
index 08905c8..db58116 100644
--- a/schemaspy/nonce2ecash-erd/diagrams/tables/withdrawal.2degrees.dot
+++ b/schemaspy/c2ec-erd/diagrams/tables/withdrawal.2degrees.dot
@@ -1,12 +1,12 @@
 digraph "twoDegreesRelationshipsDiagram" {
   graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
   "terminal":"provider_id":w -> "terminal_provider":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
-  "withdrawal":"terminal_id":w -> "terminal":"id":e [arrowhead=none dir=back arrowtail=crowodot];
+  "withdrawal":"terminal_id":w -> "terminal":"terminal_id":e [arrowhead=none dir=back arrowtail=crowodot];
   "terminal" [
    label=<
     <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">terminal_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
       <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
@@ -30,12 +30,18 @@ digraph "twoDegreesRelationshipsDiagram" {
    label=<
     <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
       <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="75" HEIGHT="16"><B>withdrawal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="withdrawal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD><TD PORT="withdrawal_id.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
-      <TR><TD PORT="reserve_pub_key" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD><TD PORT="reserve_pub_key.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
-      <TR><TD PORT="registration_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">registration_ts</TD></TR></TABLE></TD><TD PORT="registration_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
-      <TR><TD PORT="amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">amount</TD></TR></TABLE></TD><TD PORT="amount.type" ALIGN="LEFT">varchar[50]</TD></TR>
-      <TR><TD PORT="withdrawal_status" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD><TD PORT="withdrawal_status.type" ALIGN="LEFT">withdrawal_operation_status[2147483647]</TD></TR>
-      <TR><TD PORT="terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="123" HEIGHT="16">terminal_id</TD></TR></TABLE></TD><TD PORT="terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="withdrawal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_id</TD></TR></TABLE></TD><TD PORT="withdrawal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="wopid" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">wopid</TD></TR></TABLE></TD><TD PORT="wopid.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
+      <TR><TD PORT="reserve_pub_key" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">reserve_pub_key</TD></TR></TABLE></TD><TD PORT="reserve_pub_key.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
+      <TR><TD PORT="registration_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">registration_ts</TD></TR></TABLE></TD><TD PORT="registration_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">amount</TD></TR></TABLE></TD><TD PORT="amount.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;taler_amount_currency&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="fees" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">fees</TD></TR></TABLE></TD><TD PORT="fees.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;taler_amount_currency&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="withdrawal_status" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">withdrawal_status</TD></TR></TABLE></TD><TD PORT="withdrawal_status.type" ALIGN="LEFT">&quot;c2ec&quot;.&quot;withdrawal_operation_status&quot;[2147483647]</TD></TR>
+      <TR><TD PORT="terminal_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">terminal_id</TD></TR></TABLE></TD><TD PORT="terminal_id.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="provider_transaction_id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">provider_transaction_id</TD></TR></TABLE></TD><TD PORT="provider_transaction_id.type" ALIGN="LEFT">text[2147483647]</TD></TR>
+      <TR><TD PORT="last_retry_ts" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">last_retry_ts</TD></TR></TABLE></TD><TD PORT="last_retry_ts.type" ALIGN="LEFT">int8[19]</TD></TR>
+      <TR><TD PORT="retry_counter" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">retry_counter</TD></TR></TABLE></TD><TD PORT="retry_counter.type" ALIGN="LEFT">int4[10]</TD></TR>
+      <TR><TD PORT="completion_proof" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="159" HEIGHT="16">completion_proof</TD></TR></TABLE></TD><TD PORT="completion_proof.type" ALIGN="LEFT">bytea[2147483647]</TD></TR>
       <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 &gt;</TD></TR>
     </TABLE>>
     URL="withdrawal.html"
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.eot b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.eot
index 22e84c0..22e84c0 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.eot
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.svg b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.svg
index 5204262..5204262 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.svg
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.ttf b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.ttf
index 87e74d2..87e74d2 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.ttf
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff
index 4942e74..4942e74 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff2 b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff2
index fb418a9..fb418a9 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff2
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower-v8-latin-regular.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower.css b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower.css
index 29c3285..29c3285 100644
--- a/schemaspy/nonce2ecash-erd/fonts/indieflower/indie-flower.css
+++ b/schemaspy/c2ec-erd/fonts/indieflower/indie-flower.css
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.eot
index 0c4dfa3..0c4dfa3 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.svg
index 806471c..806471c 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.ttf
index 66f7aa4..66f7aa4 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff
index 5e8ea9a..5e8ea9a 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff2
index 056348c..056348c 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.eot
index 6e28e95..6e28e95 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.svg
index 65f61bb..65f61bb 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.ttf
index 64f9f02..64f9f02 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff
index d5bcffe..d5bcffe 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff2
index 348ecc4..348ecc4 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-300italic.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.eot
index abb86d9..abb86d9 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.svg
index 3fda041..3fda041 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.ttf
index 3e4e263..3e4e263 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff
index ce91d12..ce91d12 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff2
index 8935ab5..8935ab5 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.eot
index 02be529..02be529 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.svg
index 29bc1d6..29bc1d6 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.ttf
index 715b066..715b066 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff
index a9fa76c..a9fa76c 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff2
index 78adf1c..78adf1c 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-600italic.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.eot
index 74c1bb4..74c1bb4 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.svg
index 0b6b6ab..0b6b6ab 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.ttf
index 773089d..773089d 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff
index 832c960..832c960 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff2
index 8922fdc..8922fdc 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-700.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.eot b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.eot
index 8af5373..8af5373 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.eot
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.eot
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.svg b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.svg
index 64f90f5..64f90f5 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.svg
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.svg
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.ttf b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.ttf
index c603136..c603136 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.ttf
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.ttf
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff
index 600602a..600602a 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff2 b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff2
index 88ef130..88ef130 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff2
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro-v10-latin-regular.woff2
diff --git a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro.css b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro.css
index 0dd7bf8..0dd7bf8 100644
--- a/schemaspy/nonce2ecash-erd/fonts/source-sans-pro/source-sans-pro.css
+++ b/schemaspy/c2ec-erd/fonts/source-sans-pro/source-sans-pro.css
diff --git a/schemaspy/nonce2ecash-erd/index.html b/schemaspy/c2ec-erd/index.html
index 25c0f98..c263153 100644
--- a/schemaspy/nonce2ecash-erd/index.html
+++ b/schemaspy/c2ec-erd/index.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -77,12 +77,12 @@
                     <div class="row">
                         <div class="col-md-12">
                             <div class="callout callout-info">
-                                <h4>SchemaSpy Analysis of postgres.public</h4>
-                                <p>Generated on Wed Mar 06 14:13 CET 2024</p>
+                                <h4>SchemaSpy Analysis of postgres.c2ec</h4>
+                                <p>Generated on Sun Mar 24 12:44 CET 2024</p>
                             </div>
                         </div>
                     </div>
-                    <a href="postgres.public.xml" title="XML Representation">XML Representation</a><br />
+                    <a href="postgres.c2ec.xml" title="XML Representation">XML Representation</a><br />
                     <a href="insertionOrder.txt" title="Useful for loading data into a database">Insertion Order</a>
                     <a href="deletionOrder.txt" title="Useful for purging data from a database">Deletion Order</a>
                 </section>
@@ -118,7 +118,7 @@
                                 <span class="info-box-icon bg-green"><span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span></span>
                                 <div class="info-box-content">
                                     <span class="info-box-text">COLUMNS</span>
-                                    <span class="info-box-number">14</span>
+                                    <span class="info-box-number">21</span>
                                 </div>
                                 <!-- /.info-box-content -->
                             </div>
@@ -182,11 +182,11 @@
                     </div>
                     <div class="box box-primary">
                         <div class="box-header with-border">
-                            <h3 class="box-title">Schema public</h3>
+                            <h3 class="box-title">Schema c2ec</h3>
                             <span class="label label-primary pull-right"><i class="fa fa-cog fa-2x"></i></span>
                         </div><!-- /.box-header -->
                         <div class="box-body">
-                            <p> <p>standard public schema</p> </p>
+                            <p> <p>Schema containing all tables and types related to c2ec (cashless2ecash)</p> </p>
                         </div><!-- /.box-body -->
                     </div>
                     <div class="box box-primary">
@@ -221,25 +221,25 @@
                                         <td class="detail" align="right">5</td>
                                         <td class="detail" align="right">-1</td>
                                         <td class="detail" align="right">Table</td>
-                                        <td class="comment detail" style="display: table-cell;"></td>
+                                        <td class="comment detail" style="display: table-cell;"><p>Table containing information about terminals of providers</p></td>
                                     </tr>
                                     <tr class="tbl even" valign="top">
                                         <td class="detail"><a href="tables/terminal_provider.html">terminal_provider</a></td>
                                         <td class="detail" align="right">1</td>
                                         <td class="detail" align="right">0</td>
-                                        <td class="detail" align="right">3</td>
+                                        <td class="detail" align="right">4</td>
                                         <td class="detail" align="right">-1</td>
                                         <td class="detail" align="right">Table</td>
-                                        <td class="comment detail" style="display: table-cell;"></td>
+                                        <td class="comment detail" style="display: table-cell;"><p>Table describing providers of c2ec terminal</p></td>
                                     </tr>
                                     <tr class="tbl even" valign="top">
                                         <td class="detail"><a href="tables/withdrawal.html">withdrawal</a></td>
                                         <td class="detail" align="right">0</td>
                                         <td class="detail" align="right">1</td>
-                                        <td class="detail" align="right">6</td>
+                                        <td class="detail" align="right">12</td>
                                         <td class="detail" align="right">-1</td>
                                         <td class="detail" align="right">Table</td>
-                                        <td class="comment detail" style="display: table-cell;"></td>
+                                        <td class="comment detail" style="display: table-cell;"><p>Table representing withdrawal processes initiated by terminals</p></td>
                                     </tr>
                             </table>
                         </div>
diff --git a/schemaspy/nonce2ecash-erd/info-html.txt b/schemaspy/c2ec-erd/info-html.txt
index 535c4a7..6b93fd2 100644
--- a/schemaspy/nonce2ecash-erd/info-html.txt
+++ b/schemaspy/c2ec-erd/info-html.txt
@@ -1,5 +1,5 @@
-date=2024-03-06 14:13:45+0100
-os=Linux 6.5.0-21-generic
+date=2024-03-24 12:44:39+0100
+os=Linux 6.5.0-26-generic
 schemaspy-version=6.2.4
 schemaspy-build=6.2.4.41 2023-07-21 11:15:12
 renderer=Graphviz dot 2.43.0 
diff --git a/schemaspy/nonce2ecash-erd/insertionOrder.txt b/schemaspy/c2ec-erd/insertionOrder.txt
index 69292cd..69292cd 100644
--- a/schemaspy/nonce2ecash-erd/insertionOrder.txt
+++ b/schemaspy/c2ec-erd/insertionOrder.txt
diff --git a/schemaspy/nonce2ecash-erd/main.js b/schemaspy/c2ec-erd/main.js
index ab6e466..ab6e466 100644
--- a/schemaspy/nonce2ecash-erd/main.js
+++ b/schemaspy/c2ec-erd/main.js
diff --git a/schemaspy/nonce2ecash-erd/orphans.html b/schemaspy/c2ec-erd/orphans.html
index 0b7f288..d027125 100644
--- a/schemaspy/nonce2ecash-erd/orphans.html
+++ b/schemaspy/c2ec-erd/orphans.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
diff --git a/schemaspy/c2ec-erd/postgres.c2ec.xml b/schemaspy/c2ec-erd/postgres.c2ec.xml
new file mode 100644
index 0000000..9dc240e
--- /dev/null
+++ b/schemaspy/c2ec-erd/postgres.c2ec.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="UTF-8"?><database name="postgres" schema="c2ec" type="PostgreSQL - 15.2 (Debian 15.2-1.pgdg110+1)">
+   <tables>
+      <table name="terminal" remarks="Table containing information about terminals of providers" schema="c2ec" type="TABLE">
+         <column autoUpdated="true" defaultValue="null" digits="0" id="0" name="terminal_id" nullable="false" remarks="Uniquely identifies a terminal" size="19" type="int8" typeCode="-5">
+            <child column="terminal_id" foreignKey="withdrawal_terminal_id_fkey" implied="false" onDeleteCascade="false" schema="c2ec" table="withdrawal"/>
+         </column>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="access_token" nullable="false" remarks="The access token of the terminal used for authentication against the c2ec API" size="2147483647" type="bytea" typeCode="-2"/>
+         <column autoUpdated="false" defaultValue="true" digits="0" id="2" name="active" nullable="false" remarks="Indicates if the terminal is active or deactivated" size="1" type="bool" typeCode="-7"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="3" name="description" nullable="true" remarks="Description to help identify the terminal. This may include the location and an identifier of the terminal." size="2147483647" type="text" typeCode="12"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="4" name="provider_id" nullable="false" remarks="Indicates the terminal provider to which the terminal belongs" size="19" type="int8" typeCode="-5">
+            <parent column="provider_terminal_id" foreignKey="terminal_provider_id_fkey" implied="false" onDeleteCascade="false" schema="c2ec" table="terminal_provider"/>
+         </column>
+         <primaryKey column="terminal_id" sequenceNumberInPK="1"/>
+         <index name="terminal_pkey" unique="true">
+            <column ascending="true" name="terminal_id"/>
+         </index>
+         <checkConstraint constraint="((length(access_token) = 32))" name="terminal_access_token_check"/>
+      </table>
+      <table name="terminal_provider" remarks="Table describing providers of c2ec terminal" schema="c2ec" type="TABLE">
+         <column autoUpdated="true" defaultValue="null" digits="0" id="0" name="provider_terminal_id" nullable="false" remarks="Uniquely identifies a provider" size="19" type="int8" typeCode="-5">
+            <child column="provider_id" foreignKey="terminal_provider_id_fkey" implied="false" onDeleteCascade="false" schema="c2ec" table="terminal"/>
+         </column>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="name" nullable="false" remarks="Name of the provider, used for selection in transaction proofing" size="2147483647" type="text" typeCode="12"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="2" name="backend_base_url" nullable="false" remarks="URL of the provider backend for transaction proofing" size="2147483647" type="text" typeCode="12"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="3" name="backend_credentials" nullable="false" remarks="Credentials used to access the backend of the provider" size="2147483647" type="text" typeCode="12"/>
+         <primaryKey column="provider_terminal_id" sequenceNumberInPK="1"/>
+         <index name="terminal_provider_pkey" unique="true">
+            <column ascending="true" name="provider_terminal_id"/>
+         </index>
+         <index name="terminal_provider_name_key" unique="true">
+            <column ascending="true" name="name"/>
+         </index>
+      </table>
+      <table name="withdrawal" remarks="Table representing withdrawal processes initiated by terminals" schema="c2ec" type="TABLE">
+         <column autoUpdated="true" defaultValue="null" digits="0" id="0" name="withdrawal_id" nullable="false" remarks="The withdrawal id is used a technical id used by the wire gateway to sequentially select new transactions" size="19" type="int8" typeCode="-5"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="wopid" nullable="false" remarks="The wopid (withdrawal operation id) is a nonce generated by the terminal requesting a withdrawal.&#10;&#9;The wopid identifies a specific withdrawal spawning all involved systems." size="2147483647" type="bytea" typeCode="-2"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="2" name="reserve_pub_key" nullable="false" remarks="Reserve public key for the reserve which will hold the withdrawal amount after completion" size="2147483647" type="bytea" typeCode="-2"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="3" name="registration_ts" nullable="false" remarks="Timestamp of when the withdrawal request was registered" size="19" type="int8" typeCode="-5"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="4" name="amount" nullable="false" remarks="Effective amount to be put into the reserve after completion" size="2147483647" type="&quot;c2ec&quot;.&quot;taler_amount_currency&quot;" typeCode="2002"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="5" name="fees" nullable="true" remarks="Fees associated with the withdrawal, including exchange and provider fees" size="2147483647" type="&quot;c2ec&quot;.&quot;taler_amount_currency&quot;" typeCode="2002"/>
+         <column autoUpdated="false" defaultValue="'pending'::c2ec.withdrawal_operation_status" digits="0" id="6" name="withdrawal_status" nullable="false" remarks="Status of the withdrawal process" size="2147483647" type="&quot;c2ec&quot;.&quot;withdrawal_operation_status&quot;" typeCode="12"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="7" name="terminal_id" nullable="false" remarks="ID of the terminal that initiated the withdrawal" size="19" type="int8" typeCode="-5">
+            <parent column="terminal_id" foreignKey="withdrawal_terminal_id_fkey" implied="false" onDeleteCascade="false" schema="c2ec" table="terminal"/>
+         </column>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="8" name="provider_transaction_id" nullable="true" remarks="Transaction identifier supplied by the provider for backend request" size="2147483647" type="text" typeCode="12"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="9" name="last_retry_ts" nullable="true" remarks="Timestamp of the last retry attempt" size="19" type="int8" typeCode="-5"/>
+         <column autoUpdated="false" defaultValue="0" digits="0" id="10" name="retry_counter" nullable="false" remarks="Number of retry attempts" size="10" type="int4" typeCode="4"/>
+         <column autoUpdated="false" defaultValue="null" digits="0" id="11" name="completion_proof" nullable="true" remarks="Proof of transaction upon final completion delivered by the providers system" size="2147483647" type="bytea" typeCode="-2"/>
+         <primaryKey column="withdrawal_id" sequenceNumberInPK="1"/>
+         <index name="withdrawal_pkey" unique="true">
+            <column ascending="true" name="withdrawal_id"/>
+         </index>
+         <checkConstraint constraint="((length(reserve_pub_key) = 32))" name="withdrawal_reserve_pub_key_check"/>
+         <checkConstraint constraint="((length(wopid) = 32))" name="withdrawal_wopid_check"/>
+      </table>
+   </tables>
+</database>
diff --git a/schemaspy/nonce2ecash-erd/relationships.html b/schemaspy/c2ec-erd/relationships.html
index 052c40e..94bd54d 100644
--- a/schemaspy/nonce2ecash-erd/relationships.html
+++ b/schemaspy/c2ec-erd/relationships.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -94,16 +94,16 @@
                                     <div class="chart tab-pane active" id="compactDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="compactRelationshipsDiagram" name="compactRelationshipsDiagram">
 <area shape="rect" id="node1" href="tables/terminal.html" target="_top" title="terminal" alt="" coords="293,35,461,181">
-<area shape="rect" id="node2" href="tables/terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,64,249,181">
-<area shape="rect" id="node3" href="tables/withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,719,152">
+<area shape="rect" id="node2" href="tables/terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,64,249,211">
+<area shape="rect" id="node3" href="tables/withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,767,152">
 </map>
                                         <a name='diagram'><img id="compactDegreeImg" src="diagrams/summary/relationships.real.compact.png" usemap="#compactRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
                                     <div class="chart tab-pane " id="largeDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="largeRelationshipsDiagram" name="largeRelationshipsDiagram">
-<area shape="rect" id="node1" href="tables/terminal.html" target="_top" title="terminal" alt="" coords="293,152,461,363">
-<area shape="rect" id="node2" href="tables/terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,269,249,421">
-<area shape="rect" id="node3" href="tables/withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,719,245">
+<area shape="rect" id="node1" href="tables/terminal.html" target="_top" title="terminal" alt="" coords="293,211,461,421">
+<area shape="rect" id="node2" href="tables/terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,328,249,509">
+<area shape="rect" id="node3" href="tables/withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,767,421">
 </map>
                                         <a name='diagram'><img id="largeDegreeImg" src="diagrams/summary/relationships.real.large.png" usemap="#largeRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
diff --git a/schemaspy/nonce2ecash-erd/relationships.js b/schemaspy/c2ec-erd/relationships.js
index 3c93eab..3c93eab 100644
--- a/schemaspy/nonce2ecash-erd/relationships.js
+++ b/schemaspy/c2ec-erd/relationships.js
diff --git a/schemaspy/nonce2ecash-erd/routines.html b/schemaspy/c2ec-erd/routines.html
index 9971b1f..fde41fd 100644
--- a/schemaspy/nonce2ecash-erd/routines.html
+++ b/schemaspy/c2ec-erd/routines.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>postgres.public</title>
+        <title>postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
diff --git a/schemaspy/nonce2ecash-erd/routines.js b/schemaspy/c2ec-erd/routines.js
index cdc2350..cdc2350 100644
--- a/schemaspy/nonce2ecash-erd/routines.js
+++ b/schemaspy/c2ec-erd/routines.js
diff --git a/schemaspy/nonce2ecash-erd/routines/routine.js b/schemaspy/c2ec-erd/routines/routine.js
index efd2b21..efd2b21 100644
--- a/schemaspy/nonce2ecash-erd/routines/routine.js
+++ b/schemaspy/c2ec-erd/routines/routine.js
diff --git a/schemaspy/nonce2ecash-erd/schemaSpy.css b/schemaspy/c2ec-erd/schemaSpy.css
index 1f1e67c..1f1e67c 100644
--- a/schemaspy/nonce2ecash-erd/schemaSpy.css
+++ b/schemaspy/c2ec-erd/schemaSpy.css
diff --git a/schemaspy/nonce2ecash-erd/schemaSpy.js b/schemaspy/c2ec-erd/schemaSpy.js
index 983327c..983327c 100644
--- a/schemaspy/nonce2ecash-erd/schemaSpy.js
+++ b/schemaspy/c2ec-erd/schemaSpy.js
diff --git a/schemaspy/nonce2ecash-erd/tables/table.js b/schemaspy/c2ec-erd/tables/table.js
index 627ec13..627ec13 100644
--- a/schemaspy/nonce2ecash-erd/tables/table.js
+++ b/schemaspy/c2ec-erd/tables/table.js
diff --git a/schemaspy/nonce2ecash-erd/tables/terminal.html b/schemaspy/c2ec-erd/tables/terminal.html
index 763dc37..2f91934 100644
--- a/schemaspy/nonce2ecash-erd/tables/terminal.html
+++ b/schemaspy/c2ec-erd/tables/terminal.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>terminal - postgres.public</title>
+        <title>terminal - postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -74,6 +74,19 @@
                 <!-- Content Header (Page header) -->
                 <section class="content-header">
                     <h1>terminal</h1><p><span id="recordNumber">-1</span> rows</p><br />
+                    <div class="box box-primary">
+                        <div class="box-header with-border">
+                            <i class="fa fa-file-text-o"></i>
+                            <h3 id="Description" class="box-title">Description</h3>
+                            <div class="box-tools pull-right">
+                                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
+                                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
+                            </div>
+                        </div><!-- /.box-header -->
+                        <div class="box-body clearfix">
+                            <p>Table containing information about terminals of providers</p>
+                        </div><!-- /.box-body -->
+                    </div>
                 </section>
                 <!-- Main content -->
                 <section class="content">
@@ -109,7 +122,7 @@
                                 </thead>
                                 <tbody>
                                 <tr>
-                                    <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="id">id</span></td>
+                                    <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="terminal_id">terminal_id</span></td>
                                     <td>int8</td>
                                     <td>19</td>
                                     <td title=''></td>
@@ -118,7 +131,7 @@
                                     <td>
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                             <tr>
-                                                <td title="withdrawal.terminal_id references terminal.id via withdrawal_terminal_id_fkey"><a href='withdrawal.html'>withdrawal</a><span class='relatedKey'>.terminal_id</span></td>
+                                                <td title="withdrawal.terminal_id references terminal.terminal_id via withdrawal_terminal_id_fkey"><a href='withdrawal.html'>withdrawal</a><span class='relatedKey'>.terminal_id</span></td>
                                                 <td class="constraint detail">withdrawal_terminal_id_fkey</td>
                                                 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
                                             </tr>
@@ -128,13 +141,13 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Uniquely identifies a terminal</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="access_token">access_token</span></td>
                                     <td>bytea</td>
                                     <td>2147483647</td>
-                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>null</td>
                                     <td>
@@ -145,13 +158,13 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>The access token of the terminal used for authentication against the c2ec API</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="active">active</span></td>
                                     <td>bool</td>
                                     <td>1</td>
-                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>true</td>
                                     <td>
@@ -162,12 +175,12 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Indicates if the terminal is active or deactivated</p></td>
                                 </tr>
                                 <tr>
-                                    <td><span id="remarks">remarks</span></td>
-                                    <td>varchar</td>
-                                    <td>255</td>
+                                    <td><span id="description">description</span></td>
+                                    <td>text</td>
+                                    <td>2147483647</td>
                                     <td title='nullable'>√</td>
                                     <td title=''></td>
                                     <td>null</td>
@@ -179,7 +192,7 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Description to help identify the terminal. This may include the location and an identifier of the terminal.</p></td>
                                 </tr>
                                 <tr>
                                     <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="provider_id">provider_id</span></td>
@@ -195,13 +208,13 @@
                                     <td>
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                             <tr>
-                                                <td title="terminal.provider_id references terminal_provider.id via terminal_provider_id_fkey"><a href='terminal_provider.html'>terminal_provider</a><span class='relatedKey'>.id</span></td>
+                                                <td title="terminal.provider_id references terminal_provider.provider_terminal_id via terminal_provider_id_fkey"><a href='terminal_provider.html'>terminal_provider</a><span class='relatedKey'>.provider_terminal_id</span></td>
                                                 <td class="constraint detail">terminal_provider_id_fkey</td>
                                                 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
                                             </tr>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Indicates the terminal provider to which the terminal belongs</p></td>
                                 </tr>
                                 </tbody>
                             </table>
@@ -237,7 +250,7 @@
                                     <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> terminal_pkey</td>
                                     <td>Primary key</td>
                                     <td><span title='Ascending'>Asc</span></td>
-                                    <td>id</td>
+                                    <td>terminal_id</td>
                                 </tr>
                                 </tbody>
                             </table>
@@ -294,8 +307,8 @@
                                     <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram">
 <area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="293,32,620,248">
-<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,152,249,269">
-<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="664,5,877,152">
+<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,152,249,299">
+<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="664,5,925,152">
 </map>
                                         <a name='diagram'><img id="oneDegreeImg" src="../diagrams/tables/terminal.1degree.png" usemap="#oneDegreeRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
diff --git a/schemaspy/nonce2ecash-erd/tables/terminal_provider.html b/schemaspy/c2ec-erd/tables/terminal_provider.html
index 56c3495..b5450f1 100644
--- a/schemaspy/nonce2ecash-erd/tables/terminal_provider.html
+++ b/schemaspy/c2ec-erd/tables/terminal_provider.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>terminal_provider - postgres.public</title>
+        <title>terminal_provider - postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -74,6 +74,19 @@
                 <!-- Content Header (Page header) -->
                 <section class="content-header">
                     <h1>terminal_provider</h1><p><span id="recordNumber">-1</span> rows</p><br />
+                    <div class="box box-primary">
+                        <div class="box-header with-border">
+                            <i class="fa fa-file-text-o"></i>
+                            <h3 id="Description" class="box-title">Description</h3>
+                            <div class="box-tools pull-right">
+                                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
+                                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
+                            </div>
+                        </div><!-- /.box-header -->
+                        <div class="box-body clearfix">
+                            <p>Table describing providers of c2ec terminal</p>
+                        </div><!-- /.box-body -->
+                    </div>
                 </section>
                 <!-- Main content -->
                 <section class="content">
@@ -109,7 +122,7 @@
                                 </thead>
                                 <tbody>
                                 <tr>
-                                    <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="id">id</span></td>
+                                    <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="provider_terminal_id">provider_terminal_id</span></td>
                                     <td>int8</td>
                                     <td>19</td>
                                     <td title=''></td>
@@ -118,7 +131,7 @@
                                     <td>
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                             <tr>
-                                                <td title="terminal.provider_id references terminal_provider.id via terminal_provider_id_fkey"><a href='terminal.html'>terminal</a><span class='relatedKey'>.provider_id</span></td>
+                                                <td title="terminal.provider_id references terminal_provider.provider_terminal_id via terminal_provider_id_fkey"><a href='terminal.html'>terminal</a><span class='relatedKey'>.provider_id</span></td>
                                                 <td class="constraint detail">terminal_provider_id_fkey</td>
                                                 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
                                             </tr>
@@ -128,13 +141,30 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Uniquely identifies a provider</p></td>
+                                </tr>
+                                <tr>
+                                    <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="name">name</span></td>
+                                    <td>text</td>
+                                    <td>2147483647</td>
+                                    <td title=''></td>
+                                    <td title=''></td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Name of the provider, used for selection in transaction proofing</p></td>
                                 </tr>
                                 <tr>
-                                    <td><span id="name">name</span></td>
-                                    <td>varchar</td>
-                                    <td>50</td>
-                                    <td title='nullable'>√</td>
+                                    <td><span id="backend_base_url">backend_base_url</span></td>
+                                    <td>text</td>
+                                    <td>2147483647</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>null</td>
                                     <td>
@@ -145,13 +175,13 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>URL of the provider backend for transaction proofing</p></td>
                                 </tr>
                                 <tr>
-                                    <td><span id="remarks">remarks</span></td>
-                                    <td>varchar</td>
-                                    <td>255</td>
-                                    <td title='nullable'>√</td>
+                                    <td><span id="backend_credentials">backend_credentials</span></td>
+                                    <td>text</td>
+                                    <td>2147483647</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>null</td>
                                     <td>
@@ -162,7 +192,7 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Credentials used to access the backend of the provider</p></td>
                                 </tr>
                                 </tbody>
                             </table>
@@ -198,7 +228,13 @@
                                     <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> terminal_provider_pkey</td>
                                     <td>Primary key</td>
                                     <td><span title='Ascending'>Asc</span></td>
-                                    <td>id</td>
+                                    <td>provider_terminal_id</td>
+                                </tr>
+                                <tr>
+                                    <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> terminal_provider_name_key</td>
+                                    <td>Must be unique</td>
+                                    <td><span title='Ascending'>Asc</span></td>
+                                    <td>name</td>
                                 </tr>
                                 </tbody>
                             </table>
@@ -223,16 +259,16 @@
                                 <div class="tab-content no-padding">
                                     <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram">
-<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="368,5,536,152">
-<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,32,324,189">
+<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="431,5,599,152">
+<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,32,387,219">
 </map>
                                         <a name='diagram'><img id="oneDegreeImg" src="../diagrams/tables/terminal_provider.1degree.png" usemap="#oneDegreeRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
                                     <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram">
-<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="368,5,536,152">
-<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,32,324,189">
-<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="580,8,764,96">
+<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="431,5,599,152">
+<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,32,387,219">
+<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="643,8,827,96">
 </map>
                                         <a name='diagram'><img id="twodegreesDegreeImg" src="../diagrams/tables/terminal_provider.2degrees.png" usemap="#twoDegreesRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
diff --git a/schemaspy/nonce2ecash-erd/tables/withdrawal.html b/schemaspy/c2ec-erd/tables/withdrawal.html
index d69c370..8a244d9 100644
--- a/schemaspy/nonce2ecash-erd/tables/withdrawal.html
+++ b/schemaspy/c2ec-erd/tables/withdrawal.html
@@ -3,7 +3,7 @@
     <head>
         <meta charset="utf-8">
         <meta http-equiv="X-UA-Compatible" content="IE=edge">
-        <title>withdrawal - postgres.public</title>
+        <title>withdrawal - postgres.c2ec</title>
         <!-- Tell the browser to be responsive to screen width -->
         <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
         <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
@@ -46,7 +46,7 @@
                 <nav class="navbar navbar-static-top">
                     <div class="container">
                         <div class="navbar-header">
-                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.public</span>
+                            <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span>
                             <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
                         </div>
 
@@ -74,6 +74,19 @@
                 <!-- Content Header (Page header) -->
                 <section class="content-header">
                     <h1>withdrawal</h1><p><span id="recordNumber">-1</span> rows</p><br />
+                    <div class="box box-primary">
+                        <div class="box-header with-border">
+                            <i class="fa fa-file-text-o"></i>
+                            <h3 id="Description" class="box-title">Description</h3>
+                            <div class="box-tools pull-right">
+                                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
+                                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
+                            </div>
+                        </div><!-- /.box-header -->
+                        <div class="box-body clearfix">
+                            <p>Table representing withdrawal processes initiated by terminals</p>
+                        </div><!-- /.box-body -->
+                    </div>
                 </section>
                 <!-- Main content -->
                 <section class="content">
@@ -110,6 +123,23 @@
                                 <tbody>
                                 <tr>
                                     <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="withdrawal_id">withdrawal_id</span></td>
+                                    <td>int8</td>
+                                    <td>19</td>
+                                    <td title=''></td>
+                                    <td title='Automatically updated by the database'>√</td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>The withdrawal id is used a technical id used by the wire gateway to sequentially select new transactions</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="wopid">wopid</span></td>
                                     <td>bytea</td>
                                     <td>2147483647</td>
                                     <td title=''></td>
@@ -123,13 +153,13 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>The wopid (withdrawal operation id) is a nonce generated by the terminal requesting a withdrawal. The wopid identifies a specific withdrawal spawning all involved systems.</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="reserve_pub_key">reserve_pub_key</span></td>
                                     <td>bytea</td>
                                     <td>2147483647</td>
-                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>null</td>
                                     <td>
@@ -140,13 +170,13 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Reserve public key for the reserve which will hold the withdrawal amount after completion</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="registration_ts">registration_ts</span></td>
                                     <td>int8</td>
                                     <td>19</td>
-                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
                                     <td title=''></td>
                                     <td>null</td>
                                     <td>
@@ -157,12 +187,29 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Timestamp of when the withdrawal request was registered</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="amount">amount</span></td>
-                                    <td>varchar</td>
-                                    <td>50</td>
+                                    <td>&quot;c2ec&quot;.&quot;taler_amount_currency&quot;</td>
+                                    <td>2147483647</td>
+                                    <td title=''></td>
+                                    <td title=''></td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Effective amount to be put into the reserve after completion</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="fees">fees</span></td>
+                                    <td>&quot;c2ec&quot;.&quot;taler_amount_currency&quot;</td>
+                                    <td>2147483647</td>
                                     <td title='nullable'>√</td>
                                     <td title=''></td>
                                     <td>null</td>
@@ -174,15 +221,15 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Fees associated with the withdrawal, including exchange and provider fees</p></td>
                                 </tr>
                                 <tr>
                                     <td><span id="withdrawal_status">withdrawal_status</span></td>
-                                    <td>withdrawal_operation_status</td>
+                                    <td>&quot;c2ec&quot;.&quot;withdrawal_operation_status&quot;</td>
                                     <td>2147483647</td>
                                     <td title=''></td>
                                     <td title=''></td>
-                                    <td>null</td>
+                                    <td>&#39;pending&#39;::c2ec.withdrawal_operation_status</td>
                                     <td>
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
@@ -191,7 +238,7 @@
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>Status of the withdrawal process</p></td>
                                 </tr>
                                 <tr>
                                     <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="terminal_id">terminal_id</span></td>
@@ -207,13 +254,81 @@
                                     <td>
                                         <table border='0' cellspacing='0' cellpadding='0'>
                                             <tr>
-                                                <td title="withdrawal.terminal_id references terminal.id via withdrawal_terminal_id_fkey"><a href='terminal.html'>terminal</a><span class='relatedKey'>.id</span></td>
+                                                <td title="withdrawal.terminal_id references terminal.terminal_id via withdrawal_terminal_id_fkey"><a href='terminal.html'>terminal</a><span class='relatedKey'>.terminal_id</span></td>
                                                 <td class="constraint detail">withdrawal_terminal_id_fkey</td>
                                                 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
                                             </tr>
                                         </table>
                                     </td>
-                                    <td></td>
+                                    <td><p>ID of the terminal that initiated the withdrawal</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="provider_transaction_id">provider_transaction_id</span></td>
+                                    <td>text</td>
+                                    <td>2147483647</td>
+                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Transaction identifier supplied by the provider for backend request</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="last_retry_ts">last_retry_ts</span></td>
+                                    <td>int8</td>
+                                    <td>19</td>
+                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Timestamp of the last retry attempt</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="retry_counter">retry_counter</span></td>
+                                    <td>int4</td>
+                                    <td>10</td>
+                                    <td title=''></td>
+                                    <td title=''></td>
+                                    <td>0</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Number of retry attempts</p></td>
+                                </tr>
+                                <tr>
+                                    <td><span id="completion_proof">completion_proof</span></td>
+                                    <td>bytea</td>
+                                    <td>2147483647</td>
+                                    <td title='nullable'>√</td>
+                                    <td title=''></td>
+                                    <td>null</td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td>
+                                        <table border='0' cellspacing='0' cellpadding='0'>
+                                        </table>
+                                    </td>
+                                    <td><p>Proof of transaction upon final completion delivered by the providers system</p></td>
                                 </tr>
                                 </tbody>
                             </table>
@@ -280,13 +395,13 @@
                                 </thead>
                                 <tbody>
                                 <tr>
-                                    <td>withdrawal_withdrawal_id_check</td>
-                                    <td>((length(withdrawal_id) &#61; 32))</td>
-                                </tr>
-                                <tr>
                                     <td>withdrawal_reserve_pub_key_check</td>
                                     <td>((length(reserve_pub_key) &#61; 32))</td>
                                 </tr>
+                                <tr>
+                                    <td>withdrawal_wopid_check</td>
+                                    <td>((length(wopid) &#61; 32))</td>
+                                </tr>
                                 </tbody>
                             </table>
                         </div>
@@ -310,16 +425,16 @@
                                 <div class="tab-content no-padding">
                                     <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram">
-<area shape="rect" id="node1" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="217,5,757,251">
-<area shape="rect" id="node2" href="terminal.html" target="_top" title="terminal" alt="" coords="5,155,173,301">
+<area shape="rect" id="node1" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="217,5,872,427">
+<area shape="rect" id="node2" href="terminal.html" target="_top" title="terminal" alt="" coords="5,213,173,360">
 </map>
                                         <a name='diagram'><img id="oneDegreeImg" src="../diagrams/tables/withdrawal.1degree.png" usemap="#oneDegreeRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
                                     <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;">
                                         <map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram">
-<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="293,155,461,301">
-<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,187,249,275">
-<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,1045,251">
+<area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="293,213,461,360">
+<area shape="rect" id="node2" href="terminal_provider.html" target="_top" title="terminal_provider" alt="" coords="5,245,249,333">
+<area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="505,5,1160,427">
 </map>
                                         <a name='diagram'><img id="twodegreesDegreeImg" src="../diagrams/tables/withdrawal.2degrees.png" usemap="#twoDegreesRelationshipsDiagram" class="diagram" border="0" align="left"></a>
                                     </div>
diff --git a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal_provider.1degree.dot b/schemaspy/nonce2ecash-erd/diagrams/tables/terminal_provider.1degree.dot
deleted file mode 100644
index 0e2811d..0000000
--- a/schemaspy/nonce2ecash-erd/diagrams/tables/terminal_provider.1degree.dot
+++ /dev/null
@@ -1,30 +0,0 @@
-digraph "oneDegreeRelationshipsDiagram" {
-  graph [    rankdir="RL"    bgcolor="#ffffff"    label="\nGenerated by SchemaSpy"    labeljust="l"    nodesep="0.18"    ranksep="0.46"    fontname="Helvetica"    fontsize="11"    ration="compress"  ];  node [    fontname="Helvetica"    fontsize="11"    shape="plaintext"  ];  edge [    arrowsize="0.8"  ];
-  "terminal":"provider_id":w -> "terminal_provider":"id.type":e [arrowhead=none dir=back arrowtail=crowodot];
-  "terminal" [
-   label=<
-    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
-      <TR><TD COLSPAN="3"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="57" HEIGHT="16"><B>terminal</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="provider_id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="89" HEIGHT="16">provider_id</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
-      <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
-    </TABLE>>
-    URL="terminal.html"
-    target="_top"
-    tooltip="terminal"
-  ];
-  "terminal_provider" [
-   label=<
-    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
-      <TR><TD COLSPAN="4"  BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16"><B>terminal_provider</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
-      <TR><TD PORT="id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">id</TD></TR></TABLE></TD><TD PORT="id.type" ALIGN="LEFT">int8[19]</TD></TR>
-      <TR><TD PORT="name" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">name</TD></TR></TABLE></TD><TD PORT="name.type" ALIGN="LEFT">varchar[50]</TD></TR>
-      <TR><TD PORT="remarks" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="120" HEIGHT="16">remarks</TD></TR></TABLE></TD><TD PORT="remarks.type" ALIGN="LEFT">varchar[255]</TD></TR>
-      <TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">  </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
-    </TABLE>>
-    URL="terminal_provider.html"
-    target="_top"
-    tooltip="terminal_provider"
-  ];
-}
diff --git a/schemaspy/nonce2ecash-erd/postgres.public.xml b/schemaspy/nonce2ecash-erd/postgres.public.xml
deleted file mode 100644
index b62a97a..0000000
--- a/schemaspy/nonce2ecash-erd/postgres.public.xml
+++ /dev/null
@@ -1,47 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><database name="postgres" schema="public" type="PostgreSQL - 15.2 (Debian 15.2-1.pgdg110+1)">
-   <tables>
-      <table name="terminal" remarks="" schema="public" type="TABLE">
-         <column autoUpdated="true" defaultValue="null" digits="0" id="0" name="id" nullable="false" remarks="" size="19" type="int8" typeCode="-5">
-            <child column="terminal_id" foreignKey="withdrawal_terminal_id_fkey" implied="false" onDeleteCascade="false" schema="public" table="withdrawal"/>
-         </column>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="access_token" nullable="true" remarks="" size="2147483647" type="bytea" typeCode="-2"/>
-         <column autoUpdated="false" defaultValue="true" digits="0" id="2" name="active" nullable="true" remarks="" size="1" type="bool" typeCode="-7"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="3" name="remarks" nullable="true" remarks="" size="255" type="varchar" typeCode="12"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="4" name="provider_id" nullable="false" remarks="" size="19" type="int8" typeCode="-5">
-            <parent column="id" foreignKey="terminal_provider_id_fkey" implied="false" onDeleteCascade="false" schema="public" table="terminal_provider"/>
-         </column>
-         <primaryKey column="id" sequenceNumberInPK="1"/>
-         <index name="terminal_pkey" unique="true">
-            <column ascending="true" name="id"/>
-         </index>
-         <checkConstraint constraint="((length(access_token) = 32))" name="terminal_access_token_check"/>
-      </table>
-      <table name="terminal_provider" remarks="" schema="public" type="TABLE">
-         <column autoUpdated="true" defaultValue="null" digits="0" id="0" name="id" nullable="false" remarks="" size="19" type="int8" typeCode="-5">
-            <child column="provider_id" foreignKey="terminal_provider_id_fkey" implied="false" onDeleteCascade="false" schema="public" table="terminal"/>
-         </column>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="name" nullable="true" remarks="" size="50" type="varchar" typeCode="12"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="2" name="remarks" nullable="true" remarks="" size="255" type="varchar" typeCode="12"/>
-         <primaryKey column="id" sequenceNumberInPK="1"/>
-         <index name="terminal_provider_pkey" unique="true">
-            <column ascending="true" name="id"/>
-         </index>
-      </table>
-      <table name="withdrawal" remarks="" schema="public" type="TABLE">
-         <column autoUpdated="false" defaultValue="null" digits="0" id="0" name="withdrawal_id" nullable="false" remarks="" size="2147483647" type="bytea" typeCode="-2"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="1" name="reserve_pub_key" nullable="true" remarks="" size="2147483647" type="bytea" typeCode="-2"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="2" name="registration_ts" nullable="true" remarks="" size="19" type="int8" typeCode="-5"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="3" name="amount" nullable="true" remarks="" size="50" type="varchar" typeCode="12"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="4" name="withdrawal_status" nullable="false" remarks="" size="2147483647" type="withdrawal_operation_status" typeCode="12"/>
-         <column autoUpdated="false" defaultValue="null" digits="0" id="5" name="terminal_id" nullable="false" remarks="" size="19" type="int8" typeCode="-5">
-            <parent column="id" foreignKey="withdrawal_terminal_id_fkey" implied="false" onDeleteCascade="false" schema="public" table="terminal"/>
-         </column>
-         <primaryKey column="withdrawal_id" sequenceNumberInPK="1"/>
-         <index name="withdrawal_pkey" unique="true">
-            <column ascending="true" name="withdrawal_id"/>
-         </index>
-         <checkConstraint constraint="((length(reserve_pub_key) = 32))" name="withdrawal_reserve_pub_key_check"/>
-         <checkConstraint constraint="((length(withdrawal_id) = 32))" name="withdrawal_withdrawal_id_check"/>
-      </table>
-   </tables>
-</database>
author	Joel-Haeberli <haebu@rubigen.ch>	2024-03-24 21:53:55 +0100
committer	Joel-Haeberli <haebu@rubigen.ch>	2024-03-24 21:53:55 +0100
commit	8d788b2b6a319deef49f267b8966bfe226bcbc20 (patch)
tree	936ea8866cc51a52c0e45f29594c726f8f0bfea0 /schemaspy
parent	0c79ae99713e6d4d6d31bd621a949617ebfe503a (diff)
download	cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.tar.gz cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.tar.bz2 cashless2ecash-8d788b2b6a319deef49f267b8966bfe226bcbc20.zip