diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index abffd870..baaf386e 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4198,13 +4198,13 @@ CREATE TABLE iams ( id int4 NOT NULL GENERATED ALWAYS AS IDENTITY, dealid varchar(28) NULL GENERATED ALWAYS AS ((('IAM_'::text || id::text))) STORED, trade_date date NOT NULL, - strategy strategy NOT NULL, + folder strategy NOT NULL, broker text NOT NULL, maturity date NULL, amount numeric NOT NULL, - currency currency, - offset bool NOT NULL, + currency currency NOT NULL, + is_offset bool NOT NULL, uploaded bool NOT NULL, fund fund NOT NULL, - CONSTRAINT iams_pk PRIMARY KEY (trade_date, strategy, broker, currency, offset, fund) + CONSTRAINT iams_pk PRIMARY KEY (trade_date, strategy, broker, currency, is_offset, fund) );
\ No newline at end of file |