diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index efa6b1c0..1d041992 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -1051,7 +1051,7 @@ CREATE TABLE defaulted( recovery float,
seniority sen,
PRIMARY KEY (id, seniority)
- FOREIGN KEY (id, seniority) REFERENCES bbg_issuers)
+ FOREIGN KEY (id, seniority) REFERENCES bbg_issuers);
CREATE TYPE cash_rate AS ENUM('FED_FUND', '1M_LIBOR', '3M_LIBOR');
@@ -1060,3 +1060,8 @@ CREATE TABLE rates( name cash_rate NOT NULL,
rate float not NULL
PRIMARY KEY (date, name));
+
+
+CREATE TABLE dtcc_corrections(
+ dissemination_id bigint,
+ correction bytea)
|