diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4038ada5..6cec10ff 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4823,11 +4823,11 @@ CREATE TABLE jtd_risks ( CREATE TYPE risk_type AS ENUM ('HY_EQUIV', 'PNL'); CREATE TABLE irs_tickets ( - bbg_ticket_id text PRIMARY KEY, + bbg_ticket_id text NOT NULL, "match" text NULL, side text NULL, "security" text NULL, - quantity int8 NULL, + quantity float8 NULL, price_dec float8 NULL, cp float8 NULL, stp_status text NULL, @@ -4843,11 +4843,11 @@ CREATE TABLE irs_tickets ( figi text NULL, cusip text NULL, mat_dt date NULL, - cclear_usiuti text NULL, cclear_usiuti text NULL, - account text NULL, - client_fcm text NULL, - effectdt date NULL, + account text NOT NULL, + client_fcm text NOT NULL, + effectdt date NULL, + CONSTRAINT irs_tickets_pk PRIMARY KEY (bbg_ticket_id, account, client_fcm) ); |