zjrs-jeecgBoot/.docs/sql/字典数据/职业指导服务-补充字典数据.sql

-- ============================================================
-- 就业一湛通服务平台 - 职业指导服务模块 补充字典数据
-- 数据库：达梦数据库 (DM8)
-- 创建日期：2026-06-12
-- 说明：消息中心通过 notification_module 字典映射 moduleType 到中文名称
-- ============================================================

INSERT INTO DICTIONARY_ITEM (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable)
SELECT '100060100023', 'career_guidance', 'notification_module', 5, '职业指导', 5, 1, 0
WHERE NOT EXISTS (SELECT 1 FROM DICTIONARY_ITEM WHERE DictionaryCode = 'notification_module' AND Code = 'career_guidance');

INSERT INTO DICTIONARY_ITEM (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable)
SELECT '100060100024', 'preliminary_eligible', 'notification_module', 6, '初步符合条件人员', 6, 1, 0
WHERE NOT EXISTS (SELECT 1 FROM DICTIONARY_ITEM WHERE DictionaryCode = 'notification_module' AND Code = 'preliminary_eligible');