diff options
| -rw-r--r-- | sql/dawn.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index fad67a47..8c73ee04 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3057,3 +3057,38 @@ CREATE TABLE public.fx_tickets ( "Country of Membership" text NULL, CONSTRAINT fx_tickets_pk PRIMARY KEY (bbg_ticket_id) ); + + +CREATE TABLE public.irs ( + id serial4 NOT NULL, + dealid text NULL GENERATED ALWAYS AS ('IRS_'::text || id::text) STORED, + lastupdate timestamp NULL DEFAULT now(), + "action" public."action" NOT NULL, + folder text NOT NULL, + custodian text NULL, + cashaccount text NULL, + cp_code varchar(12) NOT NULL, + trade_date date NOT NULL, + settle_date date NOT NULL, + effective_date date NOT NULL, + maturity_date date NOT NULL, + buysell bool NOT NULL, + bbg_ticker varchar(32) NOT NULL, + payreceive bool NOT NULL, + fixed_amount float8 NOT NULL, + fixed_rate float8 NOT NULL, + fixed_daycount text NOT NULL, + fixed_payment_freq text NOT NULL, + fixed_currency text NOT NULL, + float_amount float8 NOT NULL, + float_daycount text NOT NULL, + float_payment_freq text NOT NULL, + float_index text NOT NULL, + float_currency text NOT NULL, + initial_margin_percentage float8 NULL, + float_fixing_freq text NOT NULL, + pay_interest_calc_method text NOT NULL, + clearing_facility varchar(12) NULL DEFAULT NULL::character varying, + swaptype text NOT NULL, + "fund" public."fund" NOT NULL DEFAULT 'SERCGMAST'::fund +); |