天际健康规则表备份删除创建

admin

备份：
create table pdss.hospital_drug_dosage5521 as select * from pdss.hospital_drug_dosage;
create table pdss.hospital_dosage_advanced5521 as select * from pdss.hospital_dosage_advanced;

--create table pdss.hospital_indication5521 as select * from pdss.hospital_indication;

create table pdss.hospital_concentration5521 as select * from pdss.hospital_concentration;
create table pdss.hospital_drug_repeat5521 as select * from pdss.hospital_drug_repeat;
create table pdss.hospital_incompatibility5521 as select * from pdss.hospital_incompatibility;
create table pdss.hospital_interaction5521 as select * from pdss.hospital_interaction;

insert into pdss.hospital_indication5521（drug_lo_name,
drug_general_name,
drug_trade_name,
flag,
direction_id,
direction_indication_str,
direction_indication,
indication,
pass_indication,
anti_indication,
--indication_long,
drug_lo_id,
drug_form,
drug_spec,
drug_producer,
dosage_units,
caution_eq01,
caution_eq02,
caution_eq03,
caution_in01,
caution_in02,
caution_in03,
caution_indi,
ref,
indication_indi,
pass_indication_str,
direction_indication_in02,
direction_indication_in03,
direction_indication_in04,
indication_in02,
indication_in03,
indication_in04,
indication_pt01,
indication_pt02,
indication_pt03,
caution_pt01,
caution_pt02,
caution_pt03,
caution_str,
id,
indication_pt_and,
create_time,
create_user,
modify_reason,
modify_time,
modify_user,
pinyin_code,
pre_id,
rule_status,
rule_type,
rule_custom,
kbe_rule_id,
kbe_rule_code,
num_of_reqd,
issue_rule_state,
check_forbid,
item_all_flip,
item_all_accord）select drug_lo_name,
drug_general_name,
drug_trade_name,
flag,
direction_id,
direction_indication_str,
direction_indication,
indication,
pass_indication,
anti_indication,
--indication_long,
drug_lo_id,
drug_form,
drug_spec,
drug_producer,
dosage_units,
caution_eq01,
caution_eq02,
caution_eq03,
caution_in01,
caution_in02,
caution_in03,
caution_indi,
ref,
indication_indi,
pass_indication_str,
direction_indication_in02,
direction_indication_in03,
direction_indication_in04,
indication_in02,
indication_in03,
indication_in04,
indication_pt01,
indication_pt02,
indication_pt03,
caution_pt01,
caution_pt02,
caution_pt03,
caution_str,
id,
indication_pt_and,
create_time,
create_user,
modify_reason,
modify_time,
modify_user,
pinyin_code,
pre_id,
rule_status,
rule_type,
rule_custom,
kbe_rule_id,
kbe_rule_code,
num_of_reqd,
issue_rule_state,
check_forbid,
item_all_flip,
item_all_accord from pdss.hospital_indication;


修改编码：
select * from pdss.hospital_indication a where length(a.drug_lo_id)<6;

update pdss.hospital_interaction a set a.drug_id_2=0||a.drug_id_2 where length(a.drug_id_2)<6;

删除住院数据：
drop table inppdss.hospital_drug_dosage;
drop table  inppdss.hospital_dosage_advanced;
truncate table inppdss.hospital_indication;
drop table inppdss.hospital_concentration;
drop table inppdss.hospital_drug_repeat;
drop table inppdss.hospital_incompatibility;
drop table inppdss.hospital_interaction;

门诊规则转移至住院数据：（适应症用上边插入）
create table inppdss.hospital_drug_dosage as select * from pdss.hospital_drug_dosage;
create table inppdss.hospital_dosage_advanced as select * from pdss.hospital_dosage_advanced;

--create table pdss.hospital_indication5521 as select * from pdss.hospital_indication;

create table inppdss.hospital_concentration as select * from pdss.hospital_concentration;
create table inppdss.hospital_drug_repeat as select * from pdss.hospital_drug_repeat;
create table inppdss.hospital_incompatibility as select * from pdss.hospital_incompatibility;
create table inppdss.hospital_interaction as select * from pdss.hospital_interaction;