slaj/sql/slaj_eng_dict.sql

-- ============================================================
-- 工程属性表 数据字典 (来源: 对象附属信息.docx)
-- 注意: eng_scal(工程规模) 和 eng_grad(工程等别) 在不同工程类型中取值不同
-- ============================================================

-- ============ 通用字典（所有工程类型共用） ============
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('重要程度','slaj_impo_grad','0','admin',now(),'1=水重点 2=省重点 3=市重点') ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('工程状态','slaj_eng_stat','0','admin',now(),'1=在建 2=已建') ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('是否除险加固','slaj_if_rein_force','0','admin',now(),'1=是 2=否 0=未知') ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('启用停用','slaj_stat','0','admin',now(),'1=启用 2=停用') ON CONFLICT (dict_type) DO NOTHING;

-- 重要程度 (表2.5-20/30/40/49/60/70/77/85/91)
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'水重点','1','slaj_impo_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'省重点','2','slaj_impo_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'市重点','3','slaj_impo_grad','0','admin',now());

-- 工程状态 (表2.5-21/31/41/50/61/71/78/86/92)
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'在建','1','slaj_eng_stat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'已建','2','slaj_eng_stat','0','admin',now());

-- 是否除险加固 (表2.5-22/32/42/51/62/72/79/87/93)
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'是','1','slaj_if_rein_force','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'否','2','slaj_if_rein_force','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'未知','0','slaj_if_rein_force','0','admin',now());

-- 启用停用 (表2.5-23/33/43/52/63/73/80/88/94)
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'启用','1','slaj_stat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'停用','2','slaj_stat','0','admin',now());

-- ============ 水库 RES (ATT_ENG_RES) 表2.5-19~28 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水库-工程等别','slaj_eng_grad_res','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'Ⅴ等','5','slaj_eng_grad_res','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水库-工程规模','slaj_eng_scal_res','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小(1)型','4','slaj_eng_scal_res','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'小(2)型','5','slaj_eng_scal_res','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水库-坝型材料','slaj_dam_type_mat','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'均质坝','1','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'心墙坝','2','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'斜墙坝','3','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'面板坝','4','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'沥青坝','5','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (6,'混凝土坝','6','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (7,'浆砌石坝','7','slaj_dam_type_mat','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (8,'土工膜坝','8','slaj_dam_type_mat','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水库-坝型结构','slaj_dam_type_str','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'重力坝','1','slaj_dam_type_str','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'拱坝','2','slaj_dam_type_str','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'支墩坝','3','slaj_dam_type_str','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'土石坝','4','slaj_dam_type_str','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水库-泄水建筑物类型','slaj_main_fl_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'岸边溢洪道','1','slaj_main_fl_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'泄洪洞','2','slaj_main_fl_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'泄洪闸','3','slaj_main_fl_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'非常溢洪道','4','slaj_main_fl_type','0','admin',now());

-- ============ 水闸 WAGA (ATT_ENG_WAGA) 表2.5-29~38 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水闸-工程等别','slaj_eng_grad_waga','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'Ⅴ等','5','slaj_eng_grad_waga','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水闸-工程规模','slaj_eng_scal_waga','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小(1)型','4','slaj_eng_scal_waga','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'小(2)型','5','slaj_eng_scal_waga','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水闸-水闸类型','slaj_waga_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'分洪闸','1','slaj_waga_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'排水闸','2','slaj_waga_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'引水闸','3','slaj_waga_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'节制闸','4','slaj_waga_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'挡潮闸','5','slaj_waga_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水闸-消能方式','slaj_ener_diss','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'底流式','1','slaj_ener_diss','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'挑流式','2','slaj_ener_diss','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'面流式','3','slaj_ener_diss','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'其他','4','slaj_ener_diss','0','admin',now());

-- ============ 泵站 PUST (ATT_ENG_PUST) 表2.5-39~47 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('泵站-工程等别','slaj_eng_grad_pust','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'Ⅴ等','5','slaj_eng_grad_pust','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('泵站-工程规模','slaj_eng_scal_pust','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小(1)型','4','slaj_eng_scal_pust','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'小(2)型','5','slaj_eng_scal_pust','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('泵站-泵站类型','slaj_pust_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'排水站','1','slaj_pust_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'灌溉站','2','slaj_pust_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'排灌结合站','3','slaj_pust_type','0','admin',now());

-- ============ 水电站 HYST (ATT_ENG_HYST) 表2.5-48~58 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水电站-工程等别','slaj_eng_grad_hyst','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'Ⅴ等','5','slaj_eng_grad_hyst','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水电站-工程规模','slaj_eng_scal_hyst','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小(1)型','4','slaj_eng_scal_hyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'小(2)型','5','slaj_eng_scal_hyst','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('水电站-类型','slaj_hyst_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'坝后式','1','slaj_hyst_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'引水式','2','slaj_hyst_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'混合式','3','slaj_hyst_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'抽水蓄能','4','slaj_hyst_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('是否农村水电站','slaj_if_rhyst','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'是','1','slaj_if_rhyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'否','2','slaj_if_rhyst','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'未知','0','slaj_if_rhyst','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('是否水库调节能力','slaj_if_rs_pow','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'是','1','slaj_if_rs_pow','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'否','2','slaj_if_rs_pow','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('大坝鉴定类别','slaj_dam_iden_cate','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'一类坝','0','slaj_dam_iden_cate','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'二类坝','1','slaj_dam_iden_cate','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'三类坝','2','slaj_dam_iden_cate','0','admin',now());

-- ============ 堤防 DIKE (ATT_ENG_DIKE) 表2.5-59~68 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-工程等别','slaj_eng_grad_dike','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'Ⅴ等','5','slaj_eng_grad_dike','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-工程规模','slaj_eng_scal_dike','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小(1)型','4','slaj_eng_scal_dike','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'小(2)型','5','slaj_eng_scal_dike','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-级别','slaj_dike_grad','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (0,'未知','0','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'1级','1','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'2级','2','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'3级','3','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'4级','4','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'5级','5','slaj_dike_grad','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (6,'5级以下','9','slaj_dike_grad','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-类型','slaj_dike_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'河堤','1','slaj_dike_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'湖堤','2','slaj_dike_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'海堤','3','slaj_dike_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'围堤','4','slaj_dike_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-所在岸别','slaj_rv_bank','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (0,'未知','0','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'左岸','1','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'右岸','2','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'左省','3','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'右省','4','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'沿岸','5','slaj_rv_bank','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (6,'跨国界','6','slaj_rv_bank','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('是否堤顶道路','slaj_if_road','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'是','1','slaj_if_road','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'否','2','slaj_if_road','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'未知','0','slaj_if_road','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('堤防-设计防洪标准','slaj_des_fl_stand','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'20年','20','slaj_des_fl_stand','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'50年','50','slaj_des_fl_stand','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'100年','100','slaj_des_fl_stand','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'200年','200','slaj_des_fl_stand','0','admin',now());

-- ============ 灌区 IRR (ATT_ENG_IRR) 表2.5-69~75 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('灌区-工程规模','slaj_eng_scal_irr','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大型','1','slaj_eng_scal_irr','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'中型','2','slaj_eng_scal_irr','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'小型','3','slaj_eng_scal_irr','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'其它','9','slaj_eng_scal_irr','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('灌区-渠道最高级别','slaj_chan_lev','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'干渠','1','slaj_chan_lev','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'支渠','2','slaj_chan_lev','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'斗渠','3','slaj_chan_lev','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'农渠','4','slaj_chan_lev','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'毛渠','5','slaj_chan_lev','0','admin',now());

-- ============ 引调水 WADI (ATT_ENG_WADI) 表2.5-76~83 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('引调水-工程等别','slaj_eng_grad_wadi','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ等','1','slaj_eng_grad_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ等','2','slaj_eng_grad_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ等','3','slaj_eng_grad_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ等','4','slaj_eng_grad_wadi','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('引调水-工程规模','slaj_eng_scal_wadi','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大(1)型','1','slaj_eng_scal_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'大(2)型','2','slaj_eng_scal_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'中型','3','slaj_eng_scal_wadi','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'小型','4','slaj_eng_scal_wadi','0','admin',now());

-- ============ 淤地坝 SD (ATT_ENG_SD) 表2.5-84~89 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('淤地坝-工程规模','slaj_eng_scal_sd','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'大型','1','slaj_eng_scal_sd','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'中型','2','slaj_eng_scal_sd','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'小型','3','slaj_eng_scal_sd','0','admin',now());

-- ============ 农村供水 CWS (ATT_ENG_CWS) 表2.5-90~99 ============
INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('农村供水-工程规模','slaj_eng_scal_cws','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'Ⅰ型','1','slaj_eng_scal_cws','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'Ⅱ型','2','slaj_eng_scal_cws','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'Ⅲ型','3','slaj_eng_scal_cws','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'Ⅳ型','4','slaj_eng_scal_cws','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('农村供水-工程类型','slaj_cws_eng_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'新建','1','slaj_cws_eng_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'扩建','2','slaj_cws_eng_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'改造','3','slaj_cws_eng_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('农村供水-取水水源类型','slaj_wint_ws_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'水库','1','slaj_wint_ws_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'河道','2','slaj_wint_ws_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'地下水','3','slaj_wint_ws_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'其他','9','slaj_wint_ws_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('农村供水-供水方式','slaj_wasu_type','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'集中供水','1','slaj_wasu_type','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'分散供水','2','slaj_wasu_type','0','admin',now());

INSERT INTO sys_dict_type (dict_name,dict_type,status,create_by,create_time) VALUES ('农村供水-水净化处理','slaj_wate_puri','0','admin',now()) ON CONFLICT (dict_type) DO NOTHING;
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (1,'常规处理','1','slaj_wate_puri','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (2,'一体化','2','slaj_wate_puri','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (3,'消毒','3','slaj_wate_puri','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (4,'除铁锰','4','slaj_wate_puri','0','admin',now());
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,status,create_by,create_time) VALUES (5,'未处理','5','slaj_wate_puri','0','admin',now());