zhihuidanao/DataSendApi.Program/sqlscript/德育活动数据表(ods_dyhdsj).sql

create table ods_dyhdsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(180) not null,
  hdmc   varchar2(132) not null,
  sszt   varchar2(163) ,
  hdbk   varchar2(200) ,
  hdzt   varchar2(10) ,
  hdlx   varchar2(10) not null,
  hdnr   varchar2(300) ,
  zbdw   varchar2(200) not null,
  zbdwjb   varchar2(10) not null,
  hdksrq   varchar2(200) not null,
  hdjsrq   varchar2(200) not null,
  xffzr   varchar2(32) ,
  cybjs   number not null,
  cyjss   number not null,
  cyxss   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_dyhdsj add constraint ods_dyhdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_dyhdsj is '德育活动数据表';
comment on column ods_dyhdsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_dyhdsj.xxjgdm is '学校机构代码';
comment on column ods_dyhdsj.xxjgmc is '学校机构名称';
comment on column ods_dyhdsj.hdmc is '活动名称';
comment on column ods_dyhdsj.sszt is '所属专题';
comment on column ods_dyhdsj.hdbk is '活动版块';
comment on column ods_dyhdsj.hdzt is '活动主题';
comment on column ods_dyhdsj.hdlx is '活动类型';
comment on column ods_dyhdsj.hdnr is '活动内容';
comment on column ods_dyhdsj.zbdw is '主办单位';
comment on column ods_dyhdsj.zbdwjb is '主办单位级别';
comment on column ods_dyhdsj.hdksrq is '活动开始日期';
comment on column ods_dyhdsj.hdjsrq is '活动结束日期';
comment on column ods_dyhdsj.xffzr is '校方负责人';
comment on column ods_dyhdsj.cybjs is '参与班级数';
comment on column ods_dyhdsj.cyjss is '参与教师数';
comment on column ods_dyhdsj.cyxss is '参与学生数';
comment on column ods_dyhdsj.sjcjsj is '数据采集时间';