CREATE TABLE md_commo_info_chanl commo_id int10 NOT NULL COMMENT 商品ID channel_id int10 NOT NULL COMMENT 渠道ID wholesale_price decimal142 DEFAULT NULL COMMENT 批发单价 rp decimal142 DEFAULT NULL COMMEN

This SQL statement creates a table named md_commo_info_chanl with the following columns:

• commo_id: an integer representing the commodity ID
• channel_id: an integer representing the channel ID
• wholesale_price: a decimal number with a precision of 14 and scale of 2, representing the wholesale price
• rp: a decimal number with a precision of 14 and scale of 2, representing the retail price
• member_rp: a decimal number with a precision of 14 and scale of 2, representing the member retail price
• accounting_method: an integer representing the accounting method (0 for wholesale, 1 for consignment, 3 for joint venture, 5 for lease)
• cont_no: a bigint number with a length of 15, representing the contract number
• settle_group_code: an integer representing the settlement rate group code
• settle_code: an integer representing the settlement rate code
• purchase_price_n_rate: a decimal number with a precision of 20 and scale of 8, representing the purchase price without tax
• purchase_price_rate: a decimal number with a precision of 14 and scale of 4, representing the purchase price with tax
• supply_units: a varchar string with a maximum length of 10, representing the supply units
• status: a small integer representing the commodity status (0 for normal, 1 for not reviewed, 2 for eliminated, 4 for suspended, 5 for cleared)
• ou_id_sale: an integer representing the sales department ID
• region_id: an integer representing the region ID
• final_pur_p: a decimal number with a precision of 14 and scale of 2, representing the final purchase price
• min_price: a decimal number with a precision of 14 and scale of 2, representing the minimum retail price
• mark_ni_sale: an integer representing the negative inventory sales status (2 for NI)
• mark_sale_time: an integer representing the time marker for negative inventory sales status
• final_pur_p_n: a decimal number with a precision of 20 and scale of 8, representing the final purchase price without tax
• mark_joint_inventory: an integer representing the joint venture inventory marker
• tm: an integer representing the timestamp
• mark_min_order: a decimal number with a precision of 10 and scale of 3, representing the minimum order quantity
• online_rp: a decimal number with a precision of 14 and scale of 2, representing the online price
• settle_rate: a decimal number with a precision of 10 and scale of 4, representing the settlement rate
• back_rate: a decimal number with a precision of 10 and scale of 4, representing the discount rate
• STATUS_DEAL_ID: an integer representing the status processing ID
• STATUS_DEAL_TYPE: an integer representing the status processing type (1 for joint venture rate adjustment, 2 for commodity status change, 3 for contract expiration, 4 for contract clearance)
• OLD_STATUS: an integer representing the previous status before joint venture rate adjustment
• MARK_MIN_STOCK: a decimal number with a precision of 10 and scale of 3, representing the minimum stock limit
• vip_disc: a decimal number with a precision of 10 and scale of 4, representing the VIP discount rate
• initial_rp: a decimal number with a precision of 14 and scale of 2, representing the initial retail price
• initial_member_rp: a decimal number with a precision of 14 and scale of 2, representing the initial member price
• initial_purchase_price_n_rate: a decimal number with a precision of 14 and scale of 2, representing the initial purchase price without tax
• initial_purchase_price_rate: a decimal number with a precision of 14 and scale of 2, representing the initial purchase price with tax
• initial_online_rp: a decimal number with a precision of 14 and scale of 2, representing the initial online price
• X_TIME: a datetime field that automatically updates the current timestamp
• PRIMARY KEY (commo_id,channel_id)
• INDEX index_comchanl_ou (ou_id_sale)
• INDEX index_comchanl_supplier (supply_units)
• INDEX INDEX_RP (rp)

The table is using the InnoDB storage engine and has a default character set of UTF-8. The table has a comment of '商品渠道信息'