From 4c11f5d2fdee377db122e89f1908c65bc1899b5b Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期二, 29 四月 2025 08:48:54 +0800 Subject: [PATCH] sql记录 --- ltkj-admin/src/main/resources/sql/陕健医.sql | 30 +++++++++++++++++++++++++----- 1 files changed, 25 insertions(+), 5 deletions(-) diff --git "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" index 0a6732e..181b431 100644 --- "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" +++ "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" @@ -1,17 +1,37 @@ # lis銆乸acs瑙嗗浘 -鍦板潃锛�10.100.100.205 -鏁版嵁搴撳悕锛歭tkjview -鐢ㄦ埛锛歭tkjview -瀵嗙爜锛歭tkj@view -瑙嗗浘 +# 鍦板潃锛�10.100.100.205 +# 鏁版嵁搴撳悕锛歭tkjview +# 鐢ㄦ埛锛歭tkjview +# 瀵嗙爜锛歭tkj@view +# 瑙嗗浘 +/* ltkjview.lis_sqd | his_bodycheck ltkjview.lis_xm | hjlis_ylsf ltkjview.pacs_sqd | v_examhisorderdata ltkjview.pacs_xm | v_examitem +*/ # 杩畨澶栭�佸鎺� # 閲戝爢鍩� CREATE USER 'ltkjwsdian'@'%' IDENTIFIED BY 'ltkj@ws20250320'; GRANT INSERT, UPDATE, DELETE,SELECT ON ltkjpeis10_jdczgzyy.ws_import_result_group TO 'ltkjwsdian'@'%'; +GRANT INSERT, UPDATE, DELETE,SELECT ON ltkjpeis10_jdczgzyy.ws_import_pdf_group TO 'ltkjwsdian'@'%'; GRANT SELECT ON ltkjpeis10_jdczgzyy.ws_export_sample_group TO 'ltkjwsdian'@'%'; +GRANT SELECT ON ltkjpeis10_jdczgzyy.ws_import_pdf_group TO 'ltkjwsdian'@'%'; FLUSH PRIVILEGES; + +# 澶栭�丳DF鎶ュ憡琛� +CREATE TABLE ws_import_pdf_group( + id bigint AUTO_INCREMENT COMMENT '搴忓彿', + sample_no varchar(100) NULL COMMENT '鎸囨牱鏈湪LIS鐨勫敮涓�ID鍙枫�傚鏋滄病鏈夛紝灏卞～鏍锋湰鏉＄爜鍙枫��', + hos_code varchar(100) NULL COMMENT '璐村湪璇曠涓婄殑鏍锋湰鍖婚櫌鏉＄爜鍙枫��', + patient_no varchar(100) NULL COMMENT '鎮ｈ�呭敮涓�ID锛屾垨鑰呭敮涓�灏辫瘖鍗″彿銆佺ぞ淇濆崱鍙�', + out_patient_no varchar(100) NULL COMMENT '闂ㄨ瘖鍙�', + pdf_file varchar(255) NULL COMMENT '鎶ュ憡鏂囦欢璺緞', + report_date datetime NULL COMMENT '鎶ュ憡鏃ユ湡', + is_read varchar(30) NULL COMMENT '鏄惁涓嬭浇', + create_time datetime NULL COMMENT '鍒涘缓鏃ユ湡', + da_barcode varchar(100) NULL COMMENT '杩畨鏉＄爜', + pdf_base64 text NULL COMMENT 'pdf鎶ュ憡鍗昩ase64涓�', + jpg_base64 text NULL COMMENT 'jpg鎶ュ憡鍗昩ase64涓�' +) COMMENT '澶栭�丳DF鍥炰紶'; -- Gitblit v1.8.0