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