尊敬的客户：
您有一条安灯呼叫通知，请及时处理。
${#andonCallTable}
","attachments":[{"name":"","location":""}]}', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-19 14:20:55','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-20 11:38:25','SYYYY-MM-DD HH24:MI:SS'), 1, 0, '000000'); INSERT INTO blade_notify_template (id, name, provider, type, business, template, create_user, create_dept, create_time, update_user, update_time, status, is_deleted, tenant_id) VALUES ('1604724291476983810', '安灯呼叫', 'embedded', 'email', 'andon-take-over', '{"subject":"安灯呼叫","content":"尊敬的客户：
您有一条安灯呼叫通知，请及时处理。
${#andonCallTable}
","attachments":[{"name":"","location":""}]}', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-19 14:24:20','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201,TO_DATE('2022-12-20 11:38:28','SYYYY-MM-DD HH24:MI:SS'), 1, 0, '000000'); CREATE TABLE "BLADE_ANDON_REASON" ( "ID" NUMBER(20,0) VISIBLE NOT NULL, "STATUS" NUMBER(4,0) VISIBLE, "IS_DELETED" NUMBER(11,0) VISIBLE, "CREATE_USER" NUMBER(20,0) VISIBLE, "CREATE_DEPT" NUMBER(20,0) VISIBLE, "CREATE_TIME" DATE VISIBLE, "UPDATE_USER" NUMBER(20,0) VISIBLE, "UPDATE_TIME" DATE VISIBLE, "ANDON_TYPE_ID" NUMBER(20,0) VISIBLE, "CODE" NVARCHAR2(200) VISIBLE, "NAME" NVARCHAR2(200) VISIBLE, "REMARK" NVARCHAR2(200) VISIBLE ) LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "BLADE_ANDON_REASON"."ID" IS '主键'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."STATUS" IS '状态'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."IS_DELETED" IS '删除状态：0-未删除，1-已删除'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."CREATE_USER" IS '创建人'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."CREATE_DEPT" IS '创建部门'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."UPDATE_USER" IS '更新人'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."ANDON_TYPE_ID" IS '安灯类型id'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."CODE" IS '安灯原因编号'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."NAME" IS '安灯原因名称'; COMMENT ON COLUMN "BLADE_ANDON_REASON"."REMARK" IS '安灯原因备注'; COMMENT ON TABLE "BLADE_ANDON_REASON" IS '安灯原因表'; CREATE TABLE "BLADE_ANDON_RECORD_REASON" ( "ID" NUMBER(20,0) VISIBLE NOT NULL, "STATUS" NUMBER(4,0) VISIBLE, "IS_DELETED" NUMBER(11,0) VISIBLE, "CREATE_USER" NUMBER(20,0) VISIBLE, "CREATE_DEPT" NUMBER(20,0) VISIBLE, "CREATE_TIME" DATE VISIBLE, "UPDATE_USER" NUMBER(20,0) VISIBLE, "UPDATE_TIME" DATE VISIBLE, "RECORD_ID" NUMBER(20,0) VISIBLE, "REASON_ID" NUMBER(20,0) VISIBLE, "REASON_CODE" NVARCHAR2(200) VISIBLE, "REASON_NAME" NVARCHAR2(200) VISIBLE ) LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."ID" IS '主键'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."STATUS" IS '状态'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."IS_DELETED" IS '删除状态：0-未删除，1-已删除'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."CREATE_USER" IS '创建人'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."CREATE_DEPT" IS '创建部门'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."UPDATE_USER" IS '更新人'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."RECORD_ID" IS '安灯记录id'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."REASON_ID" IS '安灯原因id'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."REASON_CODE" IS '安灯原因编号'; COMMENT ON COLUMN "BLADE_ANDON_RECORD_REASON"."REASON_NAME" IS '安灯原因名称'; COMMENT ON TABLE "BLADE_ANDON_RECORD_REASON" IS '记录关联原因表'; CREATE TABLE "BLADE_ANDON_TYPE" ( "ID" NUMBER(20,0) VISIBLE NOT NULL, "STATUS" NUMBER(4,0) VISIBLE, "IS_DELETED" NUMBER(11,0) VISIBLE, "CREATE_USER" NUMBER(20,0) VISIBLE, "CREATE_DEPT" NUMBER(20,0) VISIBLE, "CREATE_TIME" DATE VISIBLE, "UPDATE_USER" NUMBER(20,0) VISIBLE, "UPDATE_TIME" DATE VISIBLE, "CODE" NVARCHAR2(64) VISIBLE, "NAME" NVARCHAR2(64) VISIBLE, "REMARK" NVARCHAR2(64) VISIBLE ) LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."ID" IS '主键'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."STATUS" IS '状态'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."IS_DELETED" IS '删除状态：0-未删除，1-已删除'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."CREATE_USER" IS '创建人'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."CREATE_DEPT" IS '创建部门'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."UPDATE_USER" IS '更新人'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."CODE" IS '安灯类型编号'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."NAME" IS '安灯类型名称'; COMMENT ON COLUMN "BLADE_ANDON_TYPE"."REMARK" IS '安灯类型备注'; COMMENT ON TABLE "BLADE_ANDON_TYPE" IS '安灯类型表'; ALTER TABLE "BLADE_ANDON_REASON" ADD CONSTRAINT "SYS_C0011766" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table BLADE_ANDON_REASON -- ---------------------------- ALTER TABLE "BLADE_ANDON_REASON" ADD CONSTRAINT "SYS_C0011760" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table BLADE_ANDON_RECORD_REASON -- ---------------------------- ALTER TABLE "BLADE_ANDON_RECORD_REASON" ADD CONSTRAINT "SYS_C0011767" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table BLADE_ANDON_RECORD_REASON -- ---------------------------- ALTER TABLE "BLADE_ANDON_RECORD_REASON" ADD CONSTRAINT "SYS_C0011761" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table BLADE_ANDON_TYPE -- ---------------------------- ALTER TABLE "BLADE_ANDON_TYPE" ADD CONSTRAINT "SYS_C0011765" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table BLADE_ANDON_TYPE -- ---------------------------- ALTER TABLE "BLADE_ANDON_TYPE" ADD CONSTRAINT "SYS_C0011763" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table BLADE_DEVICE_ANDON_TYPE -- ---------------------------- ALTER TABLE "BLADE_DEVICE_ANDON_TYPE" ADD CONSTRAINT "SYS_C0011764" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- 安灯菜单 INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1602111145162227714, 0, 'andon', '安灯呼叫', 'andon', '', 'iconfont saber-andenghujiao1', 13, 0, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1602111671861952513, 1602111145162227714, 'andon_type', '安灯类型及原因', 'andon_type', '/andon/type/index', '', 1, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1602112490741088257, 1602111145162227714, 'andon_receive', '安灯接收', 'andon_receive', '/andon/receive/index', '', 2, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1602113671727071233, 1602111145162227714, 'andon_record', '安灯确认记录', 'andon_record', '/andon/record/index', '', 4, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1602864491879800833, 0, 'hmi_andon', '安灯呼叫', 'him_andon', '/andon', '', 3, 1, 0, 1, '', 0, 'HMI', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092010330398721, 1602111671861952513, 'andon_type_create', '安灯类型新建', 'andon_type_create', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092147387670530, 1602111671861952513, 'andon_type_update', '安灯类型编辑', 'andon_type_update', '', '', 2, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092308927094786, 1602111671861952513, 'andon_type_delete', '安灯类型删除', 'andon_type_delete', '', '', 3, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092495254855681, 1602111671861952513, 'andon_reason_create', '安灯原因新建', 'andon_reason_create', '', '', 4, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092634002432001, 1602111671861952513, 'andon_reason_update', '安灯原因编辑', 'andon_reason_update', '', '', 5, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605092837174517761, 1602111671861952513, 'andon_reason_delete', '安灯原因删除', 'andon_reason_delete', '', '', 6, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1605100621270065153, 1602113671727071233, 'andon_record_export', '安灯记录导出', 'andon_record_export', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1); -- 安灯呼叫 权限 INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398104164126722, 1605092010330398721, 'andon_type.save_andon_type', '新增安灯类型', '/blade-andon/andon-type', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:01:50','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:01:50','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398140197392386, 1605092147387670530, 'andon_type.update_andon_type', '修改安灯类型', '/blade-andon/andon-type', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:01:58','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:01:58','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398195218272257, 1605092308927094786, 'andon_type.remove_andon_type', '删除安灯类型', '/blade-andon/andon-type', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:02:11','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:02:11','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398272020172801, 1605092495254855681, 'andon_reason.add_reason', '新增安灯呼叫原因', '/blade-andon/andon-reason/add', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:02:30','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:02:30','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398307009056770, 1605092634002432001, 'andon_reason.update_reason', '编辑安灯呼叫原因', '/blade-andon/andon-reason/update', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:02:38','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:02:38','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605398401993265153, 1605092837174517761, 'andon_reason.remove_reason', '删除呼叫原因', '/blade-andon/andon-reason', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:03:01','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:03:01','SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1605401019445858306, 1605100621270065153, 'andon_record.export_record', '导出安灯呼叫确认记录', '/blade-andon/andon-record/export-record', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-21 11:13:25','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-21 11:13:25','SYYYY-MM-DD HH24:MI:SS'), 1, 0); -- 安灯呼叫编码规则 INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted) VALUES (1603265689953021954, 1456091305266442242, 'code_rule_for_biz_objects', 'Andon', '安灯呼叫', 37, '', 0, 0); INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted) VALUES (1603266236370169857, 1603265689953021954, 'code_rule_for_biz_objects', 'AndonType', '安灯类型', 0, '', 0, 0); INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted) VALUES (1605083882327089153, 1603265689953021954, 'code_rule_for_biz_objects', 'AndonReson', '安灯原因', 0, '', 0, 0); INSERT INTO blade_bas_coderule (id, name, remark, bill_form_id, system_default, auto_billno, repair_billno, const_length, create_user, create_dept, create_time, update_user, update_time, status, is_deleted, rule_field_dict_key, preview) VALUES (1603267927865864194, '安灯类型', '安灯类型编码', 'AndonType', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-15 13:57:16','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-15 13:57:18','SYYYY-MM-DD HH24:MI:SS'), 1, 0, NULL, 'AD2022121501'); INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format, element_value, seed, increment_step, separator_char, re_char, add_char, cut_style, add_style, code_only_by, code_element) VALUES (1603267927891030018, 1603267927865864194, 1, 1, '', NULL, 2, '', 'AD', 1, 1, '', '', '', 1, 0, 0, 1); INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format, element_value, seed, increment_step, separator_char, re_char, add_char, cut_style, add_style, code_only_by, code_element) VALUES (1603267927899418626, 1603267927865864194, 2, 2, 'create_time', NULL, 8, 'yyyyMMdd', '', 1, 1, '', '', '', 1, 0, 0, 1); INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format, element_value, seed, increment_step, separator_char, re_char, add_char, cut_style, add_style, code_only_by, code_element) VALUES (1603267927899418627, 1603267927865864194, 3, 0, '', NULL, 2, '', '', 1, 1, '', '', '0', 1, 0, 0, 1); INSERT INTO blade_bas_coderule (id, name, remark, bill_form_id, system_default, auto_billno, repair_billno, const_length, create_user, create_dept, create_time, update_user, update_time, status, is_deleted, rule_field_dict_key, preview) VALUES (1605085317328510978, '安灯原因编码', '安灯原因编码', 'AndonReson', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201, TO_DATE('2022-12-20 14:18:55','SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-12-20 14:19:04','SYYYY-MM-DD HH24:MI:SS'), 1, 0, NULL, '01'); INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format, element_value, seed, increment_step, separator_char, re_char, add_char, cut_style, add_style, code_only_by, code_element) VALUES (1605085317353676801, 1605085317328510978, 1, 5, 'andon_type_id', 1, 0, '', '', 1, 1, '', '', '', 1, 0, 0, 1); INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format, element_value, seed, increment_step, separator_char, re_char, add_char, cut_style, add_style, code_only_by, code_element) VALUES (1605085317353676802, 1605085317328510978, 2, 0, '', NULL, 2, '', '', 1, 1, '', '', '0', 1, 0, 0, 1); -- 安灯编码规则脚本 INSERT INTO blade_meta_ref_object_type (object_type_id, ref_object_type_id, field_name, id) VALUES ('AndonReson', 'AndonType', 'andon_type_id', 1605085049543172097); INSERT INTO blade_meta_object_type_field (id, object_id, f_code, f_name, field, element_type, enum_type, seq) VALUES (1603266904938033153, 'AndonType', 'create_time', '创建时间', 'createTime', '2', NULL, 0); INSERT INTO blade_meta_object_type_field (id, object_id, f_code, f_name, field, element_type, enum_type, seq) VALUES (1605085049522200577, 'AndonReson', 'andon_type_id', '安灯类型', 'andonTypeId', '5', NULL, 0); INSERT INTO blade_meta_object_type (f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key, rule_field, rule_dict_code, code) VALUES ('AndonReson', '安灯原因', NULL, 'Andon', 'blade_andon_reason', 'id', 'code', 'id', NULL, NULL, NULL); INSERT INTO blade_meta_object_type (f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key, rule_field, rule_dict_code, code) VALUES ('AndonType', '安灯类型', NULL, 'Andon', 'blade_andon_type', 'id', 'code', 'id', NULL, NULL, NULL);