zhihuidanao/DataSendApi.Program/sqlscript/职参加社团活动数据表(ods_zzcjsthdsj).sql

create table ods_zzcjsthdsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  cyxss   number not null,
  cjsthdlx   varchar2(200) ,
  cjsthdkssj   varchar2(100) ,
  cjsthdjssj   varchar2(100) ,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzcjsthdsj add constraint ods_zzcjsthdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_zzcjsthdsj is '职参加社团活动数据表';
comment on column ods_zzcjsthdsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_zzcjsthdsj.xxjgdm is '学校机构代码';
comment on column ods_zzcjsthdsj.xxjgmc is '学校机构名称';
comment on column ods_zzcjsthdsj.cyxss is '参与学生数';
comment on column ods_zzcjsthdsj.cjsthdlx is '参加社团活动类型';
comment on column ods_zzcjsthdsj.cjsthdkssj is '参加社团活动开始时间';
comment on column ods_zzcjsthdsj.cjsthdjssj is '参加社团活动结束时间';
comment on column ods_zzcjsthdsj.sjcjsj is '数据采集时间';