diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index ac509a9b..3f6792e1 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -939,14 +939,15 @@ CREATE TABLE JPY_curves( effective_date date PRIMARY KEY,
curve bytea);
-CREATE TYPE rate_type AS ENUM('OIS', 'FUT', 'SWP', 'DEP', 'IND', 'BASIS');
+CREATE TYPE rate_type AS ENUM('OIS', 'FUT', 'SWP', 'DEP', 'IND', 'BASIS', 'SFR_FUT');
CREATE TABLE bbg_rate_tickers(
bbg_ticker text PRIMARY KEY,
quote_type rate_type NOT NULL,
currency curr NOT NULL,
tenor text,
- start_date date
+ start_date date,
+ end_date date
);
CREATE TABLE bbg_rate_quotes(
|
