aboutsummaryrefslogtreecommitdiffstats
path: root/sql/serenitasdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/serenitasdb.sql')
-rw-r--r--sql/serenitasdb.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index dc383a5c..3f7cb751 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -909,6 +909,15 @@ CREATE TABLE JPY_curves(
effective_date date PRIMARY KEY,
curve bytea);
+CREATE TABLE cds_curves(
+ date date,
+ id integer,
+ seniority sen,
+ curve bytea,
+ FOREIGN KEY (id, seniority) REFERENCES bbg_issuers
+)
+
+
CREATE TABLE USD_swap_fixings(
fixing_date date PRIMARY KEY,
"1y" numeric(5, 3),