zhihuidanao/DataSendApi.Program/sqlscript/进修培训数据表(ods_jxpxsj).sql

create table ods_jxpxsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  jxpxhdbh   varchar2(32) not null,
  jxpxhdmc   varchar2(80) not null,
  jxpxhdzt   varchar2(63) ,
  jxpxhdnrjj   varchar2(200) ,
  jxpxhdsj   varchar2(100) not null,
  zjr   varchar2(23) ,
  drpxhdcyjss   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_jxpxsj add constraint ods_jxpxsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_jxpxsj is '进修培训数据表';
comment on column ods_jxpxsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_jxpxsj.xxjgdm is '学校机构代码';
comment on column ods_jxpxsj.xxjgmc is '学校机构名称';
comment on column ods_jxpxsj.jxpxhdbh is '进修培训活动编号';
comment on column ods_jxpxsj.jxpxhdmc is '进修培训活动名称';
comment on column ods_jxpxsj.jxpxhdzt is '进修培训活动主题';
comment on column ods_jxpxsj.jxpxhdnrjj is '进修培训活动内容简介';
comment on column ods_jxpxsj.jxpxhdsj is '进修培训活动培训时间';
comment on column ods_jxpxsj.zjr is '主讲人姓名';
comment on column ods_jxpxsj.drpxhdcyjss is '当日培训活动参与教师数';
comment on column ods_jxpxsj.sjcjsj is '数据采集时间';