# lis、pacs视图
|
# 地址：10.100.100.205
|
# 数据库名：ltkjview
|
# 用户：ltkjview
|
# 密码：ltkj@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;
|
|
# 外送PDF报告表
|
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报告单base64串',
|
jpg_base64 text NULL COMMENT 'jpg报告单base64串'
|
) COMMENT '外送PDF回传';
|
|
# 清库
|
TRUNCATE TABLE tb_transition;
|
TRUNCATE TABLE tj_order;
|
TRUNCATE TABLE tj_order_ycxm;
|
TRUNCATE TABLE tj_order_detail;
|
TRUNCATE TABLE tj_order_remark;
|
TRUNCATE TABLE tj_order_detail_rules;
|
TRUNCATE TABLE ltkj_hysqd;
|
TRUNCATE TABLE ltkj_hybgd;
|
TRUNCATE TABLE ltkj_exam_jcsqd;
|
TRUNCATE TABLE ltkj_exam_jcbgd;
|
TRUNCATE TABLE tj_jcycxm;
|
TRUNCATE TABLE tj_sampling;
|
TRUNCATE TABLE tj_report;
|
TRUNCATE TABLE tj_reservation;
|
TRUNCATE TABLE tj_wsxm;
|
TRUNCATE TABLE tj_zhxm;
|
TRUNCATE TABLE tj_xd_picture;
|
TRUNCATE TABLE tj_xdtgmdjg;
|
TRUNCATE TABLE tj_report_print;
|
TRUNCATE TABLE tj_flowing_water;
|
TRUNCATE TABLE tj_flowing_water_his;
|
TRUNCATE TABLE tj_dw_grouping;
|
TRUNCATE TABLE tj_grouping_pro;
|
TRUNCATE TABLE tj_customer;
|
TRUNCATE TABLE tj_dw_dept;
|
TRUNCATE TABLE tj_customer_black;
|
TRUNCATE TABLE tj_ask_historys;
|
TRUNCATE TABLE tj_ask_medical_history;
|
TRUNCATE TABLE tj_ask_work_log;
|
