zhihuidanao/DataSendApi.Program/sqlscript/党员发展情况基础数据表(ods_dyfzqkjcsj).sql

create table ods_dyfzqkjcsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  dzzlx   varchar2(100) not null,
  dzzmc   varchar2(100) not null,
  dzzbh   varchar2(100) not null,
  xdylx   varchar2(10) not null,
  dyxm   varchar2(32) not null,
  rybh   varchar2(35) ,
  xdyfzzt   varchar2(10) not null,
  cwjjfzrq   varchar2(32) ,
  cwybdyrq   varchar2(32) ,
  zzrq   varchar2(32) ,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_dyfzqkjcsj add constraint ods_dyfzqkjcsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_dyfzqkjcsj is '��Ա��չ����������ݱ�';
comment on column ods_dyfzqkjcsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_dyfzqkjcsj.xxjgdm is 'ѧУ��������';
comment on column ods_dyfzqkjcsj.xxjgmc is 'ѧУ��������';
comment on column ods_dyfzqkjcsj.dzzlx is '����֯����';
comment on column ods_dyfzqkjcsj.dzzmc is '����֯����';
comment on column ods_dyfzqkjcsj.dzzbh is '����֯���';
comment on column ods_dyfzqkjcsj.xdylx is '�µ�Ա����';
comment on column ods_dyfzqkjcsj.dyxm is '����';
comment on column ods_dyfzqkjcsj.rybh is '��Ա���';
comment on column ods_dyfzqkjcsj.xdyfzzt is '��Ա��չ״̬';
comment on column ods_dyfzqkjcsj.cwjjfzrq is '��������������';
comment on column ods_dyfzqkjcsj.cwybdyrq is '��ΪԤ����Ա����';
comment on column ods_dyfzqkjcsj.zzrq is '��Ϊ��ʽ��Ա����';
comment on column ods_dyfzqkjcsj.sjcjsj is '���ݲɼ�ʱ��';