diff options
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index a356b89f..44bfe349 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3179,7 +3179,7 @@ CREATE TYPE exercise_type AS ENUM ('European', 'American'); CREATE TYPE equity_option_strat AS ENUM ('VOLRV'); -CREATE TABLE equity_options2 ( +CREATE TABLE equity_options ( id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, dealid varchar(28) NULL GENERATED ALWAYS AS ((('EQOPT_'::text || id::text))) STORED, fund fund NOT NULL, @@ -3193,9 +3193,9 @@ CREATE TABLE equity_options2 ( settle_date date NOT NULL, expiration_date date NOT NULL, buysell bool NOT NULL, - notional float NOT NULL, + quantity float NOT NULL, bbg_ticker text NOT NULL, - option_type equity_option_type NOT NULL, + putcall bool NOT NULL, strike float NOT NULL, exercise_type exercise_type NOT NULL, price float NOT NULL, |