"C_member to C_account"
RelationshipType Identifying
Relationship Name
Parent Entity C_member
Child Entity C_account
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_member_no C_account_clearer

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_account to C_account_position_limit"
RelationshipType Identifying
Relationship Name FK_C_account_position_limit
Parent Entity C_account
Child Entity C_account_position_limit
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_account_reference,C_account_clearer C_account_reference,C_account_clearer

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_market_type to C_account_rights"
RelationshipType Identifying
Relationship Name FK_C_ACCOUN_REF_1575_C_MARKET
Parent Entity C_market_type
Child Entity C_account_rights
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_market_type_no C_account_market_type_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_account to C_account_rights"
RelationshipType Identifying
Relationship Name FK_C_account_rights
Parent Entity C_account
Child Entity C_account_rights
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_account_reference,C_account_clearer C_account_reference,C_account_clearer

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user to C_account_user"
RelationshipType Identifying
Relationship Name
Parent Entity C_user
Child Entity C_account_user
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_no C_user_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_account to C_account_user"
RelationshipType Identifying
Relationship Name FK_C_account
Parent Entity C_account
Child Entity C_account_user
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_account_reference,C_account_clearer C_account_reference,C_account_clearer

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user to C_audit_message"
RelationshipType Non-Identifying
Relationship Name
Parent Entity C_user
Child Entity C_audit_message
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_no C_user_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_audit_message to C_audit_sub_message"
RelationshipType Identifying
Relationship Name FK_C_AUDIT_REF_C_AUDIT
Parent Entity C_audit_message
Child Entity C_audit_sub_message
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_audit_msg_no C_audit_msg_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_decimal_format to C_contract"
RelationshipType Non-Identifying
Relationship Name FK_C_contract
Parent Entity C_decimal_format
Child Entity C_contract
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_decimal_format_no C_decimal_format_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_decimal_format to C_contract"
RelationshipType Non-Identifying
Relationship Name FK_C_contract2
Parent Entity C_decimal_format
Child Entity C_contract
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_decimal_format_no C_strike_decimal_format_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_contract_month"
RelationshipType Identifying
Relationship Name FK_C_CONTRA_REF_1634_C_CONTRA
Parent Entity C_contract
Child Entity C_contract_month
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_delivery_month to C_contract_month"
RelationshipType Identifying
Relationship Name FK_C_CONTRA_REF_1637_C_DELIVE
Parent Entity C_delivery_month
Child Entity C_contract_month
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_delivery_month_no C_delivery_month_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_contract_session"
RelationshipType Identifying
Relationship Name FK_C_CONTRA_REF_1645_C_CONTRA
Parent Entity C_contract
Child Entity C_contract_session
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract_session to C_contract_session_cancel"
RelationshipType Identifying
Relationship Name
Parent Entity C_contract_session
Child Entity C_contract_session_cancel
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no,C_contract_session_no C_contract_no,C_contract_session_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_series to C_daily_stats"
RelationshipType Identifying
Relationship Name
Parent Entity C_series
Child Entity C_daily_stats
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_series_no C_series_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_ets_trade to C_ets_trade_allocation"
RelationshipType Identifying
Relationship Name C_ets_trad_1120775100
Parent Entity C_ets_trade
Child Entity C_ets_trade_allocation
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
trade_C_newdate,C_trade_no,C_buy_sell_ind trade_C_newdate,C_trade_no,C_buy_sell_ind

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_margin_rate"
RelationshipType Identifying
Relationship Name FK_C_MARGIN_REF_1725_C_CONTRA
Parent Entity C_contract
Child Entity C_margin_rate
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_market_type to C_member_trading_right"
RelationshipType Identifying
Relationship Name FK_C_MEMBER_REF_1815_C_MARKET
Parent Entity C_market_type
Child Entity C_member_trading_right
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_market_type_no C_market_type_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_member to C_member_trading_right"
RelationshipType Identifying
Relationship Name FK_syskeys_2
Parent Entity C_member
Child Entity C_member_trading_right
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_member_no C_member_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_order_type to C_order"
RelationshipType Non-Identifying
Relationship Name
Parent Entity C_order_type
Child Entity C_order
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_order_type_code C_order_type_code

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_order to C_order_detail"
RelationshipType Identifying
Relationship Name
Parent Entity C_order
Child Entity C_order_detail
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_order_no,C_order_sequence_no,C_newdate_sequence C_order_no,C_order_sequence_no,C_newdate_sequence

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_series"
RelationshipType Non-Identifying
Relationship Name FK_C_SERIES_REF_1905_C_CONTRA
Parent Entity C_contract
Child Entity C_series
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract_type to C_series"
RelationshipType Non-Identifying
Relationship Name FK_C_SERIES_REF_1908_C_CONTRA
Parent Entity C_contract_type
Child Entity C_series
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_type_no C_contract_type_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_settlement_config"
RelationshipType Identifying
Relationship Name FK_C_SETTLE_REF_1911_C_CONTRA
Parent Entity C_contract
Child Entity C_settlement_config
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_series to C_settlement_price"
RelationshipType Identifying
Relationship Name FK_C_SETTLE_REF_C_SERIES
Parent Entity C_series
Child Entity C_settlement_price
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_series_no C_series_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_decimal_format to C_spread_contract"
RelationshipType Non-Identifying
Relationship Name FK_C_spread_contract
Parent Entity C_decimal_format
Child Entity C_spread_contract
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_decimal_format_no C_decimal_format_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_spread_contract to C_spread_contract_leg"
RelationshipType Identifying
Relationship Name FK_C_spread_contract_leg
Parent Entity C_spread_contract
Child Entity C_spread_contract_leg
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_spread_no C_spread_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_contract to C_spread_contract_leg"
RelationshipType Non-Identifying
Relationship Name FK_C_SPREAD_REF_1958_C_CONTRA
Parent Entity C_contract
Child Entity C_spread_contract_leg
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_contract_no C_contract_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_spread_contract_leg to C_spread_series_leg"
RelationshipType Identifying
Relationship Name FK2_C_spread_series
Parent Entity C_spread_contract_leg
Child Entity C_spread_series_leg
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_spread_no,C_leg_no C_spread_no,C_leg_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_series to C_spread_series_leg"
RelationshipType Identifying
Relationship Name FK3_C_spread_series
Parent Entity C_series
Child Entity C_spread_series_leg
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_series_no C_series_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user_group to C_terminal"
RelationshipType Non-Identifying
Relationship Name FK_C_TERMIN_REF_2000_C_USER_G
Parent Entity C_user_group
Child Entity C_terminal
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_group_no C_user_group_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_series to C_trade_limit"
RelationshipType Identifying
Relationship Name FK_C_TRADE_REF_C_SERIES
Parent Entity C_series
Child Entity C_trade_limit
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_series_no C_series_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_market_type to C_trader_right"
RelationshipType Identifying
Relationship Name FK_C_trader_right
Parent Entity C_market_type
Child Entity C_trader_right
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_market_type_no C_market_type_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_member to C_user"
RelationshipType Non-Identifying
Relationship Name FK_C_USER_REF_2112_C_MEMBER
Parent Entity C_member
Child Entity C_user
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_member_no C_member_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user_group to C_user"
RelationshipType Non-Identifying
Relationship Name FK_C_USER_REF_2118_C_USER_G
Parent Entity C_user_group
Child Entity C_user
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_group_no C_user_group_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_member to C_user_group"
RelationshipType Non-Identifying
Relationship Name FK_C_USER_G_REF_2124_C_MEMBER
Parent Entity C_member
Child Entity C_user_group
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_member_no C_member_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user to C_user_logon_history"
RelationshipType Identifying
Relationship Name FK2_C_user_logon_history
Parent Entity C_user
Child Entity C_user_logon_history
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_no C_user_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_terminal to C_user_logon_history"
RelationshipType Non-Identifying
Relationship Name FK3_C_user_logon_history
Parent Entity C_terminal
Child Entity C_user_logon_history
Cardinality Zero or One to Zero or More
Existence Optional

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_terminal_name C_terminal

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_audit_event_type to C_user_logon_history"
RelationshipType Identifying
Relationship Name FK_C_user_logon_history
Parent Entity C_audit_event_type
Child Entity C_user_logon_history
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_type_no C_event_type

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_audit_event_type to C_user_message"
RelationshipType Identifying
Relationship Name FK_C_user_message
Parent Entity C_audit_event_type
Child Entity C_user_message
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_type_no C_event_type

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user to C_user_reasonability"
RelationshipType Identifying
Relationship Name FK_C_user_reasonability
Parent Entity C_user
Child Entity C_user_reasonability
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_no C_user_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_user to C_user_right"
RelationshipType Identifying
Relationship Name FK2_C_user_right
Parent Entity C_user
Child Entity C_user_right
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_user_no C_user_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None


"C_right_type to C_user_right"
RelationshipType Identifying
Relationship Name FK_C_user_right
Parent Entity C_right_type
Child Entity C_user_right
Cardinality One To Zero or More
Existence Mandatory

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
C_right_type_no C_right_type_no

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None