 |
 |
 |
 |
Database
- Import Tables
- Support Tables
- Market Tables
- Trading Tables
- Utility Tables
- Lookup Tables
- Message Replay Tables
Import Tables
| tmp_bo_data | Import of C21 Market Data |
| tmp_commodity_list | Import of C21 Market Data |
| tmp_contract_list | Import of C21 Market Data |
| tmp_download_record | Import of C21 Market Data |
| tmp_letter_list | Import of C21 Market Data |
| tmp_trading_date | Import of C21 Market Data |
Support Tables
| C_interest_rate | Performs No Useful Function (Options Parameter) |
| C_margin_rate | Performs No Useful Function (C21 Performs Margin Requirements) |
| C_order_action_limit | Legend |
| C_order_type | What Orders Can Be Supported (Limit and Cross) |
| C_member | Membership Firms and indicator of Clearer |
| C_member_trading_right | Legend |
| C_user | Legend |
| C_trader_right | What rights a User may have (see C_right_type) |
| C_user_right | Legend |
| C_user_reasonability | Legend |
| C_user_group | Legend |
| C_account | Legend |
| C_account_position_limit | Legend |
| C_account_rights | Legend |
| C_account_user | Legend |
| C_user_message | A means of passing text between Traders and Customer Service (Under utilised) |
| C_terminal | Protects Server From Clients Connecting Via Unknown Machines |
Market Tables
| C_decimal_format | Supports Different Limit Price Masks (Not Really Needed) |
| C_market_type | Password Dialog and Firm Contract Rights. Loose Grouping |
| C_delivery_month | Various Expressions To Describe The Months On The Yield Curve |
| C_contract | Outright Items Within The Market (Contains a number of deprecated columns) |
| C_contract_month | Legend |
| C_contract_volume | Legend |
| C_series | Legend |
| C_spread_stats | Legend |
| C_daily_stats | Legend |
| C_spread_contract | Legend |
| C_spread_contract_leg | Legend |
| C_spread_series_leg | Legend |
| C_trade_limit | Legend |
| C_contract_session | Legend |
| C_contract_session_cancel | Legend |
| C_settlement_config | Performs No Useful Function (C21 and Boil Provide Settlement Prices) |
| C_settlement_price | Performs No Useful Function (C21 and Boil Provide Settlement Prices) |
Trading Tables
| C_order | Maintains The History Of Each Order |
| C_order_detail | Maintains The Leg Count Per Order. Outright:one Spread:two |
| C_ets_spread_trade | Legend |
| C_ets_trade | Leg Exploded Traded Orders |
| C_ets_trade_allocation | Legend |
Utility Tables
| C_tsi_systems | Details The Client And Server Processes |
| C_system_dates | Legend |
| C_system_times | Legend |
| C_user_logon_history | Legend |
| C_holidays | Empty Bank Holiday Table. (Close to deprecation) |
Lookup Tables
| C_right_type | User: Trade,Firm,Super,View,EditAcc; Some unused rights as well |
| C_trade_type | Aimed more at supporting external trade imports [X or T] |
| C_contract_type | Support For 'F' 'O' 'P'ut 'C'all. (Not really right but used in c_daily_stats for options) |
| C_audit_event_type | Legend |
| C_audit_message_name | Legend |
Message Replay Tables
| C_audit_message | Message Replay Service. Record Of TCP/IP Messages passed to the Central Server |
| C_audit_sub_message | Message Replay Service (The Repeated Part Of A Message) |
|
|
|
|
 |