diff options
Diffstat (limited to 'sql/et_tables.sql')
| -rw-r--r-- | sql/et_tables.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index c5ef2354..9f109772 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -354,7 +354,8 @@ CREATE TABLE cusip_ref( Orig_Detach float, Floater_Index text, Spread float, - type text + type text, + figi text, UNIQUE (Cusip, dealname)); CREATE TABLE cusip_update( @@ -366,7 +367,7 @@ CREATE TABLE cusip_update( Curr_Attach float, Curr_Detach float, updatedate date, - PRIMARY KEY(cusip, updatedate)); + PRIMARY KEY(cusip_id, updatedate)); CREATE OR REPLACE VIEW cusip_universe AS SELECT a.cusip, a.isin, a.bloomberg_ticker, a.dealname, a.tranche, |