异常库修改说明 (116).docx

1、1. 原有系统修改：1.1禁用视力筛查异常库触发器TRI_EB_SJSC_WJ1.2屏蔽CS-ASQ审核时异常库代码13屏蔽BS-视力筛查审核时异常库代码1.4暂未找到健康屋异常库代码2. 建表createtableeb_yck_da(GRBMvarchar(30)NOTNULL,JKRQdatetimeNOTNULL,XMvarchar)(20)NULL,XBnumeric(8,0)NULL,CSRQdatetimeNULL,YZvarchar(10)NULL,FQXMvarchar(20)NULL,FQDWvarchar(50)NULL,FQDHvarchar(20)NULL,FQZYva

2、rchar(50)NULL,FQNLnumeric(5,0)NULL,MQXMvarchar(20)NULL,MQDWvarchar(50)NULL,MQDHvarchar(20)NULL,MQZYvarchar(50)NULL,MQNLnumeric(5,0)NULL,CSTZnumeric(4,0)NULL,CSSGnumeric(5,0)NULL,XZDZvarchar(100)NULL,YZBMvarchar(6)NULL,TSnumeric(2，0)NULL,CSHUnumeric(2,0)NULL,ZSZchar(1)NULLSFSTchar(1)NULL,CSHInumeric(

3、8,0)NULL,CSQKnumeric(8,0)NULL,XZJWvarchar(10)NULL,XZSQvarchar(10)NULL,GXJDvarchar(10)NULL,GXTDvarchar(10)NULL,RURQdatetimenotnull,JABZintegernotnull,JASMvarchar(100)zJASJdatetime,MEMOvarchar(100),primarykey(grbm)(grbmvarchar(30)notnull,xhintegernotnull,rkrqvarchar(10)notnull,yclxintegernotnull,ycjgv

4、archar(100)notnull,czjdvarchar(10)null,jcsjdatetime,sfzzinteger,zzrqdatetime,sfhdinteger,hdrqdatetime,hdjgvarchar(20),cfrqdatetime.cfjgvarchar(20),sfqzinteger,flaginteger,jasmvarchar(100)，jarqdatetime,jarvarchar(20),iyintegernotnull,memovarchar(100)/scsjdatetime.primarykey(grbm,xh),FOREIGNKEY(grbm)R

5、EFERENCES(grbmvarchar(30)notnull,xhintegernotnull,rkrqvarchar(10)notnull,yclxintegernotnull,ycjgvarchar(100)notnull,czjdvarchar(10)null,jcsjdatetime,sfzzinteger,zzrqdatetime,sfhdinteger,hdrqdatetime,hdjgvarchar(20),cfrqdatetime.cfjgvarchar(20),sfqzinteger,flaginteger,jasmvarchar(100)，jarqdatetime,ja

6、rvarchar(20),iyintegernotnull,memovarchar(100)/scsjdatetime.primarykey(grbm,xh),FOREIGNKEY(grbm)REFERENCEScreatetableeb_yck_record-入库日期-异常类型-异常结果-业务-操作街道一业务-检查时间-是否转诊1转诊0未转-转诊日期-是否回单1回单0未回-回单日期回单结果-催访日期-催访结果-确诊结果0随访1正常2异常是否结案0未结1已结一结案说明-结案日期-结案人一来源一备注-生成时间eb_yck_da(grbm)createcreateindexcreateindexi

7、d_eb_yck_record_rkrqid_eb_yck_record_yclxoneb_yck_record(rkrq)oneb_yck_record(yclx)createtableeb_yck_sfjl(grbmvarchar(30)notnull,yckxhintegernotnull,异常库序号sfxhintegernotnull,随访序号jhksrqdatetime,jhjsrqdatetime,sfrqdatetime,sffsinteger,sfnrinteger,3了解外院检查诊断信息4健康宜教sfjginteger,jgmsvarchar(100),yysjdatetim

8、e,-计划随访开始日期-计划随访结束Fl期-实际随访日期一随访方式电话1门诊2入户3-随访内容1督促检测2督促全面检查和治疗-随访结果1继续随访2治愈3失访-结果描述-下次预约时间primarykey(grbm,yckxh,sfxh),eb_yck_record(grbm,xh)createindexcreateindexeb_yck_sfj1(jhksrq)eb_yck_sfj1(jhjsrq)createindexidx_eb_yck_sfjl_jhksrqonidx_eb_yck_sfjl_jhjsrqononeb_yck_sfj1(sfrq)idx_eb_yck_sfjl_sfrqFO

9、REIGNKEY(grbrn,yckxh)REFERENCESaltertableeb_yck_sfj1addsfrvarchar(20)随访人altertableeb_yck_sfjladdsfjdvarchar(10)随访街道jcyyvarchar(40)zjcsjdatetime,jcxm_mcvarchar(40),jcjgvarchar(40),一检查医院-检查时间-检查项目名称-检查结果createtableeb_yck_sfjl_mx(grbmvarchar(30)notnull,yckxhintegernotnull,-异常库序号sfxhintegernotnull,-随访序号

10、xmxhintegernotnull.一项目序号primarykey(grbm,yckxh,sfxh,xmxh),FOREIGNKEY(grbm,yckxh,sfxh)REFERENCESeb_yck_sfj1(grbm,yckxh,sfxh)-系统参数insertintogy_xtcs(xtsb,csmc,csz,mrz,bz)values(123,'eb_yck_xxsc*,1,'先心筛查，'儿保异常库,)insertintogy_xtcs(xtsb,csmc,csz,mrz,bz)values(123,*eb_yck_sjsc*,2,，社交筛查，儿保异常库，)in

11、sertintogy_xtcs(xtsb,csmc,cszzmrz,bz)values(123,*eb_yck_tlsc1,3,'视力筛查','儿保异常库1)insertintogy_xtcs(xtsb,csmc,csz,mrz,bz)values(123,'eb_yck_asqsc',4,，ASQ筛查','儿保异常库')insertintogy_xtcs(xtsb,csmc,cszzmrz,bz)values(123,*eb_yck_gmssc*,5,，GMS筛查',*儿保异常库*)insertintogy_xtcs(xtsbzcsmc,csz,mrz,bz)values(123,1eb_yck_ncgsc1,6,，尿常规筛查',