diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 93dcc43b..8e1c32eb 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2663,4 +2663,28 @@ CREATE TABLE public.bond_tickets ( ); CREATE INDEX ix_bond_tickets_index ON public.bond_tickets USING btree (bbg_ticket_id); - +CREATE TABLE public.cds_tickets ( + bbg_ticket_id text NOT NULL, + "Match" text NULL, + "Side" text NULL, + "Security" text NULL, + "Quantity" int8 NULL, + "Price (Dec)" float8 NULL, + "CP" text NULL, + "STP Status" text NULL, + "Trade Dt" text NULL, + "SetDt" text NULL, + "Curncy" text NULL, + "Principal" float8 NULL, + "Net" float8 NULL, + "Acc Int" float8 NULL, + "Account" text NOT NULL, + "Client FCM" text NOT NULL, + "Block Status" text NULL, + "Red Code" text NULL, + "Cusip" text NULL, + "Brkr" text NULL, + "Mat Dt" text NULL, + "Coupon" int8 NULL, + CONSTRAINT cds_tickets_pk PRIMARY KEY (bbg_ticket_id, "Account") +); |