智慧大脑
25'ten fazla konu seçemezsiniz Konular bir harf veya rakamla başlamalı, kısa çizgiler ('-') içerebilir ve en fazla 35 karakter uzunluğunda olabilir.
 
 
 
 
 

25 satır
904 B

  1. create table ods_zzzssj
  2. (
  3. gzzyqksjid varchar2(32) not null,
  4. xxjgdm varchar2(36) not null,
  5. xxjgmc varchar2(80) not null,
  6. jszgzrs number not null,
  7. gjzcrs number not null,
  8. zjzcrs number not null,
  9. cjzcrs number not null,
  10. sjcjsj varchar2(60) not null,
  11. IsPush varchar2(2) not null
  12. );
  13. alter table ods_zzzssj add constraint ods_zzzssj_gzzyqksjid primary key (gzzyqksjid);
  14. comment on table ods_zzzssj is '资质证书数据表';
  15. comment on column ods_zzzssj.gzzyqksjid is '主键数据唯一性标识';
  16. comment on column ods_zzzssj.xxjgdm is '学校机构代码';
  17. comment on column ods_zzzssj.xxjgmc is '学校机构名称';
  18. comment on column ods_zzzssj.jszgzrs is '教师资格证人数';
  19. comment on column ods_zzzssj.gjzcrs is '高级职称人数';
  20. comment on column ods_zzzssj.zjzcrs is '中级职称人数';
  21. comment on column ods_zzzssj.cjzcrs is '初级职称人数';
  22. comment on column ods_zzzssj.sjcjsj is '数据采集时间';