zhihuidanao/DataSendApi.Program/sqlscript/参加赛事活动数据表(ods_cjsxhdsj).sql

create table ods_cjsxhdsj
(
  gzzyqksjid   varchar2(32) ,
  xxjgdm   varchar2(36) ,
  xxjgmc   varchar2(80) ,
  hdmc   varchar2(32) ,
  hdzt   varchar2(63) not null,
  hdxs   varchar2(200) not null,
  hdnr   varchar2(300) not null,
  zbdw   varchar2(200) ,
  zbdwjb   varchar2(10) ,
  hdksrq   varchar2(100) ,
  hdjsrq   varchar2(100) ,
  xffzr   varchar2(32) not null,
  cyjss   number ,
  cyxss   number ,
  sjcjsj   varchar2(60),
  IsPush   varchar2(2) not null
);
alter table ods_cjsxhdsj add constraint ods_cjsxhdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_cjsxhdsj is '参加赛事活动数据表';
comment on column ods_cjsxhdsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_cjsxhdsj.xxjgdm is '学校机构代码';
comment on column ods_cjsxhdsj.xxjgmc is '学校机构名称';
comment on column ods_cjsxhdsj.hdmc is '活动名称';
comment on column ods_cjsxhdsj.hdzt is '活动主题';
comment on column ods_cjsxhdsj.hdxs is '活动形式';
comment on column ods_cjsxhdsj.hdnr is '活动内容';
comment on column ods_cjsxhdsj.zbdw is '主办单位';
comment on column ods_cjsxhdsj.zbdwjb is '主办单位级别';
comment on column ods_cjsxhdsj.hdksrq is '活动开始日期';
comment on column ods_cjsxhdsj.hdjsrq is '活动结束日期';
comment on column ods_cjsxhdsj.xffzr is '校方负责人';
comment on column ods_cjsxhdsj.cyjss is '参与教师数';
comment on column ods_cjsxhdsj.cyxss is '参与学生数';
comment on column ods_cjsxhdsj.sjcjsj is '数据采集时间';