智慧大脑
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

33 line
1.3 KiB

  1. create table ods_dzzqkjcsj
  2. (
  3. gzzyqksjid varchar2(32) not null,
  4. xxjgdm varchar2(36) not null,
  5. xxjgmc varchar2(80) not null,
  6. dzzlx varchar2(100) not null,
  7. dzzmc varchar2(100) not null,
  8. dzzbh varchar2(100) not null,
  9. sjdzz varchar2(100) ,
  10. dnldxm varchar2(32) ,
  11. dnldjgh varchar2(35) ,
  12. dnldzw varchar2(300) ,
  13. dzzdyrs number not null,
  14. sjcjsj varchar2(60) not null,
  15. IsPush varchar2(2) not null
  16. );
  17. alter table ods_dzzqkjcsj add constraint ods_dzzqkjcsj_gzzyqksjid primary key (gzzyqksjid);
  18. comment on table ods_dzzqkjcsj is '党组织情况基础数据表';
  19. comment on column ods_dzzqkjcsj.gzzyqksjid is '主键数据唯一性标识';
  20. comment on column ods_dzzqkjcsj.xxjgdm is '学校机构代码';
  21. comment on column ods_dzzqkjcsj.xxjgmc is '学校机构名称';
  22. comment on column ods_dzzqkjcsj.dzzlx is '党组织类型';
  23. comment on column ods_dzzqkjcsj.dzzmc is '党组织名称';
  24. comment on column ods_dzzqkjcsj.dzzbh is '党组织编号';
  25. comment on column ods_dzzqkjcsj.sjdzz is '隶属上级党组织';
  26. comment on column ods_dzzqkjcsj.dnldxm is '党内领导姓名';
  27. comment on column ods_dzzqkjcsj.dnldjgh is '党内领导教工号';
  28. comment on column ods_dzzqkjcsj.dnldzw is '党内领导职务';
  29. comment on column ods_dzzqkjcsj.dzzdyrs is '党组织党员人数';
  30. comment on column ods_dzzqkjcsj.sjcjsj is '数据采集时间';