INSERT INTO `mapping` (`id`, `key`, `pKey`, `name`, `type`, `action`, `createdAt`, `is_secret`, `mKey`, `mpKey`) VALUES (11, 'PATIENT', 'DATA', '患者信息', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (12, 'NAME', 'PATIENT', '患者名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (13, 'INSUR_CARD_NO', 'PATIENT', '医保卡号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (14, 'ID_CARD_CODE', 'PATIENT', '证件类型编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (15, 'ID_CARD', 'PATIENT', '证件类型', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (16, 'ID_CARDNUM', 'PATIENT', '证件号码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (17, 'GENDER', 'PATIENT', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (18, 'GENDER_CODE', 'PATIENT', '性别编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (19, 'BIRTH_DATE', 'PATIENT', '生日', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (20, 'MARITAL_STATUS_CODE', 'PATIENT', '婚姻状况编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (21, 'MARITAL_STATUS', 'PATIENT', '婚姻状况', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (22, 'ADDRESS', 'PATIENT', '居住地址', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (23, 'ECARD_NO', 'PATIENT', '虚拟就诊卡号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (24, 'MEDICAL_INFORMATION', 'DATA', '就诊信息', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (25, 'SERIESNUM', 'MEDICAL_INFORMATION', '就诊序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (26, 'CLASS_CODE', 'MEDICAL_INFORMATION', '就诊类型编号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (27, 'CLASS', 'MEDICAL_INFORMATION', '就诊类型', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (28, 'ENCOUNTER_CARD_NO', 'MEDICAL_INFORMATION', '住院号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (29, 'RECORD_CODE', 'MEDICAL_INFORMATION', '住院病历号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (30, 'HOS_EMPI', 'MEDICAL_INFORMATION', '医院主索引', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (31, 'NAME', 'MEDICAL_INFORMATION', '患者姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (32, 'ENCOUNTER_DATE', 'MEDICAL_INFORMATION', '就诊日期', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (33, 'DEPTNAME', 'MEDICAL_INFORMATION', '就诊科室名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (34, 'CHIEFCOMPLAINT', 'MEDICAL_INFORMATION', '主诉', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (35, 'ORGCODE', 'MEDICAL_INFORMATION', '机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (36, 'ORGNAME', 'MEDICAL_INFORMATION', '机构名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (37, 'AGE', 'MEDICAL_INFORMATION', '年龄', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (38, 'GENDER', 'MEDICAL_INFORMATION', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (39, 'GENDER_CODE', 'MEDICAL_INFORMATION', '性别代码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (40, 'DIAGNOSES', 'DATA', '诊断信息(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (41, 'DIAGNOSE', 'DIAGNOSES', '诊断信息', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (42, 'DIAGNOSECODE', 'DIAGNOSE', '诊断编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (43, 'DIAGNOSENAME', 'DIAGNOSE', '诊断名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (44, 'EXAM_APPLICATIONS', 'DATA', '检查申请单(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (45, 'EXAM_APPLICATION', 'EXAM_APPLICATION', '检查申请单', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (46, 'REQUESTID', 'EXAM_APPLICATION', '申请单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (47, 'NAME', 'EXAM_APPLICATION', '患者姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (48, 'SERIESNUM', 'EXAM_APPLICATION', '就诊序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (49, 'DEVICETYPE', 'EXAM_APPLICATION', '检查类型', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (50, 'DEVICETYPE_CODE', 'EXAM_APPLICATION', '检查类型编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (51, 'EXAM_ITEMNAME', 'EXAM_APPLICATION', '检查项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (52, 'EXAM_ITEMNAME_CODE', 'EXAM_APPLICATION', '检查项目编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (53, 'BODYSITE_CATEG', 'EXAM_APPLICATION', '检查部位分类', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (54, 'BODYSITE_CATEG_CODE', 'EXAM_APPLICATION', '检查部位分类编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (55, 'BODYSITE', 'EXAM_APPLICATION', '检查部位', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (56, 'EXAM_METHOD', 'EXAM_APPLICATION', '检查方法', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (57, 'ORGCODE', 'EXAM_APPLICATION', '申请机构', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (58, 'ORGNAME', 'EXAM_APPLICATION', '申请机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (59, 'DEPTNAME', 'EXAM_APPLICATION', '申请科室名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (60, 'PRACTITIONERNAME', 'EXAM_APPLICATION', '申请医生姓名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (61, 'REQUESTTIME', 'EXAM_APPLICATION', '申请时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (62, 'GENDER', 'EXAM_APPLICATION', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (63, 'GENDER_CODE', 'EXAM_APPLICATION', '性别编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (64, 'AGE', 'EXAM_APPLICATION', '年龄', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (65, 'MEDICAL_ORDERS', 'DATA', '检验申请单(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (66, 'MEDICAL_ORDER', 'MEDICAL_ORDERS', '检验申请单', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (67, 'ORDERID', 'MEDICAL_ORDER', '医嘱ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (68, 'NAME', 'MEDICAL_ORDER', '患者姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (69, 'SERIESNUM', 'MEDICAL_ORDER', '就诊序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (70, 'LAB_ITEMNAME', 'MEDICAL_ORDER', '检验项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (71, 'LAB_ITEMNAME_CODE', 'MEDICAL_ORDER', '检验项目编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (72, 'SPECIMEN_TYPE', 'MEDICAL_ORDER', '标本类别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (73, 'SPECIMEN_NUM', 'MEDICAL_ORDER', '标本号/条码号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (74, 'SPECIMEN_STATUS', 'MEDICAL_ORDER', '标本状态', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (75, 'SPECIMEN_COLLETIME', 'MEDICAL_ORDER', '标本采样时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (76, 'SPECIMEN_RECEITIME', 'MEDICAL_ORDER', '标本接收时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (77, 'ORGCODE', 'MEDICAL_ORDER', '申请机构', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (78, 'ORGNAME', 'MEDICAL_ORDER', '申请机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (79, 'DEPTNAME', 'MEDICAL_ORDER', '申请科室名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (80, 'PRACTITIONERNAME', 'MEDICAL_ORDER', '申请医生姓名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (81, 'REQUESTTIME', 'MEDICAL_ORDER', '申请时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (82, 'REPORTSTATUS', 'MEDICAL_ORDER', '报告状态', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (83, 'REPORTSTATUS_CODE', 'MEDICAL_ORDER', '报告状态编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (84, 'GENDER', 'MEDICAL_ORDER', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (85, 'GENDER_CODE', 'MEDICAL_ORDER', '性别编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (86, 'AGE', 'MEDICAL_ORDER', '年龄', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (87, 'EXAM_REPORTS', 'DATA', '检查报告(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (88, 'EXAM_REPORT', 'EXAM_REPORTS', '检查报告', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (89, 'NAME', 'EXAM_REPORT', '患者姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (90, 'SERIESNUM', 'EXAM_REPORT', '就诊序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (91, 'EXAM_REQUESTID', 'EXAM_REPORT', '申请单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (92, 'REPORTID', 'EXAM_REPORT', '报告单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (93, 'EXAM_ITEMNAME', 'EXAM_REPORT', '检查项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (94, 'BODYSITE_CATEG', 'EXAM_REPORT', '检查部位分类', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (95, 'BODYSITE_CATEG_CODE', 'EXAM_REPORT', '检查部位分类编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (96, 'BODYSITE', 'EXAM_REPORT', '检查部位', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (97, 'OBSERVATIONS_COMMENT', 'EXAM_REPORT', '影像所见', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (98, 'OBSERVATIONS_RESULT', 'EXAM_REPORT', '意见', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (99, 'IMAGES', 'EXAM_REPORT', '报告图片', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (100, 'DICOM_INDEXID', 'EXAM_REPORT', '影像图片索引ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (101, 'ORGCODE', 'EXAM_REPORT', '报告机构', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (102, 'ORGNAME', 'EXAM_REPORT', '报告机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (103, 'DEPTNAME', 'EXAM_REPORT', '报告科室名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (104, 'PRACTITIONERNAME', 'EXAM_REPORT', '报告医生姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (105, 'AUDITNAME', 'EXAM_REPORT', '审核医师姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (106, 'REPORTTIME', 'EXAM_REPORT', '报告时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (107, 'REPORTSTATUS', 'EXAM_REPORT', '报告状态', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (108, 'GENDER', 'EXAM_REPORT', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (109, 'GENDER_CODE', 'EXAM_REPORT', '性别编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (110, 'AGE', 'EXAM_REPORT', '年龄', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (111, 'INSPECT_REPORTS', 'DATA', '检验报告(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (112, 'INSPECT_REPORT', 'INSPECT_REPORTS', '检验报告', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (113, 'NAME', 'INSPECT_REPORT', '患者姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (114, 'SERIESNUM', 'INSPECT_REPORT', '就诊序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (115, 'EXAM_REQUESTID', 'INSPECT_REPORT', '申请单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (116, 'REPORTID', 'INSPECT_REPORT', '报告单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (117, 'LAB_ITEMNAME', 'INSPECT_REPORT', '检验项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (118, 'LAB_ITEMNAME_CODE', 'INSPECT_REPORT', '检验项目编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (119, 'LAB_ITEMNAME_NUMBER', 'INSPECT_REPORT', '检验项目序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (120, 'LAB_HR_STATUS', 'INSPECT_REPORT', '是否互认项目标识', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (121, 'LAB_HR_ITEMNAME', 'INSPECT_REPORT', '互认项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (122, 'LAB_HR_ITEMNAME_CODE', 'INSPECT_REPORT', '互认项目编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (123, 'SPECIMEN_TYPE', 'INSPECT_REPORT', '标本类别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (124, 'ORGCODE', 'INSPECT_REPORT', '报告机构', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (125, 'ORGNAME', 'INSPECT_REPORT', '报告机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (126, 'DEPTNAME', 'INSPECT_REPORT', '报告科室名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (127, 'PRACTITIONERNAME', 'INSPECT_REPORT', '报告医生姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (128, 'AUDITNAME', 'INSPECT_REPORT', '审核医师姓名', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (129, 'REPORTTIME', 'INSPECT_REPORT', '报告时间', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (130, 'REPORTSTATUS', 'INSPECT_REPORT', '报告状态', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (131, 'GENDER', 'INSPECT_REPORT', '性别', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (132, 'GENDER_CODE', 'INSPECT_REPORT', '性别编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (133, 'AGE', 'INSPECT_REPORT', '年龄', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (134, 'INSPECT_REPORT_ITEMS', 'INSPECT_REPORT', '检验报告明细(多条)', 'Array', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (135, 'INSPECT_REPORT_ITEM', 'INSPECT_REPORT_ITEMS', '检验报告明细', 'object', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (136, 'EXAM_REQUESTID', 'INSPECT_REPORT_ITEM', '申请单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (137, 'REPORTID', 'INSPECT_REPORT_ITEM', '报告单ID', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (138, 'ORGCODE', 'INSPECT_REPORT_ITEM', '报告机构编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (139, 'LAB_ITEMDETAILNAME', 'INSPECT_REPORT_ITEM', '检验细项名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (140, 'LAB_ITEMDETAILNAME_NUMBER', 'INSPECT_REPORT_ITEM', '检验细项序号', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (141, 'LAB_ITEMDETAILNAME_CODE', 'INSPECT_REPORT_ITEM', '检验细项编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (142, 'LAB_ITEMDETAILVALUE', 'INSPECT_REPORT_ITEM', '检验细项测量值', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (143, 'LAB_ITEMDETAILSPEC', 'INSPECT_REPORT_ITEM', '检验细项结果计量单位', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (144, 'LAB_ITEMDETAILINTERPRETATION', 'INSPECT_REPORT_ITEM', '检验细项结果', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (145, 'LAB_ITEMDETAILRANGE', 'INSPECT_REPORT_ITEM', '参考值范围', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (146, 'CRITICAL_RANGE', 'INSPECT_REPORT_ITEM', '危急值范围', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (147, 'LAB_HR_ITEMDETAIL_STATUS', 'INSPECT_REPORT_ITEM', '是否互认项目标识', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (148, 'LAB_HR_ITEMDETAILNAME', 'INSPECT_REPORT_ITEM', '互认项目名称', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL), (149, 'LAB_HR_ITEMDETAILNAME_CODE', 'INSPECT_REPORT_ITEM', '互认项目编码', 'string', NULL, '2024-07-30 18:22:57', '0', NULL, NULL);