zhihuidanao/DataSendApi.Program/sqlscript/资质证书数据表(ods_zzzssj).sql

create table ods_zzzssj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  jszgzrs   number not null,
  gjzcrs   number not null,
  zjzcrs   number not null,
  cjzcrs   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzzssj add constraint ods_zzzssj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_zzzssj is '资质证书数据表';
comment on column ods_zzzssj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_zzzssj.xxjgdm is '学校机构代码';
comment on column ods_zzzssj.xxjgmc is '学校机构名称';
comment on column ods_zzzssj.jszgzrs is '教师资格证人数';
comment on column ods_zzzssj.gjzcrs is '高级职称人数';
comment on column ods_zzzssj.zjzcrs is '中级职称人数';
comment on column ods_zzzssj.cjzcrs is '初级职称人数';
comment on column ods_zzzssj.sjcjsj is '数据采集时间';