diff options
| -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 293023ed..5ae5e0dd 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -334,6 +334,14 @@ CREATE TABLE bbg_markit_mapping( GRANT ALL ON bbg_markit_mapping to serenitas_user;
+CREATE TABLE basket_constituents(
+ company_id integer,
+ seniority sen,
+ basketid integer REFERENCES index_version,
+ weight float,
+ FOREIGN KEY (company_id, seniority) REFERENCES bbg_iisuers,
+ PRIMARY KEY (company_id, seniority, basket_id));
+
CREATE TABLE IF NOT EXISTS cds_quotes(
Date Date,
curve_ticker text,
|