# 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;