diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 7460da1e..6f49d944 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -343,13 +343,14 @@ CREATE TABLE cusip_ref( bloomberg_ticker text, dealname varchar(10), tranche text, - pari-passu_tranches text[], + paripassu_tranches text[], Orig_Balance float, Orig_Moody text, Orig_Attach float, Orig_Detach float, Floater_Index text, - Spread float); + Spread float, + type text); CREATE TABLE cusip_update( Cusip varchar(9) REFERENCES cusip_ref, @@ -363,8 +364,8 @@ CREATE TABLE cusip_update( PRIMARY KEY(cusip, updatedate)); CREATE OR REPLACE VIEW cusip_universe AS - SELECT a.*, b.curr_balance, b.coupon, b.curr_moody, b.curr_attach, b.curr_detach, b.subordination, - b.thickness, b.updatedate FROM cusip_ref a + SELECT a.*, b.curr_balance, b.factor, b.coupon, b.curr_moody, b.curr_attach, b.curr_detach, + b.updatedate FROM cusip_ref a JOIN cusip_update b USING (cusip); CREATE OR REPLACE VIEW latest_clo_universe AS |