zhihuidanao/DataSendApi.Program/sqlscript/文化基础课成绩数据表(ods_wfjckcjsj).sql

create table ods_wfjckcjsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  xn   varchar2(32) not null,
  xq   varchar2(32) not null,
  nj   varchar2(60) not null,
  bj   varchar2(60) not null,
  zymc   varchar2(163) ,
  kcmc   varchar2(120) not null,
  kcfl   varchar2(30) not null,
  rkjs   varchar2(30) ,
  kccj   varchar2(30) not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_wfjckcjsj add constraint ods_wfjckcjsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_wfjckcjsj is '文化基础课成绩数据表';
comment on column ods_wfjckcjsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_wfjckcjsj.xxjgdm is '学校机构代码';
comment on column ods_wfjckcjsj.xxjgmc is '学校机构名称';
comment on column ods_wfjckcjsj.xn is '学年';
comment on column ods_wfjckcjsj.xq is '学期';
comment on column ods_wfjckcjsj.nj is '年级';
comment on column ods_wfjckcjsj.bj is '班级';
comment on column ods_wfjckcjsj.zymc is '专业名称';
comment on column ods_wfjckcjsj.kcmc is '课程名称';
comment on column ods_wfjckcjsj.kcfl is '课程分类';
comment on column ods_wfjckcjsj.rkjs is '任课教师';
comment on column ods_wfjckcjsj.kccj is '课程成绩';
comment on column ods_wfjckcjsj.sjcjsj is '数据采集时间';