/* Navicat Premium Data Transfer Source Server : 本机 Source Server Type : MySQL Source Server Version : 50540 Source Host : 127.0.0.1:3306 Source Schema : igds_api Target Server Type : MySQL Target Server Version : 50540 File Encoding : 65001 Date: 08/09/2022 19:39:37 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for api_trigger -- ---------------------------- DROP TABLE IF EXISTS `api_trigger`; CREATE TABLE `api_trigger` ( `ID_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `NAME_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `BIZ_CODE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PARENT_CODE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAL_` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DEFAULT_` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `REMARK_` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of api_trigger -- ---------------------------- INSERT INTO `api_trigger` VALUES ('1', '操作标志', 'CZBZ', '0', '0', 'Y', 'N', '通用'); INSERT INTO `api_trigger` VALUES ('10', '2-采购合同', '2', '0', 'HT_YWLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('100', '10-器材库', '10', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('101', '11-制高点', '11', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('102', '12-周界', '12', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('103', '99-其他', '99', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('104', '违规类型', 'WGLX', '0', '0', 'Y', 'N', '接口1309、'); INSERT INTO `api_trigger` VALUES ('105', '01-亏库短量', '01', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('106', '02-以陈顶新', '02', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('107', '03-转圈粮', '03', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('108', '04-空进空出', '04', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('109', '05-擅自动用或置换、虚假轮换骗取财政补贴', '05', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('11', '3-代储合同', '3', '0', 'HT_YWLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('110', '06-账实不符', '06', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('111', '07-未经批准超轮换架空期', '07', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('112', '08-违规处置食品安全指标超标粮食', '08', '0', 'WGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('113', '处置状态', 'CZZT', '0', '0', 'Y', 'N', '接口1309、'); INSERT INTO `api_trigger` VALUES ('114', '01-未处置', '01', '0', 'CZZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('115', '02-已处置', '02', '0', 'CZZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('116', '主体类型', 'ZTLX', '0', '0', 'Y', 'N', '接口1309、'); INSERT INTO `api_trigger` VALUES ('117', '检验类别', 'JYLB', '0', '0', 'Y', 'N', '接口1310、'); INSERT INTO `api_trigger` VALUES ('118', '01-入仓验收', '01', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('119', '02-出仓检验', '02', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('12', '客户类型', 'KHLX', '0', '0', 'Y', 'N', '接口：1201、'); INSERT INTO `api_trigger` VALUES ('120', '03-3月末普检', '03', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('121', '04-9月末普检', '04', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('122', '05-入仓初检', '05', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('123', '06-月度检查', '06', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('124', '07-3月末库内普查', '07', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('125', '08-9月末库内普查', '08', '0', 'JYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('126', '检验依据', 'JYYJ', '0', '0', 'Y', 'N', '接口1310、'); INSERT INTO `api_trigger` VALUES ('127', '0-其他', '0', '0', 'JYYJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('128', '1-国标', '1', '0', 'JYYJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('129', '指标类别', 'ZBLB', '0', '0', 'Y', 'N', '接口1310、'); INSERT INTO `api_trigger` VALUES ('13', '1-企业', '1', '0', 'KHLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('130', '1-质量指标检验', '1', '0', 'ZBLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('131', '2-储存品质检验', '2', '0', 'ZBLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('132', '3-食品安全检验', '3', '0', 'ZBLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('133', '是和否', '0_1', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('134', '0-否', '0', '0', '0_1', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('135', '1-是', '1', '0', '0_1', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('136', '01-单位', '01', '0', 'ZTLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('137', '02-个人', '02', '0', 'ZTLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('138', '风险类型', 'FXLX', '0', '0', 'Y', 'N', '接口1301、'); INSERT INTO `api_trigger` VALUES ('139', '1-基础设施', '1', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('14', '2-个人', '2', '0', 'KHLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('140', '2-网络安全', '2', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('141', '3-消防安全', '3', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('142', '4-用电安全', '4', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('143', '5-作业安全', '5', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('144', '6-用药风险', '6', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('145', '7-管理风险', '7', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('146', '8-其他风险', '8', '0', 'FXLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('147', '风险分级', 'FXFJ', '0', '0', 'Y', 'N', '接口1301、'); INSERT INTO `api_trigger` VALUES ('148', '1-低风险', '1', '0', 'FXFJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('149', '2-一般风险', '2', '0', 'FXFJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('15', '结算与合同一 致性', 'JSYHTYZX', '0', '0', 'Y', 'N', '接口：1201、'); INSERT INTO `api_trigger` VALUES ('150', '3-较大风险', '3', '0', 'FXFJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('151', '4-重大风险', '4', '0', 'FXFJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('152', '检查害虫方法', 'JCHCFF', '0', '0', 'Y', 'N', '接口1303、'); INSERT INTO `api_trigger` VALUES ('153', '0-远程检测预警', '0', '0', 'JCHCFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('154', '1-人工手动筛查', '1', '0', 'JCHCFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('155', '2-其他', '2', '0', 'JCHCFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('156', '虫粮等级判定', 'CLDJPD', '0', '0', 'Y', 'N', '接口1303、'); INSERT INTO `api_trigger` VALUES ('157', '531-基本无虫粮', '531', '0', 'CLDJPD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('158', '532-一般虫粮', '532', '0', 'CLDJPD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('159', '533-严重虫粮', '533', '0', 'CLDJPD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('16', '1-符合', '1', '0', 'JSYHTYZX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('160', '534-危害虫粮', '534', '0', 'CLDJPD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376003039', '国别', 'GB', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376066117', '阿富汗', '004', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376086402', '阿根廷', '032', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376102432', '澳大利亚', '036', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376123222', '白俄罗斯', '112', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376146803', '巴西', '076', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376182667', '中国', '156', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376228420', '中国香港特别行政区', '344', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376254482', '中国澳门特别行政区', '446', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376267838', '中国台湾', '158', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376304538', '丹麦', '208', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376336457', '印度', '356', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662376364085', '印度尼西亚', '360', '0', 'GB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662445593043', '是否正常', 'NORMAL', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662445662159', '0-正常', '0', '0', 'NORMAL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662445668781', '1-不正常', '1', '0', 'NORMAL', 'Y', 'Y', NULL); INSERT INTO `api_trigger` VALUES ('1662634111352', '证件照类型', 'ZJZLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634139241', '1-居民身份证', '1', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634170479', '2-港澳居民来往内地通行证', '2', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634198953', '3-台湾居民来往大陆通行证', '3', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634213739', '4-护照', '4', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634249420', '5-外国人永久居留身份证', '5', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662634290273', '6-港澳台居民居住证', '6', '0', 'ZJZLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662635137162', '性别', 'XB', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662635154476', '1-男性', '1', '0', 'XB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('1662635168696', '2-女性', '2', '0', 'XB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('17', '2-不符合', '2', '0', 'JSYHTYZX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('19', '开户银行', 'BANK', '0', '0', 'Y', 'N', '接口：1201、'); INSERT INTO `api_trigger` VALUES ('2', 'i-新增', 'i', '0', 'CZBZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('20', '102-中国工商银行', '102', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('21', '103-中国农业银行', '103', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('22', '104-中国银行', '104', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('23', '105-中国建设银行', '105', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('24', '203-中国农业发展银行', '203', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('25', '314-农村商业银行', '314', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('26', '402-农村信用合作社', '402', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('27', '403-中国邮政储蓄', '403', '0', 'BANK', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('28', '999-其他银行', '999', '0', 'BANK', 'Y', 'Y', NULL); INSERT INTO `api_trigger` VALUES ('29', '作业类型', 'ZYLX', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('3', 'u-更新', 'u', '0', 'CZBZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('30', '1-熏蒸作业', '1', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('31', '2-充氮气调作业', '2', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('32', '3-二氧化碳气调作业', '3', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('33', '4-霉变检测', '4', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('34', '5-常规检测', '5', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('35', '9-其他', '9', '0', 'ZYLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('36', '通风目的', 'TFMD', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('37', '1-降温通风', '1', '0', 'TFMD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('38', '2-降水通风', '2', '0', 'TFMD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('39', '3-处理发热粮通风', '3', '0', 'TFMD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('4', 'd-删除', 'd', '0', 'CZBZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('40', '4-均衡粮温通风', '4', '0', 'TFMD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('41', '5-其他目的通风', '5', '0', 'TFMD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('42', '通风类型', 'TFLX', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('43', '1-自然空气通风', '1', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('44', '2-加热空气通风', '2', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('45', '3-冷却空气通风', '3', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('46', '4-内循环控温', '4', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('47', '5-空调控温通风', '5', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('48', '6-维持通风', '6', '0', 'TFLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('49', '风道型式', 'FDXS', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('5', '是和否', 'YN', '0', '0', 'Y', 'N', '通用Y和N'); INSERT INTO `api_trigger` VALUES ('50', '1-一字型', '1', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('51', '2-土字型', '2', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('52', '3-圭字行', '3', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('53', '4-U字型', '4', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('54', '5-横向', '5', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('55', '6-夹底', '6', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('56', '9-其他', '9', '0', 'FDXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('57', '风网设置方式', 'FWSZFS', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('58', '1-地上槽', '1', '0', 'FWSZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('59', '2-地下槽', '2', '0', 'FWSZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('6', '是', 'Y', '0', 'YN', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('60', '3-横向', '3', '0', 'FWSZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('61', '4-径向', '4', '0', 'FWSZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('62', '5-其他', '5', '0', 'FWSZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('63', '送风方式', 'SFFS', '0', '0', 'Y', 'N', '接口1305、'); INSERT INTO `api_trigger` VALUES ('64', '1-压入式通风', '1', '0', 'SFFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('65', '2-吸出式通风', '2', '0', 'SFFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('66', '3-压入与吸出相结合式通风', '3', '0', 'SFFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('67', '4-环流通风', '4', '0', 'SFFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('68', '9-其他', '9', '0', 'SFFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('69', '常规熏蒸方式', 'CGXZFS', '0', '0', 'Y', 'N', '接口1306、'); INSERT INTO `api_trigger` VALUES ('7', '否', 'N', '0', 'YN', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('70', '0-粮面潮解', '0', '0', 'CGXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('71', '1-布袋埋藏', '1', '0', 'CGXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('72', '2-探管', '2', '0', 'CGXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('73', '3-综合施药', '3', '0', 'CGXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('74', '环流熏蒸方式', 'HLXZFS', '0', '0', 'Y', 'N', '接口1306、'); INSERT INTO `api_trigger` VALUES ('75', '0-固定式布置形式', '0', '0', 'HLXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('76', '1-移动式布置形式', '1', '0', 'HLXZFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('77', '环流熏蒸与内环流技术结合', 'HLXZYNHLJSJH', '0', '0', 'Y', 'N', '接口1306、'); INSERT INTO `api_trigger` VALUES ('78', '0-分别使用_固定式', '0', '0', 'HLXZYNHLJSJH', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('79', '1-分别使用_移动式', '1', '0', 'HLXZYNHLJSJH', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('8', '合同-义务类型', 'HT_YWLX', '0', '0', 'Y', 'N', '接口：1201、'); INSERT INTO `api_trigger` VALUES ('80', '2-二合一应用_单向控制', '2', '0', 'HLXZYNHLJSJH', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('81', '3-二合一应用_双向控制', '3', '0', 'HLXZYNHLJSJH', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('82', '施药方法', 'SYFF', '0', '0', 'Y', 'N', '接口1306、'); INSERT INTO `api_trigger` VALUES ('83', '0-潮解法', '0', '0', 'SYFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('84', '1-仓外发生器', '1', '0', 'SYFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('85', '2-钢瓶气', '2', '0', 'SYFF', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('86', '熏蒸效果评价', 'XZXGPJ', '0', '0', 'Y', 'N', '接口1306、'); INSERT INTO `api_trigger` VALUES ('87', '0-良好', '0', '0', 'XZXGPJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('88', '1-一般', '1', '0', 'XZXGPJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('89', '2-不好', '2', '0', 'XZXGPJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('9', '1-销售合同', '1', '0', 'HT_YWLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('90', '安装位置', 'AZWZ', '0', '0', 'Y', 'N', '接口1308、'); INSERT INTO `api_trigger` VALUES ('91', '01-粮库大门', '01', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('92', '02-扦样机', '02', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('93', '03-化验室', '03', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('94', '04-结算室', '04', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('95', '05-地磅房', '05', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('96', '06-库区主干道', '06', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('97', '07-仓间监控', '07', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('98', '08-仓内', '08', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('99', '09-药品间', '09', '0', 'AZWZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('CRK236', '出入库业务类型', 'CRKYWLX', '0', '0', 'Y', 'N', '接口1202、1205'); INSERT INTO `api_trigger` VALUES ('CRK237', '1-出库', '1', '0', 'CRKYWLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('CRK238', '2-入库', '2', '0', 'CRKYWLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG17', '房顶结构', 'FDJG', '0', '0', 'Y', 'N', '接口1103'); INSERT INTO `api_trigger` VALUES ('FDJG18', '01-大型屋面板', '01', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG19', '02-混凝土', '02', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG20', '03-钢板', '03', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG21', '04-双T板', '04', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG22', '05-彩钢板', '05', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('FDJG23', '06-其它', '06', '0', 'FDJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('GWXZ114', '岗位性质', 'GWXZ', '0', '0', 'Y', 'N', '接口1112、'); INSERT INTO `api_trigger` VALUES ('GWXZ115', '11-在岗职工(长期)', '11', '0', 'GWXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('GWXZ116', '12-在岗职工(临时)', '12', '0', 'GWXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('GWXZ117', '20-其他从业人员', '20', '0', 'GWXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ121', '民族', 'MZ', '0', '0', 'Y', 'N', '接口1112、'); INSERT INTO `api_trigger` VALUES ('MZ122', '01-汉族', '01', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ123', '02-蒙古族', '02', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ124', '03-回族', '03', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ125', '04-藏族', '04', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ126', '05-维吾尔族', '05', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ127', '06-苗族', '06', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ128', '07-彝族', '07', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ129', '08-壮族', '08', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ130', '09-布依族', '09', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ131', '10-朝鲜族', '10', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ132', '11-满族', '11', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ133', '12-侗族', '12', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ134', '13-瑶族', '13', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ135', '14-白族', '14', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ136', '15-土家族', '15', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ137', '16-哈尼族', '16', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ138', '17-哈萨克族', '17', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ139', '18-傣族', '18', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ140', '19-黎族', '19', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ141', '20-僳僳族', '20', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ142', '21-佤族', '21', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ143', '22-畲族', '22', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ144', '23-高山族', '23', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ145', '24-拉祜族', '24', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ146', '25-水族', '25', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ147', '26-东乡族', '26', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ148', '27-纳西族', '27', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ149', '28-景颇族', '28', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ150', '29-柯尔克孜族', '29', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ151', '30-土族', '30', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ152', '31-达斡尔族', '31', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ153', '32-仫佬族 ', '32', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ154', '33-羌族 ', '33', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ155', '34-布朗族', '34', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ156', '35-撒拉族', '35', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ157', '36-毛难族', '36', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ158', '37-仡佬', '37', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ159', '38-锡伯族', '38', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ160', '39-阿昌族', '39', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ161', '40-普米族', '40', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ162', '41-塔吉克族', '41', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ163', '42-怒族', '42', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ164', '43-乌孜别克族', '43', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ165', '44-俄罗斯族', '44', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ166', '45-鄂温克族', '45', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ167', '46-崩龙族', '46', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ168', '47-保安族', '47', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ169', '48-裕固族', '48', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ170', '49-京族', '49', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ171', '50-塔塔尔族', '50', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ172', '51-独龙族', '51', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ173', '52-鄂伦春族', '52', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ174', '53-赫哲族', '53', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ175', '54-门巴族', '54', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ176', '55-珞巴族', '55', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('MZ177', '56-基诺族', '56', '0', 'MZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('QTJG11', '墙体结构', 'QTJG', '0', '0', 'Y', 'N', '接口1103'); INSERT INTO `api_trigger` VALUES ('QTJG12', '01-钢筋砼', '01', '0', 'QTJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('QTJG13', '02-砖混', '02', '0', 'QTJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('QTJG14', '03-钢板', '03', '0', 'QTJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('QTJG15', '04-砼', '04', '0', 'QTJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('QTJG16', '99-其他', '99', '0', 'QTJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB192', '人员类别', 'RYLB', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB193', '1100-公务员', '1100', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB194', '1200-事业单位管理人员', '1200', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB195', '1300-企业经营管理人员', '1300', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB196', '1400-专业技术人员', '1400', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB197', '1410-高级职称', '1410', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB198', '1411-正高级职称', '1411', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB199', '1420-中级职称', '1420', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB200', '1430-初级及以下职称', '1430', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB201', '1431-主要专职保管人员', '1431', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB202', '1432-主要专职检化验人员', '1432', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB203', '1500-工人', '1500', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB204', '1510-技术工人', '1510', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB205', '1511-高级技师', '1511', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB206', '1512-技师', '1512', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB207', '1513-高级工', '1513', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB208', '1514-中级工', '1514', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('RQLB209', '1515-初级工', '1515', '0', 'RYLB', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic10', '9-其他', '9', '0', 'KQCQ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic100', '4-其他', '4', '0', 'SBZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic24', '房架结构', 'FJJG', '0', '0', 'Y', 'N', '接口1103'); INSERT INTO `api_trigger` VALUES ('tic244', '检斤类型', 'JJLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic245', '0-称重入库', '0', '0', 'JJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic246', '1-标准包入库', '1', '0', 'JJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic247', '粮食包装物', 'LSBZW', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic248', '1-麻袋', '1', '0', 'LSBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic249', '2-编织袋', '2', '0', 'LSBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic25', '01-预制折线型板', '01', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic250', '3-散装', '3', '0', 'LSBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic251', '9-其他', '9', '0', 'LSBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic252', '扦样方式', 'QYFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic253', '0-人工', '0', '0', 'QYFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic254', '1-自动', '1', '0', 'QYFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic255', '2-智能随机', '2', '0', 'QYFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic256', '检验结果', 'JYJG', '0', '0', 'Y', 'N', '接口1103'); INSERT INTO `api_trigger` VALUES ('tic257', '0-不合格', '0', '0', 'JYJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic258', '1-合格', '1', '0', 'JYJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic259', '结算方式', 'JSFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic26', '02-现浇拱板', '02', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic260', '0-现金', '0', '0', 'JSFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic261', '1-转账', '1', '0', 'JSFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic262', '发票状态', 'FPZT', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic263', '1-正常', '1', '0', 'FPZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic264', '0-作废', '0', '0', 'FPZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic265', '倒仓类型', 'DCLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic266', '0-倒仓', '0', '0', 'DCLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic267', '1-移库', '1', '0', 'DCLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic268', '管理方式', 'GLFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic269', '01-直储', '01', '0', 'GLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic27', '03-钢架', '03', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic270', '02-代储', '02', '0', 'GLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic271', '03-租仓', '03', '0', 'GLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic272', '04-委托', '04', '0', 'GLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic273', '收储地点', 'SCDD', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic274', '1-库内', '1', '0', 'SCDD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic275', '2-库外', '2', '0', 'SCDD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic276', '储粮方式', 'CLFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic277', '1-散装储粮', '1', '0', 'CLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic278', '2-包装储粮', '2', '0', 'CLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic279', '3-围包散存', '3', '0', 'CLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic28', '04-木屋架', '04', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic280', '9-其他', '9', '0', 'CLFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic281', '货位状态', 'HWZT', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic282', '1-空仓', '1', '0', 'HWZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic283', '2-入库中', '2', '0', 'HWZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic284', '3-封仓', '3', '0', 'HWZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic285', '4-出库中', '4', '0', 'HWZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic286', '9-其他', '9', '0', 'HWZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic287', '月结标志', 'YJBZ', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic288', '0-月结', '0', '0', 'YJBZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic289', '1-未月结', '1', '0', 'YJBZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic29', '05-土门式刚架', '05', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic30', '06-双T板', '06', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic31', '07-其它', '07', '0', 'FJJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic32', '地面结构', 'DMJG', '0', '0', 'Y', 'N', '接口1103'); INSERT INTO `api_trigger` VALUES ('tic33', '01-防水混凝土', '01', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic34', '02-砖混', '02', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic35', '03-砂浆', '03', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic36', '04-钢筋混凝土楼板式地面', '04', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic37', '05-临时地坪', '05', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic38', '06-其它', '06', '0', 'DMJG', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic39', '挡粮门型式', 'DLMXS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic40', '01-一字型挡粮板', '01', '0', 'DLMXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic41', '02-三角形挡粮门', '02', '0', 'DLMXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic410', '轮换类型', 'LHLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic411', '1-轮出', '1', '0', 'LHLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic412', '2-轮入', '2', '0', 'LHLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic413', '项目类型', 'XMLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic414', '1-财政预算内资金项目', '1', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic415', '2-专项资金项目', '2', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic416', '3-财政预算外资金项目', '3', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic417', '4-银行贷款项目', '4', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic418', '5-债券项目', '5', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic419', '6-外商投资项目', '6', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic42', '03-弧形挡粮门', '03', '0', 'DLMXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic420', '7-企业自筹资金项目', '7', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic421', '8-其他资金项目', '8', '0', 'XMLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic422', '建设状态', 'JSZT', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic423', '1-已立项未开工', '1', '0', 'JSZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic424', '2-建设中', '2', '0', 'JSZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic425', '3-已验收', '3', '0', 'JSZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic426', '4-已取消', '4', '0', 'JSZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic427', '粮食性质', 'LSXZ', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic428', '储备粮', '100', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic429', '中央储备粮', '110', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic43', '04-围包', '04', '0', 'DLMXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic430', '地方储备粮', '120', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic431', '省(自治区、直辖市)级地方储备粮', '121', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic432', '市(地区、自治州、盟)级地方储备粮', '122', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic433', '县级地方储备粮', '123', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic434', '其他储备粮', '129', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic435', '商品粮', '200', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic436', '中储粮系统商品粮', '270', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic437', '进口商品粮', '280', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic438', '其他商品粮', '290', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic439', '政策性粮食', '300', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic44', '05-其它型式', '05', '0', 'DLMXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic440', '最低收购价粮', '310', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic441', '国家临时存储粮', '320', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic442', '国家临储进口粮', '330', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic443', '地方临时存储粮', '340', '0', 'LSXZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic444', '粮食等级', 'LSDJ', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic445', '一等', '01', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic446', '二等', '02', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic447', '三等', '03', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic448', '四等', '04', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic449', '五等', '05', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic450', '等外', '06', '0', 'LSDJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic451', '粮食品种', 'LSPZ', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic452', '小麦及混合小麦', '1110000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic453', '玉米', '1120000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic454', '稻谷', '1130000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic455', '粟(谷子)', '1140000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic456', '高粱', '1150000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic457', '糙米', '1160000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic458', '大麦和米大麦', '1170000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic459', '其他谷物', '1190000', '0', 'LSPZ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic48', '9-其他或不确定', '9', '0', '0_1', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic49', '储粮功效', 'CLGX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic5', '库区产权', 'KQCQ', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic50', '0-A类仓房', '0', '0', 'CLGX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic51', '1-B类仓房', '1', '0', 'CLGX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic52', '2-C类仓房', '2', '0', 'CLGX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic53', '3-D类仓房', '3', '0', 'CLGX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic54', '级别', 'LEVEL', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic55', '1-Ⅰ级', '1', '0', 'LEVEL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic56', '2-Ⅱ级', '2', '0', 'LEVEL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic57', '3-Ⅲ级', '3', '0', 'LEVEL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic58', '4-Ⅳ级(隔热性能和气密性使用)', '4', '0', 'LEVEL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic59', '粮情技术', 'LQJS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic6', '1-自有', '1', '0', 'KQCQ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic60', '1-Ⅰ级', '1', '0', 'LQJS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic61', '2-Ⅱ级', '2', '0', 'LQJS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic62', '3-Ⅲ级', '3', '0', 'LQJS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic63', '4-无粮情检测技术。', '4', '0', 'LQJS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic64', '通风系统型式', 'TFXTXS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic65', '0-竖向通风', '0', '0', 'TFXTXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic66', '1-横向通风', '1', '0', 'TFXTXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic67', '2-径向通风', '2', '0', 'TFXTXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic68', '3-全网板通风', '3', '0', 'TFXTXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic69', '4-其它', '4', '0', 'TFXTXS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic7', '2-租赁', '2', '0', 'KQCQ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic70', '检测方式', 'HCJCFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic71', '01-远程检测预警', '01', '0', 'HCJCFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic72', '02-人工手动筛查', '02', '0', 'HCJCFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic73', '03-其他方式', '03', '0', 'HCJCFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic74', '仓房状态', 'CFZT', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic75', '1-完好', '1', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic76', '2-需小修', '2', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic77', '3-需大修', '3', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic78', '4-待报废', '4', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic79', '5-待拆除', '5', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic8', '3-共有', '3', '0', 'KQCQ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic80', '6-死角仓', '6', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic81', '9-其他', '9', '0', 'CFZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic82', '油罐类型', 'YGLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic83', '1-立式油罐', '1', '0', 'YGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic84', '2-卧式油罐', '2', '0', 'YGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic85', '3-油槽(池)', '3', '0', 'YGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic86', '4-地下油罐', '4', '0', 'YGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic87', '5-其他', '5', '0', 'YGLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic88', '检定方式', 'JDFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic89', '1-标定', '1', '0', 'JDFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic9', '4-混合', '4', '0', 'KQCQ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic90', '0-非标定', '0', '0', 'JDFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic91', '9-其他或不确定', '9', '0', 'JDFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic92', '焊接方式', 'HJFS', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic93', '1-对接', '1', '0', 'HJFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic94', '2-搭接', '2', '0', 'HJFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic95', '9-其他或不确定', '9', '0', 'HJFS', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic96', '设备状态', 'SBZT', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic97', '1-完好', '1', '0', 'SBZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic98', '2-报废', '2', '0', 'SBZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('tic99', '3-待检修', '3', '0', 'SBZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX108', '文件类型', 'WJLX', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX109', '1-库区鸟瞰图', '1', '0', 'WJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX110', '2-入库图片', '2', '0', 'WJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX111', '3-出库图片', '3', '0', 'WJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX112', '4-入库检斤视频', '4', '0', 'WJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('WJLX113', '5-出库检斤视频', '5', '0', 'WJLX', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL210', '学历', 'XL', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL211', '0-研究生', '0', '0', 'XL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL212', '1-大学本科', '1', '0', 'XL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL213', '2-大学专科', '2', '0', 'XL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL214', '3-中专', '3', '0', 'XL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('XL215', '4-高中及以下', '4', '0', 'XL', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJBZW101', '药剂包装物', 'YJBZW', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJBZW102', '1-瓶装', '1', '0', 'YJBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJBZW103', '2-袋装', '2', '0', 'YJBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJBZW104', '3-其他', '3', '0', 'YJBZW', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJCCDD105', '药剂储存地点', 'YJCCDD', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJCCDD106', '1-药剂库', '1', '0', 'YJCCDD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YJCCDD107', '2-其他', '2', '0', 'YJCCDD', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YSGJ239', '运输工具', 'YSGJ', '0', '0', 'Y', 'N', '接口1202、1205'); INSERT INTO `api_trigger` VALUES ('YSGJ240', '1-汽车', '1', '0', 'YSGJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YSGJ241', '2-火车', '2', '0', 'YSGJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YSGJ242', '3-轮船', '3', '0', 'YSGJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('YSGJ243', '9-其他', '9', '0', 'YSGJ', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZGZT118', '在岗状态', 'ZGZT', '0', '0', 'Y', 'N', '接口1112、'); INSERT INTO `api_trigger` VALUES ('ZGZT119', '01-在岗', '01', '0', 'ZGZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZGZT120', '02-已离职', '02', '0', 'ZGZT', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM178', '政治面貌', 'ZZMM', '0', '0', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM179', '01-中国共产党党员', '01', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM180', '02-中国共产党预备党员', '02', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM181', '03-中国共产主义青年团团员', '03', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM182', '04-中国国民党革命委员会会员', '04', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM183', '05-中国主同盟盟员', '05', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM184', '06-中国民主建国会会员', '06', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM185', '07-中国民主促进会会员', '07', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM186', '08-中国农工民主党党员', '08', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM187', '09-中国致公党党员', '09', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM188', '10-九三学社社员', '10', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM189', '11-台湾民主自治同盟盟员', '11', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM190', '12-无党派民主人士', '12', '0', 'ZZMM', 'Y', 'N', NULL); INSERT INTO `api_trigger` VALUES ('ZZMM191', '13-群众', '13', '0', 'ZZMM', 'Y', 'N', NULL); SET FOREIGN_KEY_CHECKS = 1;