智慧大脑
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.
 
 
 
 
 

31 lines
1.3 KiB

  1. create table ods_djhddygbxxsj
  2. (
  3. gzzyqksjid varchar2(32) not null,
  4. xxjgdm varchar2(36) not null,
  5. xxjgmc varchar2(80) not null,
  6. dzzmc varchar2(100) not null,
  7. dzzbh varchar2(100) ,
  8. dygbxxpxzytjzt varchar2(100) ,
  9. dygbxxpxnr varchar2(32) ,
  10. hdkssj varchar2(35) not null,
  11. hdjssj varchar2(60) not null,
  12. cyrs number not null,
  13. sjcjsj varchar2(60) not null,
  14. IsPush varchar2(2) not null
  15. );
  16. alter table ods_djhddygbxxsj add constraint ods_djhddygbxxsj_gzzyqksjid primary key (gzzyqksjid);
  17. comment on table ods_djhddygbxxsj is '党建活动党员干部学习数据表';
  18. comment on column ods_djhddygbxxsj.gzzyqksjid is '主键数据唯一性标识';
  19. comment on column ods_djhddygbxxsj.xxjgdm is '学校机构代码';
  20. comment on column ods_djhddygbxxsj.xxjgmc is '学校机构名称';
  21. comment on column ods_djhddygbxxsj.dzzmc is '党组织名称';
  22. comment on column ods_djhddygbxxsj.dzzbh is '党组织编号';
  23. comment on column ods_djhddygbxxsj.dygbxxpxzytjzt is '党员干部学习培训主要途径和载体';
  24. comment on column ods_djhddygbxxsj.dygbxxpxnr is '党员干部学习培训内容';
  25. comment on column ods_djhddygbxxsj.hdkssj is '活动开始时间';
  26. comment on column ods_djhddygbxxsj.hdjssj is '活动结束时间';
  27. comment on column ods_djhddygbxxsj.cyrs is '参与人数';
  28. comment on column ods_djhddygbxxsj.sjcjsj is '数据采集时间';