--##2020.01.04 增加字段 by MZSF-20210105-002
alter table SD_SF.SF_PJSYQK add (
CXPJH0 number(10)   --冲销票据号=正单SF_PJSYQK.PJH000
);
alter table SD_ZY.ZY_PJSYQK add (
CXPJH0 number(10)   --冲销票据号=正单ZY_PJSYQK.PJH000
);
alter table SD_HOSPITAL.IC_YHXX00 add (
CARDNO varchar2(50)  --真实卡号不加前缀
);
alter table SD_HOSPITAL.IC_YBBRLB add 
(
YBXZQH varchar2(10) --医保行政区号
);
create index INDEX_SF_PJSYQK_CXPJH0 on SD_SF.SF_PJSYQK(CXPJH0) tablespace TS_SF_INDEX;
create index INDEX_ZY_PJSYQK_CXPJH0 on SD_ZY.ZY_PJSYQK(CXPJH0) tablespace TS_ZY_INDEX;
comment on column SD_SF.SF_PJSYQK.CXPJH0 is '冲销票据号=正单SF_PJSYQK.PJH000'; 
comment on column SD_ZY.ZY_PJSYQK.CXPJH0 is '冲销票据号=正单ZY_PJSYQK.PJH000';
comment on column SD_HOSPITAL.IC_YHXX00.CARDNO is '真实卡号不加前缀';
comment on column SD_HOSPITAL.IC_YBBRLB.YBXZQH is '医保行政区号:351500:福建省保健办 350128:平潭 359900:省直(K) 350100:福州(A) 350300:莆田(B) 350500:泉州(C)  350200:厦门(D)  350600:漳州(E)  350800:龙岩(F)  350400: 三明(G) 350700:南平(H)  350900:宁德(J)';   
commit;