智慧大脑
Вы не можете выбрать более 25 тем Темы должны начинаться с буквы или цифры, могут содержать дефисы(-) и должны содержать не более 35 символов.
 
 
 
 
 

51 строка
2.0 KiB

  1. create table ods_xqjcsj
  2. (
  3. xygkjcsjid varchar2(32) not null,
  4. provincejgbm varchar2(12) not null,
  5. provincejgmc varchar2(80) not null,
  6. cityjgbm varchar2(12) not null,
  7. cityjgmc varchar2(80) not null,
  8. countyjgbm varchar2(12) not null,
  9. countyjgmc varchar2(80) not null,
  10. xxjgdm varchar2(36) not null,
  11. xxjgmc varchar2(80) not null,
  12. xqbh varchar2(64) not null,
  13. xqmc varchar2(180) not null,
  14. xqjc varchar2(60) not null,
  15. xqszdxzqh varchar2(50) ,
  16. xqdz varchar2(300) ,
  17. xqyzbm varchar2(35) ,
  18. xqlxdh varchar2(35) ,
  19. xqfzr varchar2(36) ,
  20. xqjzgzs number not null,
  21. xqxszs number not null,
  22. xqclrq varchar2(50) ,
  23. sjcjsj varchar2(50) not null,
  24. IsPush varchar2(2) not null
  25. );
  26. alter table ods_xqjcsj add constraint ods_xqjcsj_xygkjcsjid primary key (xygkjcsjid);
  27. comment on table ods_xqjcsj is '校区基础数据表';
  28. comment on column ods_xqjcsj.xygkjcsjid is '主键数据唯一性标识';
  29. comment on column ods_xqjcsj.provincejgbm is '省机构编码';
  30. comment on column ods_xqjcsj.provincejgmc is '省机构名称';
  31. comment on column ods_xqjcsj.cityjgbm is '市机构编码';
  32. comment on column ods_xqjcsj.cityjgmc is '市机构名称';
  33. comment on column ods_xqjcsj.countyjgbm is '区县机构编码';
  34. comment on column ods_xqjcsj.countyjgmc is '区县机构名称';
  35. comment on column ods_xqjcsj.xxjgdm is '学校机构代码';
  36. comment on column ods_xqjcsj.xxjgmc is '学校机构名称';
  37. comment on column ods_xqjcsj.xqbh is '校区编号';
  38. comment on column ods_xqjcsj.xqmc is '校区名称';
  39. comment on column ods_xqjcsj.xqjc is '校区简称';
  40. comment on column ods_xqjcsj.xqszdxzqh is '校区所在地行政区划';
  41. comment on column ods_xqjcsj.xqdz is '校区地址';
  42. comment on column ods_xqjcsj.xqyzbm is '校区邮政编码';
  43. comment on column ods_xqjcsj.xqlxdh is '校区联系电话';
  44. comment on column ods_xqjcsj.xqfzr is '校区负责人';
  45. comment on column ods_xqjcsj.xqjzgzs is '校区教职工总数';
  46. comment on column ods_xqjcsj.xqxszs is '校区学生总数';
  47. comment on column ods_xqjcsj.xqclrq is '校区成立日期';
  48. comment on column ods_xqjcsj.sjcjsj is '数据采集时间';