diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 99 |
1 files changed, 99 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 480a0da8..1aca1cd6 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3458,3 +3458,102 @@ CREATE table isda_agreement_dates( agreement_date date not null, 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") +);
\ No newline at end of file |