create table .enriched ( "tradeId" numeric(20) not null constraint pk_enriched primary key, order_orderid numeric(20), order_tradableinstrumentid numeric(20), order_accountid numeric(10), order_senderid numeric(10), order_createdat timestamp with time zone, order_boundtoorderid numeric(20), order_isbuyorder numeric(1), order_iscloseorder numeric(1), order_isactivated boolean, order_ordertype numeric(1), order_price numeric(20, 8), order_amount numeric(20, 8), order_isdayorder numeric(1), order_executedat timestamp with time zone, order_brokercomment text, order_closecomment text, order_routeid numeric(10), order_updatetime timestamp with time zone, order_troffset numeric(17, 7), order_ordergroupid numeric(20), order_filledamount numeric(20, 8), order_averagefilledprice numeric(20, 8), order_masterorderid numeric(20), order_price2 numeric(20, 8), order_expiredate timestamp with time zone, order_createdbyuserid numeric(10), order_positionid numeric(20), order_orderstatus numeric(2), order_isautotrade boolean, order_terminaltype numeric(4), order_ismarketmaker boolean, order_clientorderid text, order_averagefilledcrossprice numeric(20, 8), order_iswasmanual boolean, order_disclosedquantity numeric(20, 8), order_sltptrigger numeric(1), order_slprice numeric(20, 8), order_sllimitprice numeric(20, 8), order_slpricetype numeric(1), order_slexpireat timestamp with time zone, order_sltrigger numeric(1), order_tpprice numeric(20, 8), order_tppricetype numeric(1), order_tpexpireat timestamp with time zone, order_tptrigger numeric(1), order_remotehost text, order_tradingmode numeric(1), order_tradingsignalid numeric(20), order_poaid numeric(10), order_exposureprice numeric(20, 8), order_orderalgorithm numeric(2), order_receivedby numeric(2), order_enoughmarginequity boolean, order_omnibusname text, order_execvenue text, order_caexecutionid numeric(10), order_stopout boolean, order_fixgatewayid numeric(10), order_strategyid text, order_clientpanelid numeric(3), position_posindex numeric(20), position_positionid numeric(20), position_tradeid numeric(20), position_avg_price numeric(20, 8), position_crossprice numeric(20, 8), position_lasttime timestamp with time zone, position_amount numeric(20, 8), position_isbuy boolean, position_opentradeid numeric(20), position_settlementprice numeric(20, 8), position_settlementcrossprice numeric(20, 8), position_ordergroupid numeric(20), position_tradingmode numeric(1), position_brokercomment text, position_isautotrade boolean, position_terminaltype numeric(4), position_routeid numeric(10), position_tradableinstrumentid numeric(20), position_accountid numeric(10), position_exposureprice numeric(20, 8), position_lastmodified timestamp with time zone, position_superpositionid numeric(20), position_omnibusname text, position_tmlastupd timestamp with time zone, position_execvenue text, position_tramount numeric(20, 8), position_optionexercisestatus numeric(1), position_optionexercisereqdate timestamp with time zone, position_caexecutionid numeric(10), position_caid numeric(20), position_catype numeric(10), position_uploadedamount numeric(20, 8), position_strategyid text, trade_tradeid numeric(20), trade_countertradeid numeric(20), trade_orderid numeric(20), trade_extorderid numeric(20), trade_externalid text, trade_routeid numeric(10), trade_isbuy numeric(1), trade_time timestamp with time zone, trade_price numeric(20, 8), trade_amount numeric(20, 8), trade_crossprice numeric(20, 8), trade_isremoved boolean, trade_comments text, trade_instrumentname text, trade_extprice numeric(20, 8), trade_valuedate timestamp with time zone, trade_exchange text, trade_accountcrossprice numeric(20, 8), trade_counterorderid numeric(20), trade_poaid numeric(10), trade_orderalgorithm numeric(2), trade_accountid numeric(10), trade_tradableinstrumentid numeric(20), trade_tradingmode numeric(1), trade_receivedby numeric(2), trade_islocal boolean, trade_lastmodified timestamp with time zone, trade_omnibusname text, trade_execvenue text, trade_caexecutionid numeric(10) ); create index ix_enriched_orderid on .enriched (order_orderid); create index ix_enriched_tradeid on .enriched (trade_tradeid); create index ix_enriched_tradeid_accountid on .enriched (trade_tradeid, trade_accountid); create index ix_enriched_opentradeid_accountid on .enriched (position_opentradeid, position_accountid); create index ix_enriched_positionid on .enriched (position_positionid); create index ix_enriched_positionid_isclose on .enriched (position_positionid, order_iscloseorder); create trigger trg_trades_summary_from_enriched_insert after insert on .enriched referencing new table new_table execute procedure .sync_trades_summary_from_enriched_insert(); create trigger trg_trades_summary_from_enriched_update after update on .enriched referencing new table new_table execute procedure .sync_trades_summary_from_enriched_update();