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
| -- =====================================================
| -- 医院科室字典配置
| -- 创建时间: 2025-10-19
| -- 说明: 用于急救转运任务中的医院科室选择
| -- =====================================================
|
| -- 1. 添加科室字典类型
| INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, remark)
| VALUES('医院科室', 'hospital_department', '0', 'admin', SYSDATE(), '医院科室列表');
|
| -- 2. 添加常用科室字典数据
| -- 急诊相关
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(1, '急诊科', '急诊科', 'hospital_department', '', 'danger', 'Y', '0', 'admin', SYSDATE(), '急诊科室');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(2, '急救中心', '急救中心', 'hospital_department', '', 'danger', 'N', '0', 'admin', SYSDATE(), '急救中心');
|
| -- 内科系统
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(3, '心内科', '心内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '心血管内科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(4, '呼吸内科', '呼吸内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '呼吸内科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(5, '消化内科', '消化内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '消化内科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(6, '神经内科', '神经内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '神经内科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(7, '肾内科', '肾内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '肾内科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(8, '内分泌科', '内分泌科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '内分泌科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(9, '血液科', '血液科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '血液科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(10, '风湿免疫科', '风湿免疫科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '风湿免疫科');
|
| -- 外科系统
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(11, '普外科', '普外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '普通外科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(12, '骨科', '骨科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '骨科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(13, '神经外科', '神经外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '神经外科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(14, '心胸外科', '心胸外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '心胸外科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(15, '泌尿外科', '泌尿外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '泌尿外科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(16, '烧伤科', '烧伤科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '烧伤科');
|
| -- 专科
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(17, 'ICU', 'ICU', 'hospital_department', '', 'warning', 'N', '0', 'admin', SYSDATE(), '重症监护室');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(18, 'CCU', 'CCU', 'hospital_department', '', 'warning', 'N', '0', 'admin', SYSDATE(), '冠心病监护病房');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(19, '肿瘤科', '肿瘤科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '肿瘤科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(20, '感染科', '感染科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '感染科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(21, '儿科', '儿科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '儿科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(22, '妇产科', '妇产科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '妇产科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(23, '眼科', '眼科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '眼科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(24, '耳鼻喉科', '耳鼻喉科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '耳鼻喉科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(25, '口腔科', '口腔科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '口腔科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(26, '皮肤科', '皮肤科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '皮肤科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(27, '康复科', '康复科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '康复科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(28, '中医科', '中医科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '中医科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(29, '精神科', '精神科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '精神科');
|
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
| VALUES(30, '其他科室', '其他科室', 'hospital_department', '', 'default', 'N', '0', 'admin', SYSDATE(), '其他科室');
|
|