[libeufin] branch master updated: SQL comments

[gnunet]

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

ms pushed a commit to branch master
in repository libeufin.

The following commit(s) were added to refs/heads/master by this push:
     new 94c8af5b SQL comments
94c8af5b is described below

commit 94c8af5b824e81533363763955f2208252bfdb67
Author: MS <ms@taler.net>
AuthorDate: Thu Aug 3 15:23:53 2023 +0200

    SQL comments
---
 database-versioning/new/nexus-0001-refactor.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/database-versioning/new/nexus-0001-refactor.sql 
b/database-versioning/new/nexus-0001-refactor.sql
index 9df5877e..60b0ce9a 100644
--- a/database-versioning/new/nexus-0001-refactor.sql
+++ b/database-versioning/new/nexus-0001-refactor.sql
@@ -92,6 +92,8 @@ CREATE TABLE IF NOT EXISTS offered_bank_accounts
 
 -- start of: background tasks
 
+
+-- Accounts for the background tasks that were created by the user.
 CREATE TABLE IF NOT EXISTS nexus_scheduled_tasks 
   (id BIGSERIAL PRIMARY KEY
   ,resource_type TEXT NOT NULL
@@ -108,13 +110,22 @@ CREATE TABLE IF NOT EXISTS nexus_scheduled_tasks
 
 -- start of: facades management
 
+-- Basic information about the facade state.
 CREATE TABLE IF NOT EXISTS facade_state 
   (id BIGSERIAL PRIMARY KEY
   ,bank_account TEXT NOT NULL
   ,bank_connection TEXT NOT NULL
   ,currency TEXT NOT NULL
+  -- The following column informs whether this facade
+  -- wants payment data to come from statements (usually
+  -- once a day when the payment is very likely settled),
+  -- reports (multiple times a day but the payment might
+  -- not be settled).
   ,reserve_transfer_level TEXT NOT NULL
   ,facade BIGINT NOT NULL
+  -- The following column points to the last transaction
+  -- that was processed already by the facade.  It's used
+  -- along the facade-specific ingestion.
   ,highest_seen_message_serial_id BIGINT DEFAULT 0 NOT NULL
   ,CONSTRAINT fk_facadestate_facade_id FOREIGN KEY (facade) REFERENCES 
facades(id) ON DELETE CASCADE ON UPDATE RESTRICT
   );

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.