diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 7 | ||||
| -rw-r--r-- | sql/et_tables.sql | 5 |
2 files changed, 9 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e2b430a5..95468dac 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -596,7 +596,12 @@ CREATE TABLE securities(identifier varchar(12) PRIMARY KEY, asset_class asset_class, paid_down date default 'Infinity', start_accrued_date date, - issuer text); + issuer text, + reset_index text, + coupon_type text, + payment_day integer, + issue_date date, + figi text); ALTER TABLE securities OWNER TO dawn_user; 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, |