mysql> show create table cs_oa_syst_pst_givup\G; *************************** 1. row *************************** Table: cs_oa_syst_pst_givup Create Table: CREATE TABLE `cs_oa_syst_pst_givup` ( `d_bus` date NOT NULL COMMENT 'Business Date', `c_clro` varchar(5) CHARACTER SET latin1 NOT NULL COMMENT 'Clearing_org_code: Is the clearing organization identifier.', `c_ext_tmf` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trading_member_code: Is the primary external identifier for a member.', `c_int_tmf` bigint(15) NOT NULL COMMENT 'Trading_member_id: Is the internal identifier for a member.', `c_ext_cmf` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Clearing_member_code: Identifies the clearing member firm code.', `c_int_cmf` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Clearing_member_id: Identifies the clearing member firm code.', `c_clr_seg` varchar(5) CHARACTER SET latin1 NOT NULL COMMENT 'Clearing_segment_code: Identifies the clearing segment related to the relationship .', `c_orig_trd` varchar(5) CHARACTER SET latin1 NOT NULL COMMENT 'Trade_origin_code: Is the code assigned by the Organization to identify the level of funds segregation associated with a Clearing Member''s Position Accounts', `c_deft_action_prior` int(3) unsigned NOT NULL COMMENT 'Default_action_priority: Indicates the default action priority.', `c_deft_action` varchar(5) CHARACTER SET latin1 NOT NULL COMMENT 'Default_action_type_code: Indicates the default action. It can be: - POST for posting - GVUP for give-up', `y_deft_action` varchar(1) CHARACTER SET latin1 NOT NULL COMMENT 'Default_action_type_mode: Indicates the default action mode for the systematic posting. It can be : - O for online - B for batch', `c_int_inst_deft` bigint(15) NOT NULL COMMENT 'Default_action_instrument: Indicates the internal Product Family ID.', `c_int_trd_venue_deft` varchar(5) CHARACTER SET latin1 NOT NULL COMMENT 'Default_trade_venue_id: Identifies the trade venue on which the member can trade.', `c_orig_pa` varchar(5) CHARACTER SET latin1 NOT NULL DEFAULT '' COMMENT 'Origin_code: Is the code assigned by the Clearing Organization to identify the level of funds segregation associated with a Clearing Member''s Position Accounts.', `c_ext_pa` varchar(15) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Position_account_external_id: Is the external identifier associated to a Position Account.', `c_int_pa` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Position_account_internal_id: Is the internal identifier associated to a Position Account.', `c_accuml_pa` varchar(15) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Position_account_accumulation_code: The Clearing Member''s identification of the way the Position Account is accumulated. Accumulation can be: - net (indicator = N) - gross (indicator = G) - absolute gross (indicator = AG)', `c_clro_givup` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'GVUP_Clearing_org_id: Identifies the clearing organization.', `c_ext_mbr_givup` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'GVUP_member_code :Is the primary external identifier for a member.', `c_int_mbr_givup` bigint(15) DEFAULT NULL COMMENT 'GVUP_member_id: Is the internal identifier for a member.', `c_ext_cmf_givup` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'GVUP_Clearing_member_code: Identifies the clearing member firm code.', `c_int_cmf_givup` bigint(15) DEFAULT NULL COMMENT 'GVUP_Clearing_member_id: Identifies the clearing member firm code.', `c_orig_pa_givup` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'GVUP_Origin_code: Is the code assigned by the Clearing Organization to identify the level of funds segregation associated with a Clearing Member''s Position Accounts.', `c_ext_pa_givup` varchar(15) CHARACTER SET latin1 DEFAULT NULL COMMENT 'GVUP_Position_account_external_id: Is the external identifier associated to a Position Account.', `c_int_pas_givup` bigint(15) DEFAULT NULL COMMENT 'GVUP_Position_account_internal_id: Is the internal identifier associated to a Position Account.', `d_vali_first` date NOT NULL COMMENT 'First_valid_date: ', `d_vali_last` date NOT NULL COMMENT 'Last_valid_date: ', `c_stus` varchar(1) CHARACTER SET latin1 NOT NULL DEFAULT '' COMMENT 'Status_code :', PRIMARY KEY (`d_bus`,`c_clro`,`c_int_tmf`,`c_int_cmf`,`c_orig_trd`,`c_deft_action`,`y_deft_action`,`c_clr_seg`,`c_int_trd_venue_deft`,`c_int_inst_deft`) USING BTREE ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Syst_Posting_Giveup' 1 row in set (0.00 sec) ERROR: No query specified mysql> show create table cs_tpm_trade \G; *************************** 1. row *************************** Table: cs_tpm_trade Create Table: CREATE TABLE `cs_tpm_trade` ( `c_int_trd` bigint(15) NOT NULL COMMENT 'Internal_trade_id: Is the identifier defined by the system to a trade for a business date.', `d_trd` date DEFAULT NULL COMMENT 'Trade_date: Identifies the trading session during which a trade occurred. When a trading session lasts several calendar days, the date of the trading session corresponds to the last day of the session. Can be different from the business date for Glo', `c_ext_trd` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'External_trade_id :Is the number assigned to a trade by the sending application. In trade cancellation messages, it is the number that identifies the cancelled trade, and not that of the cancellation order.', `c_int_inst` bigint(15) DEFAULT NULL COMMENT 'Internal_instrument_id :Is the identifier of the instrument.', `q_ctr_tlg` bigint(18) DEFAULT NULL COMMENT 'Quantity: Indicates the quantity that has been traded by the member (number of shares, bonds, lots, or contracts exchanged).', `p_trd` decimal(28,10) DEFAULT NULL COMMENT 'Trade_price: Is the traded price indicated in the M1 message for standard trades only. There is no received price for flat trades.', `i_xrd` int(1) DEFAULT NULL COMMENT 'Cross_trading_code: In Trade messages sent by NSC, indicates whether : - The trade is the result of two matching orders - The same member simultaneously entered both sides of the trade. In the later case, the trade is known as a cross trade. It can', `y_tlg` varchar(2) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trade_type :Give-up, due to exercise/assignment, Linked trade, Market, Correction', `y_ses_trd` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trade_session_code: Identifies a given trading session subperiod during which a trade has been generated. It can be : - Morning - Afternoon - Night ', `y_nscvo_trd` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Matched_order_type: Is a characteristic of a trade on an instrument that can be cleared, in contrast to a trade on a strategy. It expresses the type of the orders that are at the origin of the trade, by distinguishing between simple orders (orders c', `c_trd_curr` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trading_currency_code: Quotation currency of the instrument', `c_stus` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Status_code : Is the current status of the trade : - Completed - Deleted', `d_bus` date NOT NULL COMMENT 'Trade_business_date: Indicates the trading session during which a trade occurred.', `c_clr_curr` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Clearing_currency_code :', `c_int_trd_venue` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trade_venue_code: Identifies the trade venue on the trade .', `c_exch` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Exchange_id: Identifies the exchange.', `c_clro` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Clearing_org_code: Is the clearing organization identifier.', `c_ext_tmf_buyer` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Buyer_trading_member_code : Is the ID of the "buyer trader" who entered the order in the trading system.', `c_int_tmf_buyer` bigint(15) DEFAULT NULL COMMENT 'Buyer_trading_member_id : Is the internal identifier of the "buyer trader" who entered the order in the trading system.', `c_ext_tmf_seller` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Seller_trading_member_code: Id the ID of the "seller trader" who entered the order in the trading system', `c_int_tmf_seller` bigint(15) DEFAULT NULL COMMENT 'Seller_trading_member_id: Is the internal identifier of the "seller trader" who entered the order in the trading system.', `d_h_match` datetime DEFAULT NULL COMMENT 'Matching_timestamp: The moment when a trade is generated or entered.', `y_sec_loan` varchar(3) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Security_loan_type_code: Is the type of trade on central securities lending market It distinguishes the trades that initiates a loan from those that pay back the loan for trades performed on the securities lending market.', `n_day_ns_setl` int(2) DEFAULT NULL COMMENT 'Settlement_delay: Is the number of day when a non-standard settlement delay is received with the trade.', `i_gnt` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Guarantee_indicator : Indicates if the trade is guaranteed by the Clearing House (Yes or No).', `d_setl` date DEFAULT NULL COMMENT 'Settlement_date: Is the date when the trade is sent to the delivery house for cash trade.', `d_noti` date DEFAULT NULL COMMENT 'Notification_date: Is the date when the non guaranteed trade are sent to the delivery house (for cash only).', `i_sec_loan` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Security_loan_indicator :', `p_val` decimal(28,10) DEFAULT NULL COMMENT 'Valued_price : Is deduced from the received price but takes into account accrued interest and / or indexing coefficients and coupon correction.', `p_init` decimal(28,10) DEFAULT NULL COMMENT 'Initial_price : Is deduced from the received price but takes into account accrued interest and / or indexing coefficients.', `c_ext_cmf_buyer` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Buyer_clearing_member_code: Is the CMF of the buyer trading member code.', `c_int_cmf_buyer` bigint(15) DEFAULT NULL COMMENT 'Buyer_clearing_member_id : Is the internal identifier of CMF of the buyer trading member code.', `c_ext_cmf_seller` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Seller_clearing_member_code : Is the CMF of the seller trading member code', `c_int_cmf_seller` bigint(15) DEFAULT NULL COMMENT 'Seller_clearing_member_id : Is the internal identifier of CMF of the seller trading member code.', `o_trd` decimal(28,10) DEFAULT NULL COMMENT 'Trade_amount :', `o_acc_int` decimal(28,10) DEFAULT NULL COMMENT 'Accrued_int_amnt :', `c_fin_mkt` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Financial_market_code : Includes a group of securities ruled by the same trading characteristics (ex:EuroCAC, MONEP, ...)', `i_intraday_ses` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Intraday_session_indicator : indicates if the instrument is an intraday derivative instrument.', `n_seq_intraday_ses` varchar(3) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Intraday_session_sequence_number : is the sequence number of the intraday derivative instrument data flow.', `d_h_cre` datetime DEFAULT NULL COMMENT 'System_creation_timestamp : Timestamp when the trade has been created in the system.', `d_h_cancel` datetime DEFAULT NULL COMMENT 'System_cancellation_timestamp: Timestamp when the trade has been cancelled in the system.', `c_int_prc` int(10) unsigned NOT NULL, `c_int_tlg_buy` bigint(15) DEFAULT NULL COMMENT 'buy tradeleg internal id', `c_int_tlg_sell` bigint(15) DEFAULT NULL COMMENT 'buy tradeleg internal id', PRIMARY KEY (`c_int_trd`,`d_bus`), UNIQUE KEY `d_bus` (`d_bus`,`d_trd`,`c_clro`,`c_ext_trd`,`c_int_inst`,`c_int_trd_venue`,`y_sec_loan`), KEY `c_int_inst` (`c_int_inst`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Trade' 1 row in set (0.00 sec) ERROR: No query specified