alter table SD_HOSPITAL.BM_BRQTXX add( LSYMBZ varchar2(6) null, --临时用名标志 WHSP00 varchar2(50) null, --文化水平 WHSPDM varchar2(10) null, --文化水平代码 BRZJXY varchar2(16) null, --病人宗教信仰 CSDDM0 varchar2(10) null, --出生地代码 CSD000 varchar2(30) null, --出生地 BRJGDM varchar2(10) null, --病人籍贯代码 BRJG00 varchar2(30) null, --病人籍贯 GZDZDM varchar2(10) null, --工作地址代码 GZDZ00 varchar2(60) null, --工作地址 JTDZDM varchar2(10) null, --家庭地址代码 HKDZ00 VARCHAR2(200) null, --户口地址 HKDZDM VARCHAR2(30) null, --户口地址代码 LXDZDM VARCHAR2(30) null, --联系地址代码 HKYB00 VARCHAR2(30) null, --户口邮编 LXRYB0 VARCHAR2(6) null, --联系人邮编 BRXBDM varchar2(10) null, --病人性别代码 BRSG00 number(6,2) null, --病人身高 JTXXDZ VARCHAR2(200) null, --家庭详细地址 HKXXDZ VARCHAR2(200) null, --户口详细地址 ZZXXDZ VARCHAR2(200) null, --工作详细地址 LXXXDZ VARCHAR2(200) null, --联系人详细地址 HKDZC0 VARCHAR2(60) null, --户口地址村 HKCDM0 VARCHAR2(12) null, --户口地址村代码 HKDZ01 VARCHAR2(100) null, --户口详细地址 XZZQ00 VARCHAR2(60) null, --现住址区 XZZXDM VARCHAR2(64) null, --现住址县代码 XZZDM0 VARCHAR2(12) null, --现住址代码 XZZXX0 VARCHAR2(100) null, --现住址详细 JGSF00 VARCHAR2(60) null, --籍贯省份 JGSFDM VARCHAR2(64) null, --籍贯省份代码 JGS000 VARCHAR2(60) null, --籍贯市 JGSDM0 VARCHAR2(64) null, --籍贯市代码 HJQ000 VARCHAR2(64) null, --户籍区 HJXDM0 VARCHAR2(64) null, --籍贯县代码 CSDSF0 VARCHAR2(60) null, --出生地省 CSSFDM VARCHAR2(64) null, --出生地省代码 CSDS00 VARCHAR2(60) null, --出生地市 CSDSDM VARCHAR2(64) null, --出生地市代码 CSDQ00 VARCHAR2(60) null, --出生地区 CSDQDM VARCHAR2(64) null, --出生地区代码 JTZZSF VARCHAR2(60) null, --家庭地址省 JTSFDM VARCHAR2(12) null, --家庭地址省代码 JTZZS0 VARCHAR2(60) null, --家庭地址市 JTSDM0 VARCHAR2(12) null, --家庭地址市代码 JTZZX0 VARCHAR2(60) null, --家庭地址县 JJQXDM VARCHAR2(12) null, --家庭地址县代码 JTZZZ0 VARCHAR2(60) null, --家庭地址乡镇 JTXZDM VARCHAR2(12) null, --家庭地址乡镇代码 JTZZC0 VARCHAR2(60) null, --家庭地址村 JTCZDM VARCHAR2(12) null, --家庭地址村庄代码 ZZDZSF VARCHAR2(60) null, --工作地址省 ZZSFDM VARCHAR2(12) null, --工作地址省代码 ZZDZS0 VARCHAR2(60) null, --工作地址市 ZZSDM0 VARCHAR2(12) null, --工作地址市代码 ZZDZQX VARCHAR2(60) null, --工作地址县 ZZQXDM VARCHAR2(12) null, --工作地址县代码 ZZDZXZ VARCHAR2(60) null, --工作地址乡镇 ZZXZDM VARCHAR2(12) null, --工作地址乡镇代码 ZZDZC0 VARCHAR2(60) null, --工作地址村 ZZCZDM VARCHAR2(12) null, --工作地址村代码 LXRSF0 VARCHAR2(60) null, --联系人地址省 LXSFDM VARCHAR2(12) null, --联系人地址省代码 LXRS00 VARCHAR2(60) null, --联系人地址市 LXRSDM VARCHAR2(12) null, --联系人地址市代码 LXRX00 VARCHAR2(60) null, --联系人地址县 LXRXDM VARCHAR2(12) null, --联系人地址县代码 LXRXZ0 VARCHAR2(60) null, --联系人地址乡镇 LXXZDM VARCHAR2(12) null, --联系人地址乡镇代码 LXRC00 VARCHAR2(60) null, --联系人地址村 LXRCDM VARCHAR2(12) null --联系人地址村代码 ); comment on column SD_HOSPITAL.BM_BRQTXX.LSYMBZ is '临时用名标志'; comment on column SD_HOSPITAL.BM_BRQTXX.WHSP00 is '文化水平'; comment on column SD_HOSPITAL.BM_BRQTXX.WHSPDM is '文化水平代码'; comment on column SD_HOSPITAL.BM_BRQTXX.BRZJXY is '病人宗教信仰'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDDM0 is '出生地代码'; comment on column SD_HOSPITAL.BM_BRQTXX.CSD000 is '出生地'; comment on column SD_HOSPITAL.BM_BRQTXX.BRJGDM is '病人籍贯代码'; comment on column SD_HOSPITAL.BM_BRQTXX.BRJG00 is '病人籍贯'; comment on column SD_HOSPITAL.BM_BRQTXX.GZDZDM is '工作地址代码'; comment on column SD_HOSPITAL.BM_BRQTXX.GZDZ00 is '工作地址'; comment on column SD_HOSPITAL.BM_BRQTXX.JTDZDM is '家庭地址代码'; comment on column SD_HOSPITAL.BM_BRQTXX.HKDZ00 is '户口地址'; comment on column SD_HOSPITAL.BM_BRQTXX.HKDZDM is '户口地址代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXDZDM is '联系地址代码'; comment on column SD_HOSPITAL.BM_BRQTXX.HKYB00 is '户口邮编'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRYB0 is '联系人邮编'; comment on column SD_HOSPITAL.BM_BRQTXX.BRXBDM is '病人性别代码 '; comment on column SD_HOSPITAL.BM_BRQTXX.BRSG00 is '病人身高'; comment on column SD_HOSPITAL.BM_BRQTXX.JTXXDZ is '家庭详细地址'; comment on column SD_HOSPITAL.BM_BRQTXX.HKXXDZ is '户口详细地址'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZXXDZ is '工作详细地址'; comment on column SD_HOSPITAL.BM_BRQTXX.LXXXDZ is '联系人详细地址'; comment on column SD_HOSPITAL.BM_BRQTXX.HKDZC0 is '户口地址村 '; comment on column SD_HOSPITAL.BM_BRQTXX.HKCDM0 is '户口地址村代码'; comment on column SD_HOSPITAL.BM_BRQTXX.HKDZ01 is '户口详细地址'; comment on column SD_HOSPITAL.BM_BRQTXX.XZZQ00 is '现住址区'; comment on column SD_HOSPITAL.BM_BRQTXX.XZZXDM is '现住址县代码'; comment on column SD_HOSPITAL.BM_BRQTXX.XZZDM0 is '现住址代码'; comment on column SD_HOSPITAL.BM_BRQTXX.XZZXX0 is '现住址详细'; comment on column SD_HOSPITAL.BM_BRQTXX.JGSF00 is '籍贯省份'; comment on column SD_HOSPITAL.BM_BRQTXX.JGSFDM is '籍贯省份代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JGS000 is '籍贯市'; comment on column SD_HOSPITAL.BM_BRQTXX.JGSDM0 is '籍贯市代码'; comment on column SD_HOSPITAL.BM_BRQTXX.HJQ000 is '户籍区'; comment on column SD_HOSPITAL.BM_BRQTXX.HJXDM0 is '籍贯县代码'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDSF0 is '出生地省'; comment on column SD_HOSPITAL.BM_BRQTXX.CSSFDM is '出生地省代码'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDS00 is '出生地市'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDSDM is '出生地市代码'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDQ00 is '出生地区'; comment on column SD_HOSPITAL.BM_BRQTXX.CSDQDM is '出生地区代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JTZZSF is '家庭地址省'; comment on column SD_HOSPITAL.BM_BRQTXX.JTSFDM is '家庭地址省代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JTZZS0 is '家庭地址市'; comment on column SD_HOSPITAL.BM_BRQTXX.JTSDM0 is '家庭地址市代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JTZZX0 is '家庭地址县'; comment on column SD_HOSPITAL.BM_BRQTXX.JJQXDM is '家庭地址县代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JTZZZ0 is '家庭地址乡镇'; comment on column SD_HOSPITAL.BM_BRQTXX.JTXZDM is '家庭地址乡镇代码'; comment on column SD_HOSPITAL.BM_BRQTXX.JTZZC0 is '家庭地址村'; comment on column SD_HOSPITAL.BM_BRQTXX.JTCZDM is '家庭地址村庄代码'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZDZSF is '工作地址省'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZSFDM is '工作地址省代码'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZDZS0 is '工作地址市'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZSDM0 is '工作地址市代码'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZDZQX is '工作地址县'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZQXDM is '工作地址县代码'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZDZXZ is '工作地址乡镇'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZXZDM is '工作地址乡镇代码'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZDZC0 is '工作地址村'; comment on column SD_HOSPITAL.BM_BRQTXX.ZZCZDM is '工作地址村代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRSF0 is '联系人地址省'; comment on column SD_HOSPITAL.BM_BRQTXX.LXSFDM is '联系人地址省代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRS00 is '联系人地址市'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRSDM is '联系人地址市代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRX00 is '联系人地址县'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRXDM is '联系人地址县代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRXZ0 is '联系人地址乡镇'; comment on column SD_HOSPITAL.BM_BRQTXX.LXXZDM is '联系人地址乡镇代码'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRC00 is '联系人地址村'; comment on column SD_HOSPITAL.BM_BRQTXX.LXRCDM is '联系人地址村代码';