智慧大脑
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 lines
1.3 KiB

  1. create table ods_djhdshyksj
  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) not null,
  8. hdxs varchar2(100) not null,
  9. dkzjr varchar2(32) ,
  10. hdnr varchar2(500) ,
  11. hdkssj varchar2(35) not null,
  12. hdjssj varchar2(60) not null,
  13. cyrs number not null,
  14. sjcjsj varchar2(60) not null,
  15. IsPush varchar2(2) not null
  16. );
  17. alter table ods_djhdshyksj add constraint ods_djhdshyksj_gzzyqksjid primary key (gzzyqksjid);
  18. comment on table ods_djhdshyksj is '党建活动三会一课数据表';
  19. comment on column ods_djhdshyksj.gzzyqksjid is '主键数据唯一性标识';
  20. comment on column ods_djhdshyksj.xxjgdm is '学校机构代码';
  21. comment on column ods_djhdshyksj.xxjgmc is '学校机构名称';
  22. comment on column ods_djhdshyksj.dzzmc is '党组织名称';
  23. comment on column ods_djhdshyksj.dzzbh is '党组织编号';
  24. comment on column ods_djhdshyksj.hdxs is '活动形式';
  25. comment on column ods_djhdshyksj.dkzjr is '党课主讲人';
  26. comment on column ods_djhdshyksj.hdnr is '活动内容';
  27. comment on column ods_djhdshyksj.hdkssj is '活动开始时间';
  28. comment on column ods_djhdshyksj.hdjssj is '活动结束时间';
  29. comment on column ods_djhdshyksj.cyrs is '参与人数';
  30. comment on column ods_djhdshyksj.sjcjsj is '数据采集时间';