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 '数据采集时间';