mer_stage 表有 216423 条记载，DDL：
CREATE TABLE `mer_stage` ( `STAGE_ID` int(11) NOT NULL AUTO_INCREMENT, `MER_ID` int(11) NOT NULL, `MER_CODE` varchar(16) DEFAULT NULL, `MER_NAME` varchar(80) NOT NULL, `INS_CODE` varchar(16) NOT NULL, `INS_NAME` varchar(64) DEFAULT NULL, `AGENT_CODE` varchar(16) DEFAULT NULL, `AGENT_NAME` varchar(64) DEFAULT NULL, `BIG_CATEGORY_NAME` varchar(32) DEFAULT NULL, `SUB_CATEGORY_CODE` char(4) DEFAULT NULL, `SUB_CATEGORY_NAME` varchar(64) DEFAULT NULL, `LICENSE_CODE` varchar(64) DEFAULT NULL, `LICENSE_NAME` varchar(64) DEFAULT NULL, `SHORT_NAME` varchar(25) DEFAULT NULL, `MER_STATUS` tinyint(4) DEFAULT NULL, `PROVINCE_NAME` varchar(16) DEFAULT NULL, `CITY_CODE` char(4) DEFAULT NULL, `CITY_NAME` varchar(12) DEFAULT NULL, `REGISTER_ADDRESS` varchar(128) DEFAULT NULL, `BIZ_ADDRESS` varchar(128) DEFAULT NULL, `TAX_REGISTRATION` varchar(32) DEFAULT NULL, `INSTITUTION` varchar(16) DEFAULT NULL, `LEGAL_NAME` varchar(40) DEFAULT NULL, `LEGAL_CARD` varchar(32) DEFAULT NULL, `LEGAL_PHONE` varchar(16) DEFAULT NULL, `BIZ_SCOPE` varchar(128) DEFAULT NULL, `BIZ_CONTENT` varchar(64) DEFAULT NULL, `BIZ_TIME` varchar(32) DEFAULT NULL, `LICENSE_EXPIRED` varchar(16) DEFAULT NULL, `AVG_SINGLE_TRADE` int(11) DEFAULT NULL, `AVG_MONTH_TRADE` int(11) DEFAULT NULL, `BIZ_PLACE_OWNER` varchar(64) DEFAULT NULL, `REGISTERED_CAPITAL` decimal(11,0) DEFAULT NULL, `PAID_IN_CAPITAL` int(11) DEFAULT NULL, `BIZ_PERIOD` tinyint(4) DEFAULT NULL, `BIZ_AREA` int(11) DEFAULT NULL, `SETTLE_PERIOD` tinyint(4) DEFAULT NULL, `DELAY_TIME` varchar(50) DEFAULT NULL, `DELAY_TYPE` tinyint(4) DEFAULT "0", `BANK_CODE` varchar(40) DEFAULT NULL, `BRANCH_CODE` varchar(25) DEFAULT NULL, `BRANCH_CODE_ONE` varchar(25) DEFAULT NULL, `BRANCH_CODE_TWO` varchar(25) DEFAULT NULL, `BRANCH_NAME` varchar(128) DEFAULT NULL, `ACCOUNT_CODE` varchar(32) DEFAULT NULL, `ACCOUNT_NAME` varchar(80) DEFAULT NULL, `BRANCH_PROVINCE` varchar(32) DEFAULT NULL, `BRANCH_CITY_CODE` varchar(10) DEFAULT NULL, `BRANCH_CITY_NAME` varchar(50) DEFAULT NULL, `SETTLE_CURRENCY` varchar(16) DEFAULT NULL, `SETTLE_PARAM` char(1) DEFAULT NULL, `CUP_TYPE` tinyint(4) NOT NULL DEFAULT "1", `CUP_CD` varchar(6) DEFAULT NULL, `CUP_NM` varchar(80) DEFAULT NULL, `UPI_TYPE` tinyint(4) NOT NULL DEFAULT "1", `UPI_CD` varchar(6) DEFAULT NULL, `UPI_NM` varchar(80) DEFAULT NULL, `VISA_EDC_FEE` double DEFAULT NULL, `VISA_DCC_FEE` double DEFAULT NULL, `MASTERCARD_EDC_FEE` double DEFAULT NULL, `MASTERCARD_DCC_FEE` double DEFAULT NULL, `JCB_EDC_FEE` double DEFAULT NULL, `AE_EDC_FEE` double DEFAULT NULL, `DC_EDC_FEE` double DEFAULT NULL, `CONTACT_NAME` varchar(40) DEFAULT NULL, `CONTACT_FIXED` varchar(32) DEFAULT NULL, `CONTACT_MOBILE` varchar(32) DEFAULT NULL, `CONTACT_FAX` varchar(32) DEFAULT NULL, `CONTACT_EMAIL` varchar(80) DEFAULT NULL, `CONTACT_ADDRESS` varchar(128) DEFAULT NULL, `CONTACT_ZIP` varchar(8) DEFAULT NULL, `biz_license` text COMMENT "营业执照", `tax_register_cert` text COMMENT "税务登记证", `ins_cert` text COMMENT "组织机构代码证", `legal_id_card` text COMMENT "法人身份证", `open_license` text COMMENT "开户许可证", `auth_letter` text COMMENT "授权书", `portal_photo` text COMMENT "门头照片", `cashier_photo` text COMMENT "收银台照片", `scene_photo` text COMMENT "经营场景照片", `mer_agreement` text COMMENT "商户协定", `other_qualification` text COMMENT "其他特别资质", `EXPECT_OPEN_TIME` datetime DEFAULT NULL, `IN_OUT_FLAG` varchar(32) DEFAULT NULL, `DCC_MODE` int(2) DEFAULT "0", `SPECIAL_FLAG` tinyint(4) DEFAULT NULL, `TRADING_CURRENCY` varchar(3) DEFAULT NULL, `STATUS` int(11) DEFAULT "0", `EDITABLE` tinyint(4) DEFAULT NULL, `MER_SINGLE_LIMIT` decimal(30,5) DEFAULT NULL, `MER_DAY_LIMIT` decimal(30,5) DEFAULT NULL, `MER_NATION` varchar(3) DEFAULT NULL, `ROUTE_SCHEME` varchar(13) DEFAULT NULL, `CREATOR_ID` int(11) DEFAULT NULL, `CREATOR_NAME` varchar(32) DEFAULT NULL, `create_time` datetime NOT NULL COMMENT "记载创立时光", `modify_time` datetime NOT NULL COMMENT "最好修正时光", `TERM_CNT` int(11) DEFAULT NULL, `DATA_SRC` tinyint(4) NOT NULL DEFAULT "1", `CUP_CARD_PLAN` bit(1) DEFAULT NULL, `UPI_CARD_PLAN` bit(1) DEFAULT NULL, `RISK_DESC` varchar(50) DEFAULT NULL, `IS_FLAG` char(1) DEFAULT NULL, `ALP` decimal(22,3) DEFAULT NULL, `WXP` decimal(22,3) DEFAULT NULL, `dfs_edc_fee` decimal(22,3) DEFAULT NULL, `prp_edc_fee` decimal(22,3) DEFAULT NULL, `in_account_id_card` text COMMENT "入账人身份证", `in_account_bank_card` text COMMENT "入账银行卡信息", `ins_credit_card` text COMMENT "机构信誉代码证", `ins_store_photo` text COMMENT "仓库照片", `lease_agreement` text COMMENT "租赁协定", `sct` decimal(22,3) DEFAULT NULL COMMENT "扫码支付（支付宝、微信整合）", `card_type` char(1) DEFAULT "1" COMMENT "法人证件类型(1:身份证,2:护照)", PRIMARY KEY (`STAGE_ID`), KEY `mer_stage_s_e_ms` (`STATUS`,`EDITABLE`,`MER_STATUS`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=216826 DEFAULT CHARSET=utf8;CREATE TABLE `mer_stag
