|
-
- create table ods_djhddydhsj
- (
- gzzyqksjid varchar2(32) not null,
- xxjgdm varchar2(36) not null,
- xxjgmc varchar2(80) not null,
- dzzmc varchar2(100) not null,
- dzzbh varchar2(100) ,
- hddd varchar2(300) ,
- hdnr varchar2(300) ,
- hdkssj varchar2(35) not null,
- hdjssj varchar2(60) not null,
- cyrs number not null,
- sjcjsj varchar2(60) not null,
- IsPush varchar2(2) not null
- );
- alter table ods_djhddydhsj add constraint ods_djhddydhsj_gzzyqksjid primary key (gzzyqksjid);
- comment on table ods_djhddydhsj is '党建活动党员大会数据表';
- comment on column ods_djhddydhsj.gzzyqksjid is '主键数据唯一性标识';
- comment on column ods_djhddydhsj.xxjgdm is '学校机构代码';
- comment on column ods_djhddydhsj.xxjgmc is '学校机构名称';
- comment on column ods_djhddydhsj.dzzmc is '党组织名称';
- comment on column ods_djhddydhsj.dzzbh is '党组织编号';
- comment on column ods_djhddydhsj.hddd is '活动地点';
- comment on column ods_djhddydhsj.hdnr is '活动内容';
- comment on column ods_djhddydhsj.hdkssj is '活动开始时间';
- comment on column ods_djhddydhsj.hdjssj is '活动结束时间';
- comment on column ods_djhddydhsj.cyrs is '参与人数';
- comment on column ods_djhddydhsj.sjcjsj is '数据采集时间';
|
