| C_account |
| EntityType | Dependent |
| Logical Table Name | C_account |
| Definition:MIKE | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_account_reference |
C_account_reference_t | NO | ||
| C_account_clearer |
C_member_no_t | NO | ||
| C_account_margin | C_price_t | YES | ||
| C_account_name | C_account_name_t | YES | ||
| C_account_full_rights | C_flag_t | YES | ||
| C_account_position_limit | C_flag_t | YES | ||
| C_account_tradeable | C_flag_t | YES | ||
| C_account_splittable | C_flag_t | YES | ||
| C_account_cti | C_account_cti_t | YES | ||
| C_fut_covers_short_opt | C_yesno_t | YES | ||
| C_back_fut_covers_short_opt | C_yesno_t | YES | ||
| C_further_opt_covers_short_opt | C_yesno_t | YES | ||
| C_skip_margin_check | C_yesno_t | YES | ||
| C_allow_view | CHAR(1) | YES | ||
| C_is_deleted | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_account_index | Alternate Key | C_account_reference,C_account_clearer |
| PK_C_account | PrimaryKey | C_account_reference,C_account_clearer |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_member | C_account | Identifying | C_account_clearer |
| C_account | C_account_user | Identifying | C_account_reference,C_account_clearer |
| C_account | C_account_position_limit | Identifying | C_account_reference,C_account_clearer |
| C_account | C_account_rights | Identifying | C_account_reference,C_account_clearer |
| C_account_position_limit |
| EntityType | Dependent |
| Logical Table Name | C_account_position_limit |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_account_reference |
C_account_reference_t | NO | ||
| C_account_clearer |
C_member_no_t | NO | ||
| C_commodity_no |
C_commodity_no_t | NO | ||
| C_short_put_limit | C_price_t | YES | ||
| C_short_call_limit | C_price_t | YES | ||
| C_long_future_limit | C_price_t | YES | ||
| C_short_future_limit | C_price_t | YES | ||
| C_is_deleted | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_account_position_limit_index | Alternate Key | C_account_reference,C_account_clearer,C_commodity_no |
| PK_C_account_position_limit | PrimaryKey | C_account_reference,C_account_clearer,C_commodity_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_account | C_account_position_limit | Identifying | C_account_reference,C_account_clearer |
| C_account_rights |
| EntityType | Dependent |
| Logical Table Name | C_account_rights |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_account_reference |
C_account_reference_t | NO | ||
| C_account_clearer |
C_member_no_t | NO | ||
| C_account_market_type_no |
C_market_type_no_t | NO | ||
| C_account_contract_no |
C_contract_no_t | NO | ||
| C_is_deleted | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_account_rights_index | Alternate Key | C_account_reference,C_account_clearer,C_account_market_type_no,C_account_contract_no |
| PK_C_account_rights | PrimaryKey | C_account_reference,C_account_clearer,C_account_market_type_no,C_account_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_market_type | C_account_rights | Identifying | C_account_market_type_no |
| C_account | C_account_rights | Identifying | C_account_reference,C_account_clearer |
| C_account_user |
| EntityType | Dependent |
| Logical Table Name | C_account_user |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_account_reference |
C_account_reference_t | NO | ||
| C_account_clearer |
C_member_no_t | NO | ||
| C_user_no |
C_user_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_account | PrimaryKey | C_account_reference,C_account_clearer,C_user_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user | C_account_user | Identifying | C_user_no |
| C_account | C_account_user | Identifying | C_account_reference,C_account_clearer |
| C_audit_event_type |
| EntityType | Independent |
| Logical Table Name | C_audit_event_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_type_no |
C_event_type_t | NO | ||
| C_type_name | C_type_name_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_audit_event_type | PrimaryKey | C_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_audit_event_type | C_user_logon_history | Identifying | C_event_type |
| C_audit_event_type | C_user_message | Identifying | C_event_type |
| C_audit_message |
| EntityType | Independent |
| Logical Table Name | C_audit_message |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_audit_msg_no |
C_audit_msg_no_t | NO | ||
| source_C_process_name | C_process_name_t | YES | ||
| destination_C_process_name | C_process_name_t | YES | ||
C_user_no |
C_user_no_t | YES | ||
| C_message_no | C_message_no_t | YES | ||
| C_sub_message_count | C_sub_message_count_t | YES | ||
| C_message_string | C_message_string_t | YES | ||
| C_message_log_datetime | C_message_log_datetime_t | YES | ||
| C_message_date | C_message_date_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_audit_message_index | Alternate Key | C_audit_msg_no |
| C_message_date_index | Inversion Entry | C_message_date |
| PK6 | PrimaryKey | C_audit_msg_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user | C_audit_message | Non-Identifying | C_user_no |
| C_audit_message | C_audit_sub_message | Identifying | C_audit_msg_no |
| C_audit_message_name |
| EntityType | Independent |
| Logical Table Name | C_audit_message_name |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_audit_msg_no |
C_audit_msg_no_t | NO | ||
| C_message_name | C_message_name_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_audit_message_name_idx | Alternate Key | C_audit_msg_no |
| PK7 | PrimaryKey | C_audit_msg_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_audit_sub_message |
| EntityType | Dependent |
| Logical Table Name | C_audit_sub_message |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_audit_msg_no |
C_audit_msg_no_t | NO | ||
| C_audit_sub_msg_no |
C_audit_sub_msg_no_t | NO | ||
| C_sub_message_string | C_sub_message_string_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_audit_sub_message_index | Alternate Key | C_audit_msg_no,C_audit_sub_msg_no |
| PK8 | PrimaryKey | C_audit_msg_no,C_audit_sub_msg_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_audit_message | C_audit_sub_message | Identifying | C_audit_msg_no |
| C_contract |
| EntityType | Independent |
| Logical Table Name | C_contract |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_no |
C_contract_no_t | NO | ||
| C_is_floor_traded | C_yesno_t | NO | ||
| C_decimal_format_no |
C_decimal_format_no_t | NO | ||
| C_sr_check | C_flag_t | NO | ||
| C_commodity_no | C_commodity_no_t | YES | ||
| C_contract_code | C_contract_code_t | YES | ||
| C_contract_name | C_contract_name_t | YES | ||
| C_generic_contract_code | C_generic_contract_code_t | YES | ||
| expiry_C_time | C_time_t | YES | ||
| C_tick_size | C_tick_size_t | YES | ||
| C_tick_value | C_tick_value_t | YES | ||
| C_open_close_interval | C_open_close_interval_t | YES | ||
| C_no_of_delivery_dates | C_no_of_delivery_dates_t | YES | ||
| C_no_of_consec_months | C_no_of_consec_months_t | YES | ||
| C_first_gap_month | C_first_gap_month_t | YES | ||
| C_number_of_gap_months | C_number_of_gap_months_t | YES | ||
| C_second_gap_month | C_first_gap_month_t | YES | ||
| C_number_of_second_gap_months | C_number_of_gap_months_t | YES | ||
| C_strikes_each_side | C_strikes_each_side_t | YES | ||
| at_the_money_C_price | C_price_t | YES | ||
| strike_size_C_price | C_price_t | YES | ||
| C_vendor_code | C_vendor_code_t | YES | ||
| C_physical_commodity | C_physical_commodity_t | YES | ||
| C_logical_commodity | C_logical_commodity_t | YES | ||
| C_trading_origin | C_trading_origin_t | YES | ||
| C_used_by_tsi | C_used_by_tsi_t | YES | ||
| C_contract_bitmap | C_contract_bitmap_t | YES | ||
| C_volume_granularity | C_volume_granularity_t | YES | ||
| C_is_ets_traded | C_is_ets_traded_t | YES | ||
| C_is_trs_upload | C_is_trs_upload_t | YES | ||
| C_is_trs_settlement_prices | C_is_trs_settlement_prices_t | YES | ||
| C_is_sent_to_vendors | C_is_sent_to_vendors_t | YES | ||
| C_is_spread_traded | C_is_spread_traded_t | YES | ||
| C_is_daily_stats | C_is_daily_stats_t | YES | ||
| C_is_active_on_open | C_flag_t | YES | ||
| C_deviation_of_order_price | C_price_t | YES | ||
| C_deviation_of_dollar_value | C_price_t | YES | ||
| C_prs_contract_code | C_flag_t | YES | ||
| C_exchange_no | C_exchange_no_t | YES | ||
| C_implied_mode | C_implied_mode_t | YES | ||
| C_strike_decimal_format_no |
C_decimal_format_no_t | YES | ||
| C_generate_sps | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_contract_index | Alternate Key | C_contract_no |
| vendor | Inversion Entry | C_vendor_code |
| AK_CONTRACT_NAME | Alternate Key | C_contract_name |
| PK9 | PrimaryKey | C_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_decimal_format | C_contract | Non-Identifying | C_decimal_format_no |
| C_decimal_format | C_contract | Non-Identifying | C_strike_decimal_format_no |
| C_contract | C_contract_month | Identifying | C_contract_no |
| C_contract | C_contract_session | Identifying | C_contract_no |
| C_contract | C_margin_rate | Identifying | C_contract_no |
| C_contract | C_series | Non-Identifying | C_contract_no |
| C_contract | C_settlement_config | Identifying | C_contract_no |
| C_contract | C_spread_contract_leg | Non-Identifying | C_contract_no |
| C_contract_month |
| EntityType | Dependent |
| Logical Table Name | C_contract_month |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_no |
C_contract_no_t | NO | ||
| C_delivery_month_no |
C_delivery_month_no_t | NO | ||
| C_delivery_day_no |
C_delivery_day_no_t | NO | ||
| C_series_status | C_series_status_t | YES | ||
| expiry_C_date | C_date_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_contract_month_index | Alternate Key | C_contract_no,C_delivery_month_no,C_delivery_day_no |
| PK10 | PrimaryKey | C_contract_no,C_delivery_month_no,C_delivery_day_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract | C_contract_month | Identifying | C_contract_no |
| C_delivery_month | C_contract_month | Identifying | C_delivery_month_no |
| C_contract_session |
| EntityType | Dependent |
| Logical Table Name | C_contract_session |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_session_no |
C_contract_session_no_t | NO | ||
| C_contract_no |
C_contract_no_t | NO | ||
| C_session_cancelled | C_yesno_t | NO | ||
| default_pre_open_C_timeonly | C_timeonly_t | YES | ||
| default_open_C_timeonly | C_timeonly_t | YES | ||
| default_post_open_C_timeonly | C_timeonly_t | YES | ||
| default_pre_close_C_timeonly | C_timeonly_t | YES | ||
| default_close_C_timeonly | C_timeonly_t | YES | ||
| default_post_close_C_timeonly | C_timeonly_t | YES | ||
| todays_pre_open_C_timeonly | C_timeonly_t | YES | ||
| todays_open_C_timeonly | C_timeonly_t | YES | ||
| todays_post_open_C_timeonly | C_timeonly_t | YES | ||
| todays_pre_close_C_timeonly | C_timeonly_t | YES | ||
| todays_close_C_timeonly | C_timeonly_t | YES | ||
| todays_post_close_C_timeonly | C_timeonly_t | YES | ||
| default_ta_C_timeonly | C_timeonly_t | YES | ||
| default_ma_C_timeonly | C_timeonly_t | YES | ||
| default_dk_C_timeonly | C_timeonly_t | YES | ||
| todays_ta_C_timeonly | C_timeonly_t | YES | ||
| todays_ma_C_timeonly | C_timeonly_t | YES | ||
| todays_dk_C_timeonly | C_timeonly_t | YES | ||
| C_weekday | INTEGER | NO |
| Keys |
| Key Name | Key Type | Keys |
| C_contract_session_index | Alternate Key | C_contract_session_no,C_contract_no,C_weekday |
| PK11 | PrimaryKey | C_contract_session_no,C_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract | C_contract_session | Identifying | C_contract_no |
| C_contract_session | C_contract_session_cancel | Identifying | C_contract_no,C_contract_session_no |
| C_contract_session_cancel |
| EntityType | Dependent |
| Logical Table Name | C_contract_session_cancel |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_date |
C_date_t | NO | ||
| C_contract_no |
C_contract_no_t | NO | ||
| C_contract_session_no |
C_contract_session_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK12 | PrimaryKey | C_date,C_contract_no,C_contract_session_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract_session | C_contract_session_cancel | Identifying | C_contract_no,C_contract_session_no |
| C_contract_type |
| EntityType | Independent |
| Logical Table Name | C_contract_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_type_no |
C_contract_type_no_t | NO | ||
| C_contract_type_code | C_contract_type_code_t | YES | ||
| C_contract_type_name | C_contract_type_name_t | YES | ||
| C_contract_type_bitmap | C_contract_type_bitmap_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_contract_type_index | Alternate Key | C_contract_type_no |
| PK13 | PrimaryKey | C_contract_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract_type | C_series | Non-Identifying | C_contract_type_no |
| C_contract_volume |
| EntityType | Independent |
| Logical Table Name | C_contract_volume |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_no |
C_contract_no_t | NO | ||
| trade_C_newdate |
trade_C_newdate_t | NO | ||
| futures_C_volume | C_volume_t | YES | ||
| options_C_volume | C_volume_t | YES | ||
| spread_C_volume | C_volume_t | YES | ||
| efp_C_volume | C_volume_t | YES | ||
| strip_C_volume | C_volume_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_Contract_volume | PrimaryKey | C_contract_no,trade_C_newdate |
| C_contract_volume_idx | Alternate Key | C_contract_no,trade_C_newdate |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_daily_stats |
| EntityType | Dependent |
| Logical Table Name | C_daily_stats |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_series_no |
C_series_no_t | NO | ||
| stats_C_date |
C_date_t | NO | ||
| stats_C_newdate | C_newdate_t | YES | ||
| closing_bid_C_price | C_price_t | YES | ||
| closing_ask_C_price | C_price_t | YES | ||
| C_volatility_factor | C_volatility_factor_t | YES | ||
| bid_C_price | C_price_t | YES | ||
| ask_C_price | C_price_t | YES | ||
| previous_bid_C_price | C_price_t | YES | ||
| previous_ask_C_price | C_price_t | YES | ||
| last_trade_C_price | C_price_t | YES | ||
| last_1_trade_C_price | C_price_t | YES | ||
| last_2_trade_C_price | C_price_t | YES | ||
| last_trade_C_time | C_time_t | YES | ||
| last_1_trade_C_time | C_time_t | YES | ||
| last_2_trade_C_time | C_time_t | YES | ||
| last_trade_C_volume | C_volume_t | YES | ||
| last_1_trade_C_volume | C_volume_t | YES | ||
| last_2_trade_C_volume | C_volume_t | YES | ||
| high_C_price | C_price_t | YES | ||
| low_C_price | C_price_t | YES | ||
| last_settlement_C_price | C_price_t | YES | ||
| total_C_volume | C_volume_t | YES | ||
| C_open_interest | C_open_interest_t | YES | ||
| opening_C_price | C_price_t | YES | ||
| bid_C_indicative_flag | C_indicative_flag_t | YES | ||
| ask_C_indicative_flag | C_indicative_flag_t | YES | ||
| efp_C_volume | C_volume_t | YES | ||
| efs_C_volume | C_volume_t | YES | ||
| C_month_position | C_month_position_t | YES | ||
| cross_C_volume | C_volume_t | YES | ||
| C_trade_count | C_trade_count_t | YES | ||
| contra_C_volume | C_volume_t | YES | ||
| floor_C_volume | C_volume_t | YES | ||
| electronic_C_volume | C_volume_t | YES | ||
| C_settlement_send_code | C_settlement_send_code_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_daily_stats_index | Inversion Entry | C_series_no,stats_C_date |
| C_daily_stats_index2 | Inversion Entry | C_series_no,stats_C_date |
| UK_SERIES_DATE | Alternate Key | C_series_no,stats_C_newdate |
| PK15 | PrimaryKey | C_series_no,stats_C_date |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_series | C_daily_stats | Identifying | C_series_no |
| C_decimal_format |
| EntityType | Independent |
| Logical Table Name | C_decimal_format |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_decimal_format_no |
C_decimal_format_no_t | NO | ||
| C_left_zeros | C_flag_t | YES | ||
| C_right_zeros | C_flag_t | YES | ||
| C_decimal_places | C_number_of_places_t | YES | ||
| C_integer_places | C_number_of_places_t | YES | ||
| C_unit_size | C_unit_size_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_decimal_format | PrimaryKey | C_decimal_format_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_decimal_format | C_contract | Non-Identifying | C_decimal_format_no |
| C_decimal_format | C_contract | Non-Identifying | C_strike_decimal_format_no |
| C_decimal_format | C_spread_contract | Non-Identifying | C_decimal_format_no |
| C_delivery_month |
| EntityType | Independent |
| Logical Table Name | C_delivery_month |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_delivery_month_no |
C_delivery_month_no_t | NO | ||
| C_month_mnemonic | C_month_mnemonic_t | YES | ||
| C_month_letters | C_month_letters_t | YES | ||
| C_month_name | C_month_name_t | YES | ||
| C_year_number_text | C_year_number_text_t | YES | ||
| C_month_number_text | C_month_number_text_t | YES | ||
| C_trs_mnemonic | C_trs_mnemonic_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_delivery_month_index | Alternate Key | C_delivery_month_no |
| PK17 | PrimaryKey | C_delivery_month_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_delivery_month | C_contract_month | Identifying | C_delivery_month_no |
| C_ets_spread_trade |
| EntityType | Independent |
| Logical Table Name | C_ets_spread_trade |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_spread_chain_no | C_spread_no_t | NO | ||
| C_volume | C_volume_t | NO | ||
| C_price | C_price_t | NO | ||
| C_spread_contract_no | C_contract_no_t | NO | ||
| C_spread_series_no | C_series_no_t | NO | ||
| C_time | C_time_t | NO | ||
| C_trade_type_code | C_trade_type_code_t | NO | ||
| trade_C_newdate | C_newdate_t | NO | ||
| C_trade_status_code | C_trade_status_code_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_ets_trade |
| EntityType | Independent |
| Logical Table Name | C_ets_trade |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| trade_C_newdate |
trade_C_newdate_t | NO | ||
| C_trade_no |
C_trade_no_t | NO | ||
| C_buy_sell_ind |
C_buy_sell_ind_t | NO | ||
| C_trade_set_id | C_trade_set_id_t | NO | ||
| C_trade_sub_set_id | C_trade_set_id_t | NO | ||
| C_contract_no | C_contract_no_t | YES | ||
| C_series_no | C_series_no_t | YES | ||
| trade_C_volume | C_volume_t | YES | ||
| trade_C_price | C_price_t | YES | ||
| trade_C_time | C_time_t | YES | ||
| C_trade_type_code | C_trade_type_code_t | YES | ||
| originating_C_trader_no | C_trader_no_t | YES | ||
| counterparty_C_trader_no | C_trader_no_t | YES | ||
| C_order_no | C_order_no_t | YES | ||
| C_order_sequence_no | C_order_sequence_no_t | YES | ||
| C_trader_card_ref | C_trader_card_ref_t | YES | ||
| C_account_ref | C_account_ref_t | YES | ||
| C_clearing_slip_id | C_slip_no_t | YES | ||
| C_transaction_no | C_transaction_no_t | YES | ||
| sent_to_trs_C_time | C_time_t | YES | ||
| C_transaction_id | C_transaction_id_t | YES | ||
| C_account_type_code | C_account_type_code_t | YES | ||
| C_trade_status_code | C_trade_status_code_t | YES | ||
| C_spread_chain_no | C_spread_no_t | YES | ||
| C_spread_chain_count | C_spread_no_t | YES | ||
| C_spread_leg_id | C_leg_no_t | YES | ||
| C_account_cti | C_account_cti_t | YES | ||
| C_session_no | C_session_no_t | YES | ||
| C_clearer_member_no | C_member_no_t | YES | ||
| C_is_from_opening_match | C_yesno_t | YES | ||
| C_trader_viewed | C_yesno_t | YES | ||
| C_report_to_PRS | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_ets_trade_indx | Inversion Entry | trade_C_newdate,C_order_no |
| C_ets_trad_18352056383 | PrimaryKey | trade_C_newdate,C_trade_no,C_buy_sell_ind |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_ets_trade | C_ets_trade_allocation | Identifying | trade_C_newdate,C_trade_no,C_buy_sell_ind |
| C_ets_trade_allocation |
| EntityType | Dependent |
| Logical Table Name | C_ets_trade_allocation |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| trade_C_newdate |
trade_C_newdate_t | NO | ||
| C_trade_no |
C_trade_no_t | NO | ||
| C_buy_sell_ind |
C_buy_sell_ind_t | NO | ||
| C_allocation_seq_no |
C_seq_no_t | NO | ||
| C_allocation_unit_no | C_unit_no_t | YES | ||
| C_allocation_volume | C_volume_t | YES | ||
| C_allocation_user_no | C_user_no_t | YES | ||
| C_allocation_period | C_allocation_period_t | YES | ||
| C_account_reference | C_account_reference_t | YES | ||
| C_account_clearer | C_member_no_t | YES | ||
| C_account_cti | C_account_cti_t | YES | ||
| C_allocation_time | C_time_t | YES | ||
| C_trader_allocation_flag | C_yesno_t | YES | ||
| C_exchange_allocation_count | C_count_t | YES | ||
| C_clearer_allocation_count | C_count_t | YES | ||
| C_is_dont_knowed | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK20 | PrimaryKey | trade_C_newdate,C_trade_no,C_buy_sell_ind,C_allocation_seq_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_ets_trade | C_ets_trade_allocation | Identifying | trade_C_newdate,C_trade_no,C_buy_sell_ind |
| C_holidays |
| EntityType | Independent |
| Logical Table Name | C_holidays |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| holiday_C_date |
C_date_t | NO | ||
| C_holiday_description | C_holiday_description_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_holidays_index | Alternate Key | holiday_C_date |
| PK21 | PrimaryKey | holiday_C_date |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_interest_rate |
| EntityType | Independent |
| Logical Table Name | C_interest_rate |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_interest_rate |
C_interest_rate_t | NO | ||
| C_start_date |
C_date_t | NO | ||
| C_end_date | C_date_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_interest_rate | PrimaryKey | C_interest_rate,C_start_date |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_margin_rate |
| EntityType | Dependent |
| Logical Table Name | C_margin_rate |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_no |
C_contract_no_t | NO | ||
| C_start_date |
C_date_t | NO | ||
| C_end_date | C_date_t | YES | ||
| C_outright_margin_rate | C_price_t | YES | ||
| C_calendar_spread_margin_rate | C_price_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_margin_rate | PrimaryKey | C_contract_no,C_start_date |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract | C_margin_rate | Identifying | C_contract_no |
| C_market_type |
| EntityType | Independent |
| Logical Table Name | C_market_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_market_type_no |
C_market_type_no_t | NO | ||
| C_market_type_desc | C_market_type_desc_t | YES | ||
| C_trs_download_flag | C_trs_download_flag_t | YES | ||
| C_trading_right_block_size | C_trading_right_block_size_t | YES | ||
| C_exchange_code | C_exchange_code_t | YES | ||
| C_exchange_name | C_exchange_name_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_market_type_index | Alternate Key | C_market_type_no |
| PK24 | PrimaryKey | C_market_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_market_type | C_account_rights | Identifying | C_account_market_type_no |
| C_market_type | C_member_trading_right | Identifying | C_market_type_no |
| C_market_type | C_trader_right | Identifying | C_market_type_no |
| C_member |
| EntityType | Independent |
| Logical Table Name | C_member |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_member_no |
C_member_no_t | NO | ||
| C_member_full_name | C_member_name_abbrev_t | YES | ||
| C_member_mnemonic | C_long_mnemonic_t | YES | ||
| C_clearer_id | C_long_mnemonic_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_member_index | Alternate Key | C_member_no |
| PK25 | PrimaryKey | C_member_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_member | C_account | Identifying | C_account_clearer |
| C_member | C_user_group | Non-Identifying | C_member_no |
| C_member | C_user | Non-Identifying | C_member_no |
| C_member | C_member_trading_right | Identifying | C_member_no |
| C_member_trading_right |
| EntityType | Dependent |
| Logical Table Name | C_member_trading_right |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_member_no |
C_member_no_t | NO | ||
| C_market_type_no |
C_market_type_no_t | NO | ||
| C_number_of_rights | C_number_of_rights_t | YES | ||
| C_clearing_status_no | C_clearing_status_no_t | YES | ||
| C_default_clearing_member_no | SMALLINT | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_member_trading_right | PrimaryKey | C_member_no,C_market_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_market_type | C_member_trading_right | Identifying | C_market_type_no |
| C_member | C_member_trading_right | Identifying | C_member_no |
| C_message_class |
| EntityType | Independent |
| Logical Table Name | C_message_class |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_msg_mask |
INTEGER | NO | ||
| C_msg_class |
INTEGER | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_message_class | PrimaryKey | C_msg_mask,C_msg_class |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_message_direction |
| EntityType | Independent |
| Logical Table Name | C_message_direction |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_msg_no |
C_message_no_t | NO | ||
| C_msg_direction | SMALLINT | NO | ||
| C_msg_class | INTEGER | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_message_direction | PrimaryKey | C_msg_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_order |
| EntityType | Independent |
| Logical Table Name | C_order |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_newdate_sequence |
C_newdate_sequence_t | NO | ||
| C_order_no |
C_order_no_t | NO | ||
| C_order_sequence_no |
C_order_sequence_no_t | NO | ||
| C_originating_trader_no | C_trader_no_t | NO | ||
| order_sequence_C_time | C_time_t | YES | ||
| C_order_status_flag | C_order_status_flag_t | YES | ||
| order_C_volume | C_volume_t | YES | ||
| order_limit_C_price | C_price_t | YES | ||
| order_stop_C_price | C_price_t | YES | ||
| remaining_C_volume | C_volume_t | YES | ||
| order_C_time | C_time_t | YES | ||
| modify_C_time | C_time_t | YES | ||
| modify_C_micro_time | C_micro_time_t | YES | ||
| C_order_reference | C_order_reference_t | YES | ||
| C_account_reference | C_account_reference_t | YES | ||
| C_account_type_code | C_account_type_code_t | YES | ||
| C_allocation_mnemonic | C_allocation_mnemonic_t | YES | ||
| C_order_type_code |
C_order_type_code_t | YES | ||
| C_order_entry_mode | C_order_entry_mode_t | YES | ||
| C_instruction_type_code | C_instruction_type_code_t | YES | ||
| C_member_no | C_member_no_t | YES | ||
| C_trader_no | C_trader_no_t | YES | ||
| show_C_volume | C_volume_t | YES | ||
| maximum_show_C_volume | C_volume_t | YES | ||
| C_active_flag | C_active_flag_t | YES | ||
| activation_C_time | C_time_t | YES | ||
| activation_C_micro_time | C_micro_time_t | YES | ||
| C_private_flag | C_private_flag_t | YES | ||
| C_retain_flag | C_flag_t | YES | ||
| C_clearer_member_no | C_member_no_t | YES | ||
| C_account_cti | C_account_cti_t | YES | ||
| C_not_held_flag | C_flag_t | YES | ||
| C_carry_forward_flag | C_flag_t | YES | ||
| C_prev_order_no | C_order_no_t | YES | ||
| O_entry_unique | VARCHAR(24) | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_order_index | Alternate Key | C_newdate_sequence,C_order_no,C_order_sequence_no |
| PK29 | PrimaryKey | C_newdate_sequence,C_order_no,C_order_sequence_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_order_type | C_order | Non-Identifying | C_order_type_code |
| C_order | C_order_detail | Identifying | C_order_no,C_order_sequence_no,C_newdate_sequence |
| C_order_action_limit |
| EntityType | Independent |
| Logical Table Name | C_order_action_limit |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_order_action_limit | SMALLINT | NO |
| Keys |
| Key Name | Key Type | Keys |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_order_detail |
| EntityType | Dependent |
| Logical Table Name | C_order_detail |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_order_no |
C_order_no_t | NO | ||
| C_order_sequence_no |
C_order_sequence_no_t | NO | ||
| C_order_leg_no |
C_order_leg_no_t | NO | ||
| C_newdate_sequence |
C_newdate_sequence_t | NO | ||
| C_contract_no | C_contract_no_t | YES | ||
| C_series_no | C_series_no_t | YES | ||
| C_buy_sell_ind | C_buy_sell_ind_t | YES | ||
| crack_C_volume | C_volume_t | YES | ||
| crack_C_price | C_price_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_order_detail_index | Alternate Key | C_order_no,C_order_sequence_no,C_order_leg_no,C_newdate_sequence |
| PK31 | PrimaryKey | C_order_no,C_order_sequence_no,C_order_leg_no,C_newdate_sequence |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_order | C_order_detail | Identifying | C_order_no,C_order_sequence_no,C_newdate_sequence |
| C_order_type |
| EntityType | Independent |
| Logical Table Name | C_order_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_order_type_code |
C_order_type_code_t | NO | ||
| C_order_type_no | C_order_type_no_t | NO | ||
| C_is_active | C_flag_t | NO | ||
| C_is_hit | C_flag_t | NO | ||
| C_order_type_name | C_order_type_name_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_order_type_index | Alternate Key | C_order_type_no |
| PK32 | PrimaryKey | C_order_type_code |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_order_type | C_order | Non-Identifying | C_order_type_code |
| C_right_type |
| EntityType | Independent |
| Logical Table Name | C_right_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_right_type_no |
C_right_type_no_t | NO | ||
| C_right_type_name | C_right_type_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_right_type | PrimaryKey | C_right_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_right_type | C_user_right | Identifying | C_right_type_no |
| C_series |
| EntityType | Independent |
| Logical Table Name | C_series |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_series_no |
C_series_no_t | NO | ||
| C_contract_type_no |
C_contract_type_no_t | YES | ||
| C_contract_no |
C_contract_no_t | YES | ||
| C_delivery_month_no | C_delivery_month_no_t | YES | ||
| C_delivery_day_no | C_delivery_day_no_t | YES | ||
| exercise_C_price | C_price_t | YES | ||
| underlying_C_series_no | C_series_no_t | YES | ||
| C_trading_today | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_series_index | Alternate Key | C_series_no |
| contract_month | Inversion Entry | C_contract_no,C_delivery_month_no,exercise_C_price |
| PK34 | PrimaryKey | C_series_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract | C_series | Non-Identifying | C_contract_no |
| C_contract_type | C_series | Non-Identifying | C_contract_type_no |
| C_series | C_daily_stats | Identifying | C_series_no |
| C_series | C_spread_series_leg | Identifying | C_series_no |
| C_series | C_settlement_price | Identifying | C_series_no |
| C_series | C_trade_limit | Identifying | C_series_no |
| C_settlement_config |
| EntityType | Dependent |
| Logical Table Name | C_settlement_config |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_contract_no |
C_contract_no_t | NO | ||
| C_calculation_type | C_calculation_type_t | YES | ||
| closing_period_C_minute | C_minute_t | YES | ||
| closing_C_volume | C_volume_t | YES | ||
| C_sett_group | C_sett_group_t | YES | ||
| closing_period_start_C_time | C_time_t | YES | ||
| closing_period_end_C_time | C_time_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_settlement_config | PrimaryKey | C_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_contract | C_settlement_config | Identifying | C_contract_no |
| C_settlement_price |
| EntityType | Dependent |
| Logical Table Name | C_settlement_price |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_date |
C_date_t | NO | ||
| C_series_no |
C_series_no_t | NO | ||
| C_settlement_send_code |
C_settlement_send_code_t | NO | ||
| C_ets_price_type_no | C_ets_price_type_no_t | YES | ||
| ets_C_price | C_price_t | YES | ||
| interpolated_C_price | C_price_t | YES | ||
| manual_C_price | C_price_t | YES | ||
| C_active_settlement_code | C_active_settlement_code_t | YES | ||
| active_C_price | C_price_t | YES | ||
| last_sent_C_time | C_time_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_settlement_price_index | Alternate Key | C_date,C_series_no,C_settlement_send_code |
| PK36 | PrimaryKey | C_date,C_series_no,C_settlement_send_code |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_series | C_settlement_price | Identifying | C_series_no |
| C_spread_contract |
| EntityType | Independent |
| Logical Table Name | C_spread_contract |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_spread_no |
C_spread_no_t | NO | ||
| C_spread_name | C_contract_name_t | YES | ||
| C_number_of_legs | C_leg_no_t | YES | ||
| C_number_of_months | C_number_of_months_t | YES | ||
| C_is_ets_traded | C_yesno_t | YES | ||
| C_tick_size | C_tick_size_t | YES | ||
| C_volume_granularity | C_volume_granularity_t | YES | ||
| C_spread_type | C_spread_type_t | YES | ||
| C_decimal_format_no |
C_decimal_format_no_t | YES | ||
| C_implied_mode | C_implied_mode_t | YES | ||
| C_spread_short_name | VARCHAR(12) | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_spread_contract | PrimaryKey | C_spread_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_decimal_format | C_spread_contract | Non-Identifying | C_decimal_format_no |
| C_spread_contract | C_spread_contract_leg | Identifying | C_spread_no |
| C_spread_contract_leg |
| EntityType | Dependent |
| Logical Table Name | C_spread_contract_leg |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_spread_no |
C_spread_no_t | NO | ||
| C_leg_no |
C_leg_no_t | NO | ||
| C_contract_no |
C_contract_no_t | YES | ||
| C_leg_position | C_position_no_t | YES | ||
| C_leg_volume | C_volume_t | YES | ||
| C_leg_price_multiplier | C_price_t | YES | ||
| C_leg_price_divisor | C_price_t | YES | ||
| C_is_buy | C_yesno_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_spread_contract_leg | PrimaryKey | C_spread_no,C_leg_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_spread_contract | C_spread_contract_leg | Identifying | C_spread_no |
| C_contract | C_spread_contract_leg | Non-Identifying | C_contract_no |
| C_spread_contract_leg | C_spread_series_leg | Identifying | C_spread_no,C_leg_no |
| C_spread_series_leg |
| EntityType | Dependent |
| Logical Table Name | C_spread_series_leg |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_spread_series_no |
C_series_no_t | NO | ||
| C_spread_no |
C_spread_no_t | NO | ||
| C_leg_no |
C_leg_no_t | NO | ||
| C_series_no |
C_series_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_spread_series_leg | PrimaryKey | C_spread_series_no,C_spread_no,C_leg_no,C_series_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_spread_contract_leg | C_spread_series_leg | Identifying | C_spread_no,C_leg_no |
| C_series | C_spread_series_leg | Identifying | C_series_no |
| C_spread_stats |
| EntityType | Independent |
| Logical Table Name | C_spread_stats |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_spread_series_no |
C_series_no_t | NO | ||
| stats_C_newdate |
C_newdate_t | NO | ||
| last_trade_C_price | C_price_t | YES | ||
| last_1_trade_C_price | C_price_t | YES | ||
| last_2_trade_C_price | C_price_t | YES | ||
| last_C_volume | C_volume_t | YES | ||
| last_trade_C_time | C_time_t | YES | ||
| high_C_price | C_price_t | YES | ||
| low_C_price | C_price_t | YES | ||
| total_C_volume | C_volume_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_spread_stats | PrimaryKey | C_spread_series_no,stats_C_newdate |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_system_dates |
| EntityType | Independent |
| Logical Table Name | C_system_dates |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_system_dates_id |
INTEGER | NO | ||
| C_logical_date_name | C_logical_date_name_t | NO | ||
| C_logical_date_value | C_logical_date_value_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_system_dates_index | Alternate Key | C_system_dates_id |
| PK41 | PrimaryKey | C_system_dates_id |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_system_times |
| EntityType | Independent |
| Logical Table Name | C_system_times |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_logical_time_name |
C_logical_time_name_t | NO | ||
| C_logical_time_value | C_logical_time_value_t | YES | ||
| C_logical_time_out | C_logical_time_out_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK42 | PrimaryKey | C_logical_time_name |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_terminal |
| EntityType | Independent |
| Logical Table Name | C_terminal |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_terminal_name |
C_terminal_name_t | NO | ||
| C_terminal_location | C_terminal_location_t | YES | ||
| C_terminal_desc | C_terminal_desc_t | YES | ||
| C_protocol | C_protocol_t | YES | ||
| C_terminal_status | C_terminal_status_t | YES | ||
| C_user_group_no |
C_user_group_no_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_terminal_index | Alternate Key | C_terminal_name |
| PK43 | PrimaryKey | C_terminal_name |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user_group | C_terminal | Non-Identifying | C_user_group_no |
| C_terminal | C_user_logon_history | Non-Identifying | C_terminal |
| C_trade_limit |
| EntityType | Dependent |
| Logical Table Name | C_trade_limit |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_series_no |
C_series_no_t | NO | ||
| C_start_date |
C_time_t | NO | ||
| high_limit_C_price | C_price_t | NO | ||
| low_limit_C_price | C_price_t | NO | ||
| C_end_date | C_time_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_trade_limit | PrimaryKey | C_series_no,C_start_date |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_series | C_trade_limit | Identifying | C_series_no |
| C_trade_type |
| EntityType | Independent |
| Logical Table Name | C_trade_type |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_trade_type_no |
C_trade_type_no_t | NO | ||
| C_trade_type_code | C_trade_type_code_t | YES | ||
| C_trade_type_name | C_trade_type_name_t | YES | ||
| C_trade_type_desc | C_trade_type_desc_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_trade_type_index | Alternate Key | C_trade_type_no |
| PK45 | PrimaryKey | C_trade_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_trader_right |
| EntityType | Dependent |
| Logical Table Name | C_trader_right |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_trader_no |
C_trader_no_t | NO | ||
| C_market_type_no |
C_market_type_no_t | NO | ||
| C_contract_no |
C_contract_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_trader_right | PrimaryKey | C_trader_no,C_market_type_no,C_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_market_type | C_trader_right | Identifying | C_market_type_no |
| C_tsi_systems |
| EntityType | Independent |
| Logical Table Name | C_tsi_systems |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_tsi_system_no |
C_tsi_system_no_t | NO | ||
| C_tsi_mnemonic | C_tsi_mnemonic_t | YES | ||
| C_tsi_description | C_tsi_description_t | YES | ||
| C_status | INTEGER | YES | ||
| C_log_time | DATETIME | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_tsi_systems_index | Alternate Key | C_tsi_system_no |
| PK47 | PrimaryKey | C_tsi_system_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user |
| EntityType | Independent |
| Logical Table Name | C_user |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_user_no |
C_user_no_t | NO | ||
| C_user_username | C_user_username_t | NO | ||
| C_user_real_name | C_user_real_name_t | YES | ||
| C_user_password | C_user_password_t | YES | ||
| C_date_last_changed | C_date_last_changed_t | YES | ||
| C_user_status | C_user_status_t | YES | ||
| C_trader_no | C_trader_no_t | YES | ||
| C_member_no |
C_member_no_t | YES | ||
| C_user_group_no |
C_user_group_no_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_user_index | Alternate Key | C_user_no |
| C_user_index_2 | Alternate Key | C_user_username |
| PK48 | PrimaryKey | C_user_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_member | C_user | Non-Identifying | C_member_no |
| C_user_group | C_user | Non-Identifying | C_user_group_no |
| C_user | C_account_user | Identifying | C_user_no |
| C_user | C_audit_message | Non-Identifying | C_user_no |
| C_user | C_user_logon_history | Identifying | C_user_no |
| C_user | C_user_right | Identifying | C_user_no |
| C_user | C_user_reasonability | Identifying | C_user_no |
| C_user_group |
| EntityType | Independent |
| Logical Table Name | C_user_group |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_user_group_no |
C_user_group_no_t | NO | ||
| C_user_group_name | C_user_group_name_t | YES | ||
| C_member_no |
C_member_no_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| C_user_group_index | Alternate Key | C_user_group_no |
| PK49 | PrimaryKey | C_user_group_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_member | C_user_group | Non-Identifying | C_member_no |
| C_user_group | C_terminal | Non-Identifying | C_user_group_no |
| C_user_group | C_user | Non-Identifying | C_user_group_no |
| C_user_logon_history |
| EntityType | Dependent |
| Logical Table Name | C_user_logon_history |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_newdate |
C_newdate_t | NO | ||
| C_time |
C_timeonly_t | NO | ||
| C_event_type |
C_event_type_t | NO | ||
| C_user_no |
C_user_no_t | NO | ||
| C_terminal |
C_terminal_name_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_user_logon_history | PrimaryKey | C_newdate,C_time,C_event_type,C_user_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user | C_user_logon_history | Identifying | C_user_no |
| C_terminal | C_user_logon_history | Non-Identifying | C_terminal |
| C_audit_event_type | C_user_logon_history | Identifying | C_event_type |
| C_user_message |
| EntityType | Dependent |
| Logical Table Name | C_user_message |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_newdate |
C_newdate_t | NO | ||
| C_time |
C_timeonly_t | NO | ||
| C_event_type |
C_event_type_t | NO | ||
| C_origin |
C_user_no_t | NO | ||
| C_destination_user | C_user_no_t | YES | ||
| C_destination_group | C_group_no_t | YES | ||
| C_text | C_text_message_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_user_message | PrimaryKey | C_newdate,C_time,C_event_type,C_origin |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_audit_event_type | C_user_message | Identifying | C_event_type |
| C_user_reasonability |
| EntityType | Dependent |
| Logical Table Name | C_user_reasonability |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_user_no |
C_user_no_t | NO | ||
| C_contract_no |
C_contract_no_t | NO | ||
| C_instrument |
C_flag_t | NO | ||
| C_price_increment | C_price_t | YES | ||
| C_vol_increment | C_volume_t | YES | ||
| C_max_price_change | C_price_t | YES | ||
| C_max_vol | C_volume_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_user_reasonability | PrimaryKey | C_user_no,C_contract_no,C_instrument |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user | C_user_reasonability | Identifying | C_user_no |
| C_user_right |
| EntityType | Dependent |
| Logical Table Name | C_user_right |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_user_no |
C_user_no_t | NO | ||
| C_right_type_no |
C_right_type_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| PK_C_user_right | PrimaryKey | C_user_no,C_right_type_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| C_user | C_user_right | Identifying | C_user_no |
| C_right_type | C_user_right | Identifying | C_right_type_no |
| tmp_bo_data |
| EntityType | Independent |
| Logical Table Name | tmp_bo_data |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_series_no |
C_series_no_t | NO | ||
| C_delivery_month_no | C_delivery_month_no_t | NO | ||
| C_contract_no | C_contract_no_t | NO | ||
| last_year | VARCHAR(4) | NO | ||
| last_month | VARCHAR(2) | NO | ||
| last_days | VARCHAR(2) | NO | ||
| f_pc | VARCHAR(1) | NO | ||
| strike | INTEGER | NO | ||
| settlement_price | INTEGER | NO | ||
| settle_ind | VARCHAR(1) | NO | ||
| open_interest | INTEGER | NO | ||
| price_limit_delta | INTEGER | NO | ||
| volatility | VARCHAR(14) | NO | ||
| cont_status | VARCHAR(1) | NO | ||
| settlement_send_code | C_settlement_send_code_t | NO | ||
| high_limit_C_price | C_price_t | NO | ||
| low_limit_C_price | C_price_t | NO | ||
| trading_today | C_yesno_t | NO | ||
| exercise_C_price | C_price_t | NO | ||
| underlying_C_series_no | C_series_no_t | YES | ||
| contract_type_no | C_contract_no_t | NO | ||
| volatility_factor | C_volatility_factor_t | YES |
| Keys |
| Key Name | Key Type | Keys |
| tmp_bo_dat_20821585131 | PrimaryKey | C_series_no |
| tmp_bo_data_idx | Alternate Key | C_series_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| tmp_commodity_list |
| EntityType | Independent |
| Logical Table Name | tmp_commodity_list |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| commodity | VARCHAR(2) | NO | ||
| comm_type | VARCHAR(3) | NO | ||
| underly_comm | VARCHAR(2) | NO | ||
| short_name | VARCHAR(8) | NO | ||
| long_name | VARCHAR(35) | NO | ||
| strike_decimal | CHAR(1) | NO | ||
| price_decimal | CHAR(1) | NO | ||
| C_contract_no | C_contract_no_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| tmp_match | Inversion Entry | C_contract_no |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| tmp_contract_list |
| EntityType | Independent |
| Logical Table Name | tmp_contract_list |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| commodity | VARCHAR(2) | NO | ||
| year | VARCHAR(4) | NO | ||
| month | VARCHAR(2) | NO | ||
| f_pc | CHAR(1) | NO | ||
| strike | VARCHAR(7) | NO | ||
| underlying_year | CHAR(4) | NO | ||
| underlying_month | CHAR(2) | NO | ||
| cont_status | CHAR(1) | NO | ||
| settle_ind | CHAR(1) | NO | ||
| settlement | VARCHAR(7) | NO | ||
| price_limit_delta | VARCHAR(7) | NO | ||
| volatility | VARCHAR(14) | NO | ||
| last_year | VARCHAR(4) | NO | ||
| last_month | VARCHAR(2) | NO | ||
| last_days | VARCHAR(2) | NO | ||
| last_EFP_year | VARCHAR(4) | NO | ||
| last_EFP_month | VARCHAR(2) | NO | ||
| last_EFP_days | VARCHAR(2) | NO | ||
| margin_rate | VARCHAR(8) | NO | ||
| spread_margin_rate | VARCHAR(8) | NO | ||
| contract_value_factor | VARCHAR(11) | NO | ||
| minimum_fluctuation | VARCHAR(7) | NO | ||
| open_interest | VARCHAR(7) | NO | ||
| C_contract_no | C_contract_no_t | NO | ||
| C_delivery_month_no | C_delivery_month_no_t | NO | ||
| exercise_C_price | C_price_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| tmp_match | Inversion Entry | C_contract_no,C_delivery_month_no,exercise_C_price |
| tmp_vendor | Inversion Entry | commodity |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| tmp_download_record |
| EntityType | Independent |
| Logical Table Name | tmp_download_record |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_download_date_time | C_date_t | NO | ||
| C_sequence | C_download_sequence_t | NO | ||
| C_download_error_code | C_download_error_code_t | NO | ||
| C_download_error_message | C_download_error_message_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| tmp_letter_list |
| EntityType | Independent |
| Logical Table Name | tmp_letter_list |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_month_letters | C_month_letters_t | NO | ||
| C_month_number_text | C_month_number_text_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |
| tmp_trading_date |
| EntityType | Independent |
| Logical Table Name | tmp_trading_date |
| Definition | |
| Note |
| Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| C_trading_date | C_date_t | NO |
| Keys |
| Key Name | Key Type | Keys |
| Relationships |
| Parent Entity | Child Entity | Type | Foreign Keys |