diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 844f1e40..edac65f7 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -77,6 +77,12 @@ CREATE TABLE index_maturity_markit( coupon integer,
);
+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_new a
+ JOIN tranche_quotes b ON a.tranche_id = b.id;
+
CREATE OR REPLACE VIEW index_desc AS
SELECT b.*, a.tenor, a.maturity, a.coupon, a.issue_date
FROM index_maturity a
|