tba-gx-guochan/docs/init-dict-biz-type.sql

-- =============================================
-- 业务类型数据字典初始化脚本
-- 字典类型编码: gx_biz_type
-- =============================================

-- 1. 插入字典类型
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES ('业务类型', 'gx_biz_type', '0', 'admin', SYSDATE, 'admin', SYSDATE, '数据交换业务域的业务类型');

-- 2. 插入字典数据
INSERT INTO sys_dict_data (dict_type, dict_value, dict_label, dict_sort, status, create_by, create_time, update_by, update_time, remark)
VALUES ('gx_biz_type', '水位', '水位', 1, '0', 'admin', SYSDATE, 'admin', SYSDATE, '水位相关业务');

INSERT INTO sys_dict_data (dict_type, dict_value, dict_label, dict_sort, status, create_by, create_time, update_by, update_time, remark)
VALUES ('gx_biz_type', '水质', '水质', 2, '0', 'admin', SYSDATE, 'admin', SYSDATE, '水质相关业务');

INSERT INTO sys_dict_data (dict_type, dict_value, dict_label, dict_sort, status, create_by, create_time, update_by, update_time, remark)
VALUES ('gx_biz_type', '调度', '调度', 3, '0', 'admin', SYSDATE, 'admin', SYSDATE, '调度相关业务');

INSERT INTO sys_dict_data (dict_type, dict_value, dict_label, dict_sort, status, create_by, create_time, update_by, update_time, remark)
VALUES ('gx_biz_type', '工程', '工程', 4, '0', 'admin', SYSDATE, 'admin', SYSDATE, '工程相关业务');

-- =============================================
-- 后续如需扩增业务类型，直接执行以下INSERT语句即可：
-- =============================================
-- INSERT INTO sys_dict_data (dict_type, dict_value, dict_label, dict_sort, status, create_by, create_time, update_by, update_time, remark)
-- VALUES ('gx_biz_type', '新类型值', '新类型名称', 排序号, '0', 'admin', SYSDATE, 'admin', SYSDATE, '备注说明');