1 files changed, 8 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 253e516c..d62618b1 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -2190,3 +2190,11 @@ create table id_mapping(
        full_globeop_id text GENERATED ALWAYS AS (trade_type||lpad(globeop_id::text, 6, '0')|| 'K00SCLMA') stored,
        PRIMARY KEY (date, trade_type, serenitas_id)
 );
+
+CREATE TABLE tranche_cashflows(
+       date date NOT NULL,
+       tranche_id integer NOT NULL,
+       principal float,
+       accrued float,
+       PRIMARY KEY (date, tranche_id)
+);