zhihuidanao/DataSendApi.Program/sqlscript/党建活动三会一课数据表(ods_djhdshyksj).sql

create table ods_djhdshyksj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  dzzmc   varchar2(100) not null,
  dzzbh   varchar2(100) not null,
  hdxs   varchar2(100) not null,
  dkzjr   varchar2(32) ,
  hdnr   varchar2(500) ,
  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_djhdshyksj add constraint ods_djhdshyksj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_djhdshyksj is '党建活动三会一课数据表';
comment on column ods_djhdshyksj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_djhdshyksj.xxjgdm is '学校机构代码';
comment on column ods_djhdshyksj.xxjgmc is '学校机构名称';
comment on column ods_djhdshyksj.dzzmc is '党组织名称';
comment on column ods_djhdshyksj.dzzbh is '党组织编号';
comment on column ods_djhdshyksj.hdxs is '活动形式';
comment on column ods_djhdshyksj.dkzjr is '党课主讲人';
comment on column ods_djhdshyksj.hdnr is '活动内容';
comment on column ods_djhdshyksj.hdkssj is '活动开始时间';
comment on column ods_djhdshyksj.hdjssj is '活动结束时间';
comment on column ods_djhdshyksj.cyrs is '参与人数';
comment on column ods_djhdshyksj.sjcjsj is '数据采集时间';