123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141 |
- 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);
|