table.sql

Doc2Db.bat：用来将数据表描述文档转换成sql脚本。由于不方便解析WORD

/*==============================================================*/
/* Table: B_ZK_LDRY                                           */
/*==============================================================*/
prompt creating table 　流动人员信息表......
create table B_ZK_LDRY  (
	LDRYID			VARCHAR2(50)	 not null,
	ZJZL			VARCHAR2(3)	,
	ZJHM			VARCHAR2(50)	,
	XM			VARCHAR2(30)	,
	CYM			VARCHAR2(30)	,
	XB			VARCHAR2(1)	,
	MZ			VARCHAR2(2)	,
	GJ			VARCHAR2(3)	,
	CSRQ			DATE	,
	SG			NUMBER(4,1)	,
	HJDZSSXQ			VARCHAR2(6)	,
	HJDZXZ			VARCHAR2(100)	,
	CZHKSZDLX			VARCHAR2(2)	,
	WHCD			VARCHAR2(2)	,
	HYZK			VARCHAR2(2)	,
	ZZMM			VARCHAR2(1)	,
	LXDH			VARCHAR2(30)	,
	YZY			VARCHAR2(20)	,
	XZY			VARCHAR2(20)	,
	DJDWJGDM			VARCHAR2(12)	,
	DJDWMC			VARCHAR2(60)	,
	DJRJH			VARCHAR2(6)	,
	DJRXM			VARCHAR2(30)	,
	DJSJ			DATE	 not null,
	RYID			VARCHAR2(50)	,
	CREATOR			VARCHAR2(30)	,
	CREATEDTIME			DATE	,
	LASTUPDATEDBY			VARCHAR2(30)	,
	LASTUPDATEDTIME			DATE	,
	UPLOADFLAG			VARCHAR2(1)	,
	DOWNLOADFLAG			VARCHAR2(1)	,
	DELETEFLAG			VARCHAR2(1)	,
	RESERVATION01			VARCHAR2(200)	,
	RESERVATION02			VARCHAR2(200)	,
	RESERVATION03			VARCHAR2(200)	,
	RESERVATION04			VARCHAR2(200)	,
	RESERVATION05			VARCHAR2(200)	,
	RESERVATION06			VARCHAR2(200)	,
	RESERVATION07			VARCHAR2(200)	,
	RESERVATION08			VARCHAR2(200)	,
	RESERVATION09			VARCHAR2(200)	,
	RESERVATION10			VARCHAR2(200)	,
	constraint PK_B_ZK_LDRY primary key (LDRYID)
);
comment on table B_ZK_LDRY is '　流动人员信息表';
comment on column B_ZK_LDRY.LDRYID is '流动人员编号';
comment on column B_ZK_LDRY.ZJZL is '证件种类';
comment on column B_ZK_LDRY.ZJHM is '证件号码';
comment on column B_ZK_LDRY.XM is '姓名';
comment on column B_ZK_LDRY.CYM is '曾用名';
comment on column B_ZK_LDRY.XB is '性别';
comment on column B_ZK_LDRY.MZ is '民族';
comment on column B_ZK_LDRY.GJ is '国籍';
comment on column B_ZK_LDRY.CSRQ is '出生日期';
comment on column B_ZK_LDRY.SG is '身高';
comment on column B_ZK_LDRY.HJDZSSXQ is '户籍地址省市县(区)';
comment on column B_ZK_LDRY.HJDZXZ is '户籍地址详址';
comment on column B_ZK_LDRY.CZHKSZDLX is '常住户口所在地类型';
comment on column B_ZK_LDRY.WHCD is '文化程度';
comment on column B_ZK_LDRY.HYZK is '婚姻状况';
comment on column B_ZK_LDRY.ZZMM is '政治面貌';
comment on column B_ZK_LDRY.LXDH is '联系电话';
comment on column B_ZK_LDRY.YZY is '原职业';
comment on column B_ZK_LDRY.XZY is '现职业';
comment on column B_ZK_LDRY.DJDWJGDM is '登记单位机构代码';
comment on column B_ZK_LDRY.DJDWMC is '登记单位名称';
comment on column B_ZK_LDRY.DJRJH is '登记人警号';
comment on column B_ZK_LDRY.DJRXM is '登记人姓名';
comment on column B_ZK_LDRY.DJSJ is '登记时间';
comment on column B_ZK_LDRY.RYID is '派综系统的人员ID';
comment on column B_ZK_LDRY.CREATOR is '创建人';
comment on column B_ZK_LDRY.CREATEDTIME is '创建时间';
comment on column B_ZK_LDRY.LASTUPDATEDBY is '最后修改人';
comment on column B_ZK_LDRY.LASTUPDATEDTIME is '最后修改时间';
comment on column B_ZK_LDRY.UPLOADFLAG is '上传标志';
comment on column B_ZK_LDRY.DOWNLOADFLAG is '下传标志';
comment on column B_ZK_LDRY.DELETEFLAG is '删除标志';
comment on column B_ZK_LDRY.RESERVATION01 is '保留字段1';
comment on column B_ZK_LDRY.RESERVATION02 is '保留字段2';
comment on column B_ZK_LDRY.RESERVATION03 is '保留字段3';
comment on column B_ZK_LDRY.RESERVATION04 is '保留字段4';
comment on column B_ZK_LDRY.RESERVATION05 is '保留字段5';
comment on column B_ZK_LDRY.RESERVATION06 is '保留字段6';
comment on column B_ZK_LDRY.RESERVATION07 is '保留字段7';
comment on column B_ZK_LDRY.RESERVATION08 is '保留字段8';
comment on column B_ZK_LDRY.RESERVATION09 is '保留字段9';
comment on column B_ZK_LDRY.RESERVATION10 is '保留字段10';