diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 469c5865..fa570fa7 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -79,9 +79,10 @@ CREATE TABLE index_maturity_markit( );
CREATE OR REPLACE VIEW risk_num_per_quote AS
- SELECT a.*, b.trancheupfrontmid, b.trancherunningmid, b.indexrefprice, b.indexrefspread,
- b.tranchedelta, b.quotesource
- FROM risk_numbers a
+ SELECT a.*, b.index, b.series, b.tenor, b.attach, b.detach,
+ b.trancheupfrontmid, b.trancherunningmid, b.indexrefprice, b.indexrefspread,
+ b.tranchedelta, b.quotesource, b.quotedate
+ FROM tranche_risk a
JOIN tranche_quotes b ON a.tranche_id = b.id;
CREATE OR REPLACE VIEW index_desc AS
|