diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index fa570fa7..efa6b1c0 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -1052,3 +1052,11 @@ CREATE TABLE defaulted( seniority sen,
PRIMARY KEY (id, seniority)
FOREIGN KEY (id, seniority) REFERENCES bbg_issuers)
+
+CREATE TYPE cash_rate AS ENUM('FED_FUND', '1M_LIBOR', '3M_LIBOR');
+
+CREATE TABLE rates(
+ date date NOT NULL,
+ name cash_rate NOT NULL,
+ rate float not NULL
+ PRIMARY KEY (date, name));
|