diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 21198bf7..06b8572d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3080,13 +3080,13 @@ CREATE TABLE fx_tickets ( CREATE TABLE irs ( id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, - dealid text NULL GENERATED ALWAYS AS ('IRS_'::text || id::text) STORED, + dealid text NULL GENERATED ALWAYS AS ('IRS_'::text || id::text) STORED, "fund" "fund" NOT NULL DEFAULT 'SERCGMAST'::fund, "portfolio" "portfolio" NOT NULL, - folder "cds_strat" NOT NULL, + folder "strategy" NOT NULL, cash_account text NOT NULL REFERENCES accounts2(cash_account) ON UPDATE CASCADE, - cp_code varchar(12) NOT NULL, - trade_date date NOT NULL, + cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, + trade_date date NOT NULL, effective_date date NOT NULL, maturity_date date NOT NULL, payreceive bool NOT NULL, @@ -3105,7 +3105,7 @@ CREATE TABLE irs ( pay_interest_calc_method interest_calc_method NOT NULL, clearing_facility clearing_cp NOT NULL DEFAULT 'LCH-LTD'::clearing_cp, swap_type swap_type NOT NULL, - cleared_trade_id text NULL, + cleared_trade_id text NULL ); CREATE TYPE "bbg_code_type" AS ENUM ( |