zhihuidanao/DataSendApi.Program/sqlscript/中职巡课排课数据表(ods_zzxkpksj).sql

create table ods_zzxkpksj
(
  gzzyqksjid   varchar2(32) ,
  xxjgdm   varchar2(36) ,
  xxjgmc   varchar2(80) ,
  ssxqbh   varchar2(80) not null,
  nj   varchar2(32) ,
  bj   varchar2(60) ,
  xn   varchar2(23) ,
  xq   varchar2(23) ,
  zc   varchar2(30) ,
  xqj   varchar2(20) ,
  skjc   varchar2(32) ,
  skrq   varchar2(32) not null,
  kcmc   varchar2(30) not null,
  kcdm   varchar2(30) not null,
  jgh   varchar2(30) ,
  jxbrs   number not null,
  skkssj   varchar2(32) not null,
  skjssj   varchar2(32) not null,
  sdxsrs   varchar2(32) not null,
  jsdkqk   varchar2(30) not null,
  xkr   varchar2(32) ,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzxkpksj add constraint ods_zzxkpksj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_zzxkpksj is '中职巡课排课数据表';
comment on column ods_zzxkpksj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_zzxkpksj.xxjgdm is '学校机构代码';
comment on column ods_zzxkpksj.xxjgmc is '学校机构名称';
comment on column ods_zzxkpksj.ssxqbh is '所属校区编号';
comment on column ods_zzxkpksj.nj is '年级';
comment on column ods_zzxkpksj.bj is '班级';
comment on column ods_zzxkpksj.xn is '学年';
comment on column ods_zzxkpksj.xq is '学期';
comment on column ods_zzxkpksj.zc is '周次';
comment on column ods_zzxkpksj.xqj is '星期几';
comment on column ods_zzxkpksj.skjc is '上课节次';
comment on column ods_zzxkpksj.skrq is '上课日期';
comment on column ods_zzxkpksj.kcmc is '课程名称';
comment on column ods_zzxkpksj.kcdm is '课程代码';
comment on column ods_zzxkpksj.jgh is '教工号';
comment on column ods_zzxkpksj.jxbrs is '教学班人数';
comment on column ods_zzxkpksj.skkssj is '上课开始时间';
comment on column ods_zzxkpksj.skjssj is '上课结束时间';
comment on column ods_zzxkpksj.sdxsrs is '实到学生人数';
comment on column ods_zzxkpksj.jsdkqk is '教师到课情况';
comment on column ods_zzxkpksj.xkr is '巡课人';
comment on column ods_zzxkpksj.sjcjsj is '数据采集时间';