[GNUnet-SVN] [libeufin] branch master updated: DB schema for Ebics 'subscribers'.

[gnunet]

This is an automated email from the git hooks/post-receive script.

marcello pushed a commit to branch master
in repository libeufin.

The following commit(s) were added to refs/heads/master by this push:
     new 6d5d496  DB schema for Ebics 'subscribers'.
6d5d496 is described below

commit 6d5d4960e19d0a765786dfee86b82258d3358902
Author: Marcello Stanisci <address@hidden>
AuthorDate: Thu Sep 26 14:48:25 2019 +0200

    DB schema for Ebics 'subscribers'.
---
 src/main/kotlin/tech/libeufin/DB.kt | 47 +++++++++++++++++++++++++++++++++++--
 1 file changed, 45 insertions(+), 2 deletions(-)

diff --git a/src/main/kotlin/tech/libeufin/DB.kt 
b/src/main/kotlin/tech/libeufin/DB.kt
index c7b8a2d..1bba1d2 100644
--- a/src/main/kotlin/tech/libeufin/DB.kt
+++ b/src/main/kotlin/tech/libeufin/DB.kt
@@ -62,8 +62,6 @@ enum class KeyStates {
     RELEASED
 }
 
-
-
 /**
  * This table information *not* related to EBICS, for all
  * its customers.
@@ -72,9 +70,54 @@ object Customer: IntIdTable() {
     val customerId: Column<String> = varchar(
         "customerId",
         CUSTOMER_ID_MAX_LENGTH).primaryKey()
+    val ebicsUserId = reference("ebicsUserId", EbicsUsers)
+}
+
+/**
+ * The following three tables define IDs that make a EBCIS
+ * 'subscriber' exist.  Each EBICS subscriber is the tuple:
+ *
+ * - UserID, the human who is performing a EBICS task.
+ * - PartnerID, the legal entity that signed a formal agreement with the 
financial institution.
+ * - SystemID, (optional) the machine that is handling the EBICS task on 
behalf of the UserID.
+ */
+
+/**
+ * Table for UserID.
+ */
+object EbicsUsers: IntIdTable() {
+    // For simplicity, this entity is implemented by the
+    // 'id' field provided by the table constructor by default.
+}
+
+/**
+ * Table for UserID.
+ */
+object EbicsPartners: IntIdTable() {
+    // For simplicity, this entity is implemented by the
+    // 'id' field provided by the table constructor by default.
+}
+
+/**
+ * Table for UserID.
+ */
+object EbicsSystems: IntIdTable() {
+    // For simplicity, this entity is implemented by the
+    // 'id' field provided by the table constructor by default.
 }
 
 /**
+ * Subscribers table.  This table associates users with partners
+ * and systems.  Each value can appear multiple times in the same column.
+ */
+object EbicsSubscribers: IntIdTable() {
+    val userId = reference("UserId", EbicsUsers)
+    val partnerId = reference("PartnerId", EbicsPartners)
+    val systemId = reference("SystemId", EbicsSystems)
+}
+
+
+/**
  * This table maps customers with EBICS subscribers.
  */
 object CustomerSubscriberMap: IntIdTable(){

-- 
To stop receiving notification emails like this one, please contact
address@hidden.