创建字典-insert.sql
24.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-工作性质', 'sys_mc_job_nature', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-缴费方式', 'sys_mc_payment_meth', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-收费类型', 'sys_mc_charge_type', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-拜访工单类型', 'sys_mc_visit_type', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-拜访工单状态', 'sys_mc_visit_status', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-是否意向用户', 'sys_mc_visit_intent', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-房屋情况', 'sys_mc_visit_house', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-现用能源', 'sys_mc_visit_energy', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-家电状态', 'sys_mc_visit_appliance_status', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-决策人收入来源', 'sys_mc_visit_dm_income', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-家庭人口', 'sys_mc_visit_members', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-点火确认', 'sys_mc_ign_status', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-施工-未竣工原因(扫雷行动项目)', 'sys_mc_construction_sl_rsn', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-施工-未竣工原因(新开空白项目)', 'sys_mc_construction_kb_rsn', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-未点火原因', 'sys_mc_ignition_rsn', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('拜访-施工-未完成原因(运营维护)', 'sys_mc_construction_yy_rsn', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_job_nature', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '兼职', '兼职', 'sys_mc_job_nature', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '全职', '全职', 'sys_mc_job_nature', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '微信', 'WeChat', 'sys_mc_payment_meth', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '支付宝', 'Alipay', 'sys_mc_payment_meth', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '现金', 'cash', 'sys_mc_payment_meth', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '信用卡', 'card', 'sys_mc_payment_meth', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '转账', 'bank_transfer', 'sys_mc_payment_meth', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '其他', '0', 'sys_mc_charge_type', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '定金', '1', 'sys_mc_charge_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '全款', '2', 'sys_mc_charge_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '分期', '4', 'sys_mc_charge_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '其他', '0', 'sys_mc_visit_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '拜访', '1', 'sys_mc_visit_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '收费', '2', 'sys_mc_visit_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '拜访+收费', '3', 'sys_mc_visit_type', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_visit_intent', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '意向用户', '意向用户', 'sys_mc_visit_intent', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '无意向用户', '无意向用户', 'sys_mc_visit_intent', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '观望用户', '观望用户', 'sys_mc_visit_intent', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_visit_house', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '新', '新', 'sys_mc_visit_house', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '一般', '一般', 'sys_mc_visit_house', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '旧', '旧', 'sys_mc_visit_house', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_visit_energy', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '烧柴', '烧柴', 'sys_mc_visit_energy', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '烧煤', '烧煤', 'sys_mc_visit_energy', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '液化气', '液化气', 'sys_mc_visit_energy', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '电', '电', 'sys_mc_visit_energy', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_visit_appliance_status', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '新', '新', 'sys_mc_visit_appliance_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '旧', '旧', 'sys_mc_visit_appliance_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '未知', 'sys_mc_visit_dm_income', 'default', 'N', '1', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '公职人员', '公职人员', 'sys_mc_visit_dm_income', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '务农', '务农', 'sys_mc_visit_dm_income', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '务工', '务工', 'sys_mc_visit_dm_income', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '个体', '个体', 'sys_mc_visit_dm_income', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '无', '无', 'sys_mc_visit_dm_income', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '1人', '1人', 'sys_mc_visit_members', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '2人', '2人', 'sys_mc_visit_members', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '3人', '3人', 'sys_mc_visit_members', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '4人及以上', '4人及以上', 'sys_mc_visit_members', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '待修改', 'EDITING', 'sys_mc_visit_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '已完成', 'APPROVED', 'sys_mc_visit_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '待审批', 'APPROVE', 'sys_mc_visit_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '已作废', 'CANCEL', 'sys_mc_visit_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '待维护', 'MAINTENANCE', 'sys_mc_ign_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '已维护(是)', 'MAINTENANCE_YES', 'sys_mc_ign_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '已维护(否)', 'MAINTENANCE_NO', 'sys_mc_ign_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '已作废', 'CANCEL', 'sys_mc_ign_status', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '市场报装率未达到工程进场条件', '市场报装率未达到工程进场条件', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (1, '正在施工', '正在施工', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (2, '市政中压及村内/小区内正在施工', '市政中压及村内/小区内正在施工', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (3, '市政中压已连接，正在施工村内/小区红线内', '市政中压已连接，正在施工村内/小区红线内', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (4, '市政中压及村内/小区调压箱前已完成,调压箱后在施工', '市政中压及村内/小区调压箱前已完成,调压箱后在施工', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (5, '市政中压施工中，村内/小区内户外工程已完工', '市政中压施工中，村内/小区内户外工程已完工', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (6, '已完工待移交', '已完工待移交', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (7, '已完工存在整改项，整改后移交', '已完工存在整改项，整改后移交', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (8, '已完工但竣工资料未完成', '已完工但竣工资料未完成', 'sys_mc_construction_sl_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '市场报装率未达到工程进场条件', '市场报装率未达到工程进场条件', 'sys_mc_construction_kb_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (1, '进场准备中', '进场准备中', 'sys_mc_construction_kb_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (2, '正在施工', '正在施工', 'sys_mc_construction_kb_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '工程原因不具备点火条件（自有队伍）', '工程原因不具备点火条件（自有队伍）', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (1, '工程原因不具备点火条件（增值）', '工程原因不具备点火条件（增值）', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (2, '工程原因不具备点火条件（工建施工队伍）', '工程原因不具备点火条件（工建施工队伍）', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (3, '运行未置换到表前', '运行未置换到表前', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (4, '市场原因未点火：未回款/无地址/无联系人员', '市场原因未点火：未回款/无地址/无联系人员', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (5, '户内不具备点火条件用气设备未到位（需转增值进行开发）', '户内不具备点火条件用气设备未到位（需转增值进行开发）', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (6, '空房/毛坯房', '空房/毛坯房', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (7, '工程部未移交客服', '工程部未移交客服', 'sys_mc_ignition_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (0, '正在置换通气市政中压', '正在置换通气市政中压', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (1, '市政中压已通气，正在通气村内/支线中压和调压箱', '市政中压已通气，正在通气村内/支线中压和调压箱', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (2, '村内/支线中压和调压箱已通气正在通气庭院管/架空管', '村内/支线中压和调压箱已通气正在通气庭院管/架空管', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (3, '庭院管/架空管已通气正在通气户外立管/户内立管', '庭院管/架空管已通气正在通气户外立管/户内立管', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (4, '庭院管/架空管已通气正在通气户外立管/户内立管，试压/保压不合格，需要客服入户检', '庭院管/架空管已通气正在通气户外立管/户内立管，试压/保压不合格，需要客服入户检', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (5, '查户内燃气设施是否末端没有关闭或封闭', '查户内燃气设施是否末端没有关闭或封闭', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (6, '通气人员不足正在协调安排', '通气人员不足正在协调安排', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (7, '置换通气方案正在制定审批阶段', '置换通气方案正在制定审批阶段', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (8, '通气过程有阻工正在协调解决', '通气过程有阻工正在协调解决', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (9, '设备故障或损坏正在维修', '设备故障或损坏正在维修', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, list_class, is_default, status, create_by, create_time, remark) VALUES (10, '管道被破坏存在断点正在修复', '管道被破坏存在断点正在修复', 'sys_mc_construction_yy_rsn', 'default', 'N', '0', '0', NOW(), '市场化收费');