zhihuidanao/DataSendApi.Program/sqlscript/党建活动党员干部学习数据表(ods_djhddygbxxsj).sql

create table ods_djhddygbxxsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  dzzmc   varchar2(100) not null,
  dzzbh   varchar2(100) ,
  dygbxxpxzytjzt   varchar2(100) ,
  dygbxxpxnr   varchar2(32) ,
  hdkssj   varchar2(35) not null,
  hdjssj   varchar2(60) not null,
  cyrs   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_djhddygbxxsj add constraint ods_djhddygbxxsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_djhddygbxxsj is '�������Ա�ɲ�ѧϰ���ݱ�';
comment on column ods_djhddygbxxsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_djhddygbxxsj.xxjgdm is 'ѧУ��������';
comment on column ods_djhddygbxxsj.xxjgmc is 'ѧУ��������';
comment on column ods_djhddygbxxsj.dzzmc is '����֯����';
comment on column ods_djhddygbxxsj.dzzbh is '����֯���';
comment on column ods_djhddygbxxsj.dygbxxpxzytjzt is '��Ա�ɲ�ѧϰ��ѵ��Ҫ;��������';
comment on column ods_djhddygbxxsj.dygbxxpxnr is '��Ա�ɲ�ѧϰ��ѵ����';
comment on column ods_djhddygbxxsj.hdkssj is '���ʼʱ��';
comment on column ods_djhddygbxxsj.hdjssj is '�����ʱ��';
comment on column ods_djhddygbxxsj.cyrs is '��������';
comment on column ods_djhddygbxxsj.sjcjsj is '���ݲɼ�ʱ��';