diff options
| -rw-r--r-- | sql/dawn.sql | 58 |
1 files changed, 29 insertions, 29 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2de5f29d..2b6a4f04 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3099,33 +3099,33 @@ CREATE TYPE "interest_calc_method" AS ENUM ( CREATE TABLE public.trs ( - id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, - dealid text NULL GENERATED ALWAYS AS ('TRS'::text || id::text) STORED, - "fund" "fund" NOT NULL DEFAULT 'SERCGMAST'::fund, - "portfolio" "portfolio" NOT NULL, - folder "cds_strat" NOT NULL, - cash_account text NOT NULL REFERENCES accounts2(cash_account) ON UPDATE CASCADE, - 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, - funding_index cash_rate NOT NULL DEFAULT 'SOFRRATE'::cash_rate, - buysell bool NOT NULL, - underlying_security varchar(32) NOT NULL, - price float8 NOT NULL, - accrued float8 NOT NULL, - funding_freq frequency NOT NULL, - funding_daycount frequency NOT NULL, - funding_payment_roll_convention bus_day_convention NOT NULL, - funding_arrears bool NOT NULL, - asset_freq frequency NOT NULL, - asset_daycount frequency NOT NULL, - asset_payment_roll_convention bus_day_convention NOT NULL, - initial_margin_percentage float8 NOT NULL, - notional float8 NOT NULL, - "currency" "currency" NOT NULL DEFAULT 'USD'::currency, - interest_calc_method interest_calc_method NOT NULL, - compound_avg_frequency frequency NOT NULL, - fixing_frequency frequency NOT NULL, - cpty_id text NULL + id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, + dealid text NULL GENERATED ALWAYS AS ('TRS'::text || id::text) STORED, + "fund" "fund" NOT NULL DEFAULT 'SERCGMAST'::fund, + "portfolio" "portfolio" NOT NULL, + folder "cds_strat" NOT NULL, + cash_account text NOT NULL REFERENCES accounts2(cash_account) ON UPDATE CASCADE, + 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, + funding_index cash_rate NOT NULL DEFAULT 'SOFRRATE'::cash_rate, + buysell bool NOT NULL, + underlying_security varchar(32) NOT NULL, + price float8 NOT NULL, + accrued float8 NOT NULL, + funding_freq frequency NOT NULL, + funding_daycount frequency NOT NULL, + funding_payment_roll_convention bus_day_convention NOT NULL, + funding_arrears bool NOT NULL, + asset_freq frequency NOT NULL, + asset_daycount frequency NOT NULL, + asset_payment_roll_convention bus_day_convention NOT NULL, + initial_margin_percentage float8 NOT NULL, + notional float8 NOT NULL, + "currency" "currency" NOT NULL DEFAULT 'USD'::currency, + interest_calc_method interest_calc_method NOT NULL, + compound_avg_frequency frequency NOT NULL, + fixing_frequency frequency NOT NULL, + cpty_id text NULL );
\ No newline at end of file |