diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 99 |
1 files changed, 0 insertions, 99 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 302edd3d..dfafbae9 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3455,105 +3455,6 @@ CREATE table isda_agreement_dates( CONSTRAINT isda_agreement_dates_key UNIQUE (fund, counterparty, agreement_date), ) - -CREATE TABLE citco_stax ( - "index" text NULL, - "fund" text NULL, - trader text NULL, - "prime_broker/clearing_broker" text NULL, - "strategy" text NULL, - citco_security_id text NULL, - symbol text NULL, - cusip text NULL, - isin text NULL, - sedol text NULL, - ric text NULL, - bloomberg_code text NULL, - "long/short" text NULL, - open_trade_date date NULL, - open_settle_date date NULL, - close_trade_date date NULL, - close_settle_date date NULL, - opening_aexeo_trade_id text NULL, - closing_aexeo_trade_id text NULL, - quantity text NULL, - base_price text NULL, - base_market_value text NULL, - base_unit_cost text NULL, - base_total_cost text NULL, - base_commissions text NULL, - base_sec_fees text NULL, - "report_date_base_realized_p&l" text NULL, - "report_date_base_unrealized_p&l" text NULL, - "mtd_base_realized_p&l" text NULL, - "mtd_base_unrealized_p&l" text NULL, - "ytd_base_realized_p&l" text NULL, - "ytd_base_unrealized_p&l" text NULL, - base_ccy text NULL, - issue_price text NULL, - issue_market_value text NULL, - issue_unit_cost text NULL, - issue_total_cost text NULL, - issue_commissions text NULL, - issue_sec_fees text NULL, - "issue_realized_p&l" text NULL, - "issue_unrealized_p&l" text NULL, - "mtd_issue_realized_p&l" text NULL, - "mtd_issue_unrealized_p&l" text NULL, - "ytd_issue_realized_p&l" text NULL, - "ytd_issue_unrealized_p&l" text NULL, - issue_ccy text NULL, - security_description text NULL, - security_asset_name text NULL, - security_asset_class text NULL, - maturity_date date NULL, - underlying_citco_security_id text NULL, - underlying_symbol text NULL, - underlying_cusip text NULL, - underlying_isin text NULL, - underlying_sedol text NULL, - underlying_bloomberg_code text NULL, - underlying_security_description text NULL, - underlying_security_asset_name text NULL, - underlying_security_asset_class text NULL, - opening_aexeo_order_id text NULL, - closing_aexeo_order_id text NULL, - region text NULL, - exchange text NULL, - exchange_symbol text NULL, - country_code text NULL, - trade_ccy text NULL, - industry text NULL, - industry_sector text NULL, - issue_trade_acquistion_interest text NULL, - base_trade_acquistion_interest text NULL, - spot_fx_rate text NULL, - standard_strategy text NULL, - client_instrument_id text NULL, - bond_class text NULL, - init_exec_broker text NULL, - liqd_exec_broker text NULL, - "option_type" text NULL, - "option_put/call_flag" text NULL, - option_strike_price text NULL, - option_expiration_date text NULL, - contract_size text NULL, - coupon_rate text NULL, - bloomberg_real_time_code text NULL, - bond_abbrev text NULL, - underlying_ric text NULL, - occ_code text NULL, - underlying_occ_code text NULL, - fix_id text NULL, - ops_notes text NULL, - trader_notes text NULL, - orig_date date NULL, - period_end_date date NULL, - knowledge_date timestamp NULL, - "row" int NULL, - CONSTRAINT citco_stax_pk PRIMARY KEY (period_end_date, "row") -); - CREATE OR REPLACE VIEW tranche_risk_isosel AS SELECT tranche_risk.date, tranche_risk.tranche_id AS trade_id, |