--## alter table SD_HOSPITAL.XT_FR3DJ0 add (NAME00 varchar2(30) null); alter table SD_HOSPITAL.XT_XTRZ00 add (DLZT00 char(1) null); alter table SD_HOSPITAL.XT_XTRZ00 modify (DLZT00 default '0'); alter table SD_HOSPITAL.XT_XTRZ00 add (YYCODE varchar2(6) null); alter table SD_HOSPITAL.XT_XTRZ00 add (DLZH00 varchar2(20) null); alter table SD_HOSPITAL.XT_YYXT00 add (XTTB00 varchar2(100) null); alter table SD_HOSPITAL.XT_YYXT00 add (LJDZ00 varchar2(2000) null); alter table SD_HOSPITAL.XT_YYXT00 add (JKDZ00 varchar2(2000) null); alter table SD_HOSPITAL.XT_YYXT00 add (SFQY00 char(1) default '1' not null); alter table SD_HOSPITAL.XT_YYXT00 add (XTLX00 char(1) default '1' not null); alter table SD_HOSPITAL.XT_YYXT00 add (JRFS00 varchar2(5) default '1' not null); alter table SD_HOSPITAL.XT_YYXT00 add (ZCRQ00 char(8)); alter table SD_HOSPITAL.XT_YYXT00 add (ZCSJ00 char(8)); alter table SD_HOSPITAL.XT_YYXT00 modify (BJTP00 varchar2(100)); comment on column SD_HOSPITAL.XT_TYDYBB.FR3000 is 'FR3名称,XT_FR3DJ0.NAME00'; comment on column SD_HOSPITAL.XT_XTRZ00.DLZT00 is '登录状态:0为登录成功,1为登录失败(his13新增字段)'; comment on column SD_HOSPITAL.XT_XTRZ00.YYCODE is '医院内部号(his13新增字段)'; comment on column SD_HOSPITAL.XT_XTRZ00.DLZH00 is '登录账号(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.XTTB00 is '系统图标(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.LJDZ00 is '系统链接地址(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.JKDZ00 is '接口地址(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.SFQY00 is '用于13新版显示,是否启用1-是 0-否 默认1(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.XTLX00 is '系统类型1-内部系统2-外部系统(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.JRFS00 is '接入方式1-链接2-接口 可多选,如果两者都有,用1|2 表示(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.ZCRQ00 is '注册日期(his13新增字段)'; comment on column SD_HOSPITAL.XT_YYXT00.ZCSJ00 is '注册时间(his13新增字段)';