zhihuidanao/DataSendApi.Program/sqlscript/中职毕业去向【就业】数据表(ods_zzbyqxjysj).sql

create table ods_zzbyqxjysj
(
  zzsxjysjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  xh   varchar2(64) not null,
  xm   varchar2(120) not null,
  zymc   varchar2(120) not null,
  bjmc   varchar2(64) ,
  sfzh   varchar2(36) not null,
  sfxqhzdw   varchar2(10) not null,
  jydwmc   varchar2(124) ,
  jydwhy   varchar2(10) not null,
  jydwxz   varchar2(4) ,
  jydwgm   varchar2(10) ,
  jyqd   varchar2(10) ,
  htqdqk   varchar2(10) ,
  qxx   varchar2(12) ,
  sfdk   varchar2(10) not null,
  jyrq   varchar2(56) not null,
  zzcy   varchar2(10) not null,
  cyxmmc   varchar2(164) ,
  lhjy   varchar2(10) not null,
  gznr   varchar2(300) ,
  sjcjsj   varchar2(64) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzbyqxjysj add constraint ods_zzbyqxjysj_zzsxjysjid primary key (zzsxjysjid);
comment on table ods_zzbyqxjysj is '��ְ��ҵȥ�򡾾�ҵ�����ݱ�';
comment on column ods_zzbyqxjysj.zzsxjysjid is '��������Ψһ�Ա�ʶ';
comment on column ods_zzbyqxjysj.xxjgdm is 'ѧУ��������';
comment on column ods_zzbyqxjysj.xxjgmc is 'ѧУ��������';
comment on column ods_zzbyqxjysj.xh is 'ѧ��';
comment on column ods_zzbyqxjysj.xm is '����';
comment on column ods_zzbyqxjysj.zymc is 'רҵ����';
comment on column ods_zzbyqxjysj.bjmc is '�༶����';
comment on column ods_zzbyqxjysj.sfzh is '����֤��';
comment on column ods_zzbyqxjysj.sfxqhzdw is '��ҵ��λ�Ƿ�У�������λ';
comment on column ods_zzbyqxjysj.jydwmc is '��ҵ��λ����';
comment on column ods_zzbyqxjysj.jydwhy is '��ҵ��λ��ҵ';
comment on column ods_zzbyqxjysj.jydwxz is '��ҵ��λ����';
comment on column ods_zzbyqxjysj.jydwgm is '��ҵ��λ��ģ';
comment on column ods_zzbyqxjysj.jyqd is '��ҵ����';
comment on column ods_zzbyqxjysj.htqdqk is '��ͬǩ�����';
comment on column ods_zzbyqxjysj.qxx is '��н�ߣ�Ԫ��';
comment on column ods_zzbyqxjysj.sfdk is '�Ƿ�Կ�';
comment on column ods_zzbyqxjysj.jyrq is '��ҵ����';
comment on column ods_zzbyqxjysj.zzcy is '�Ƿ�������ҵ';
comment on column ods_zzbyqxjysj.cyxmmc is '��ҵ��Ŀ����';
comment on column ods_zzbyqxjysj.lhjy is '�Ƿ�����ҵ';
comment on column ods_zzbyqxjysj.gznr is '��������';
comment on column ods_zzbyqxjysj.sjcjsj is '���ݲɼ�ʱ��';