|
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
-
- create table ods_xqjcsj
- (
- xygkjcsjid varchar2(32) not null,
- provincejgbm varchar2(12) not null,
- provincejgmc varchar2(80) not null,
- cityjgbm varchar2(12) not null,
- cityjgmc varchar2(80) not null,
- countyjgbm varchar2(12) not null,
- countyjgmc varchar2(80) not null,
- xxjgdm varchar2(36) not null,
- xxjgmc varchar2(80) not null,
- xqbh varchar2(64) not null,
- xqmc varchar2(180) not null,
- xqjc varchar2(60) not null,
- xqszdxzqh varchar2(50) ,
- xqdz varchar2(300) ,
- xqyzbm varchar2(35) ,
- xqlxdh varchar2(35) ,
- xqfzr varchar2(36) ,
- xqjzgzs number not null,
- xqxszs number not null,
- xqclrq varchar2(50) ,
- sjcjsj varchar2(50) not null,
- IsPush varchar2(2) not null
- );
- alter table ods_xqjcsj add constraint ods_xqjcsj_xygkjcsjid primary key (xygkjcsjid);
- comment on table ods_xqjcsj is 'Уݱ';
- comment on column ods_xqjcsj.xygkjcsjid is 'ΨһԱʶ';
- comment on column ods_xqjcsj.provincejgbm is 'ʡ';
- comment on column ods_xqjcsj.provincejgmc is 'ʡ';
- comment on column ods_xqjcsj.cityjgbm is 'л';
- comment on column ods_xqjcsj.cityjgmc is 'л';
- comment on column ods_xqjcsj.countyjgbm is 'ػ';
- comment on column ods_xqjcsj.countyjgmc is 'ػ';
- comment on column ods_xqjcsj.xxjgdm is 'ѧУ';
- comment on column ods_xqjcsj.xxjgmc is 'ѧУ';
- comment on column ods_xqjcsj.xqbh is 'У';
- comment on column ods_xqjcsj.xqmc is 'У';
- comment on column ods_xqjcsj.xqjc is 'У';
- comment on column ods_xqjcsj.xqszdxzqh is 'Уڵ';
- comment on column ods_xqjcsj.xqdz is 'Уַ';
- comment on column ods_xqjcsj.xqyzbm is 'У';
- comment on column ods_xqjcsj.xqlxdh is 'Уϵ绰';
- comment on column ods_xqjcsj.xqfzr is 'У';
- comment on column ods_xqjcsj.xqjzgzs is 'Уְ';
- comment on column ods_xqjcsj.xqxszs is 'Уѧ';
- comment on column ods_xqjcsj.xqclrq is 'У';
- comment on column ods_xqjcsj.sjcjsj is 'ݲɼʱ';
-
|
