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 '联系人地址村代码';





























