diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index cfa530fa..29acc883 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3325,20 +3325,6 @@ CREATE TABLE trs ( globeop_id int null, ); - -CREATE TABLE strat_cash_realloc ( - id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, - dealid text NULL GENERATED ALWAYS AS ('STRATCSH'::text || id::text) STORED, - "portfolio" "portfolio" NULL, - folder "strategy_dirty" NOT NULL, - trade_date date NOT NULL, - amount float8 NOT NULL, - "currency" "currency" NOT NULL, - "fund" "fund" NOT NULL DEFAULT 'BOWDST'::fund, - cash_account text NOT NULL, - CONSTRAINT strat_cash_realloc_un UNIQUE (folder, trade_date, amount, currency, fund, cash_account) -); - CREATE TYPE "instrument_type" AS ENUM ( 'IRS', 'CDS', |
