diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 797468cf..bc430547 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -150,7 +150,7 @@ CREATE TABLE clo_universe ( "Deal Next Pay Date" date, "Reinv End Date" date, "Latest Update" date, - "Deal Cusip List" text, + "Deal Cusip List" text[], PaidDown date, PRIMARY KEY (dealname, "Latest Update") ); @@ -187,11 +187,8 @@ CREATE VIEW latest_clo_universe AS GRANT ALL ON latest_clo_universe TO et_user; -CREATE TABLE dealcusipmapping ( - dealname varchar(10), - Cusip varchar(9), - PRIMARY KEY(Cusip) -); +CREATE VIEW dealcusipmapping AS + SELECT dealname, unnest("Deal Cusip List") AS Cusip from latest_clo_universe; GRANT ALL ON dealcusipmapping TO et_user; |