zhihuidanao/DataSendApi.Program/sqlscript/党组织情况基础数据表(ods_dzzqkjcsj).sql

create table ods_dzzqkjcsj
(
  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,
  sjdzz   varchar2(100) ,
  dnldxm   varchar2(32) ,
  dnldjgh   varchar2(35) ,
  dnldzw   varchar2(300) ,
  dzzdyrs   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_dzzqkjcsj add constraint ods_dzzqkjcsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_dzzqkjcsj is '����֯����������ݱ�';
comment on column ods_dzzqkjcsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_dzzqkjcsj.xxjgdm is 'ѧУ��������';
comment on column ods_dzzqkjcsj.xxjgmc is 'ѧУ��������';
comment on column ods_dzzqkjcsj.dzzlx is '����֯����';
comment on column ods_dzzqkjcsj.dzzmc is '����֯����';
comment on column ods_dzzqkjcsj.dzzbh is '����֯���';
comment on column ods_dzzqkjcsj.sjdzz is '�����ϼ�����֯';
comment on column ods_dzzqkjcsj.dnldxm is '�����쵼����';
comment on column ods_dzzqkjcsj.dnldjgh is '�����쵼�̹���';
comment on column ods_dzzqkjcsj.dnldzw is '�����쵼ְ��';
comment on column ods_dzzqkjcsj.dzzdyrs is '����֯��Ա����';
comment on column ods_dzzqkjcsj.sjcjsj is '���ݲɼ�ʱ��';