From c1d14d0a0487dde751fc823f111604a30005f65e Mon Sep 17 00:00:00 2001 From: 陈昶聿 <chychen@nbjetron.com> Date: 星期一, 12 十月 2026 17:36:15 +0800 Subject: [PATCH] 【丽水】专科档案生成配置 --- /dev/null | 28 ---------------------------- 1 files changed, 0 insertions(+), 28 deletions(-) diff --git a/sql/pat_specific_archive_generate_config_20261012.sql b/sql/pat_specific_archive_generate_config_20261012.sql deleted file mode 100644 index 3dbee0c..0000000 --- a/sql/pat_specific_archive_generate_config_20261012.sql +++ /dev/null @@ -1,28 +0,0 @@ --- ============================================================================= --- 涓撶妗ｆ鐢熸垚閰嶇疆琛� --- author : 鏅鸿兘闅忚 --- date : 2026-10-12 --- 璇存槑 : 閰嶇疆鍝簺绉戝/鐥呭尯 + 璇婃柇缁勫悎鍙嚜鍔ㄧ敓鎴愬搴旂被鍨嬬殑涓撶妗ｆ --- ============================================================================= - -DROP TABLE IF EXISTS pat_specific_archive_generate_config; -CREATE TABLE pat_specific_archive_generate_config -( - id INT(11) NOT NULL AUTO_INCREMENT COMMENT '閰嶇疆琛ㄤ富閿甀D', - dept_type CHAR(1) NULL DEFAULT NULL COMMENT '閮ㄩ棬绫诲瀷锛�1绉戝锛�2鐥呭尯', - dept_category CHAR(1) NULL DEFAULT NULL COMMENT '閮ㄩ棬鍒嗙被: 1濡囩 2鍎跨', - archive_type VARCHAR(255) NULL DEFAULT NULL COMMENT '妗ｆ绫诲瀷: 濡囩妗ｆ绫诲瀷(1 鏃╁瓡鍏崇埍2 鍥寸粷缁忔湡MHI),鍎跨妗ｆ绫诲瀷(1钀ュ吇鎬х柧鐥� 2瀛︿範鍥伴毦 3楂樺嵄鍎夸笓妗�)', - dept_codes TEXT NULL DEFAULT NULL COMMENT '绉戝Code闆嗗悎(JSON鏍煎紡锛屽 ["D001","D002"])', - icd10_codes TEXT NULL DEFAULT NULL COMMENT '璇婃柇code闆嗗悎(JSON鏍煎紡锛屽 ["E10.901","E11.901"])', - remark VARCHAR(500) NULL DEFAULT NULL COMMENT '澶囨敞', - orgid VARCHAR(500) NULL DEFAULT NULL COMMENT '鍖婚櫌鏈烘瀯ID', - campusid VARCHAR(255) NULL DEFAULT NULL COMMENT '闄㈠尯ID', - update_by VARCHAR(32) NULL DEFAULT NULL COMMENT '鏇存柊浜�', - update_time DATETIME NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', - create_by VARCHAR(32) NULL DEFAULT NULL COMMENT '鍒涘缓浜�', - create_time DATETIME NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', - del_flag CHAR(1) NULL DEFAULT '0' COMMENT '鍒犻櫎鏍囧織锛�0锛氭湭鍒犻櫎锛�1锛氬凡鍒犻櫎锛�', - PRIMARY KEY (`id`) USING BTREE, - INDEX `idx_specific_archive_generate_config_query` (`orgid`, `dept_type`, `archive_type`) USING BTREE, - INDEX `idx_specific_archive_generate_config_org` (`orgid`, `del_flag`) USING BTREE -) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COMMENT = '涓撶妗ｆ鐢熸垚閰嶇疆琛�'; -- Gitblit v1.9.3