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

create table ods_zzbyqxsxsj
(
  zzsxjysjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  xh   varchar2(64) not null,
  xm   varchar2(65) not null,
  zymc   varchar2(34) not null,
  bjmc   varchar2(45) ,
  sfzh   varchar2(36) ,
  sxqd   varchar2(10) ,
  xxmc   varchar2(68) ,
  lqzy   varchar2(68) ,
  fs   varchar2(12) ,
  sxcc   varchar2(10) ,
  sjcjsj   varchar2(64) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzbyqxsxsj add constraint ods_zzbyqxsxsj_zzsxjysjid primary key (zzsxjysjid);
comment on table ods_zzbyqxsxsj is '中职毕业去向【升学】数据表';
comment on column ods_zzbyqxsxsj.zzsxjysjid is '主键数据唯一性标识';
comment on column ods_zzbyqxsxsj.xxjgdm is '学校机构代码';
comment on column ods_zzbyqxsxsj.xxjgmc is '学校机构名称';
comment on column ods_zzbyqxsxsj.xh is '学号';
comment on column ods_zzbyqxsxsj.xm is '姓名';
comment on column ods_zzbyqxsxsj.zymc is '专业名称';
comment on column ods_zzbyqxsxsj.bjmc is '班级名称';
comment on column ods_zzbyqxsxsj.sfzh is '身份证号';
comment on column ods_zzbyqxsxsj.sxqd is '升学渠道';
comment on column ods_zzbyqxsxsj.xxmc is '学校名称';
comment on column ods_zzbyqxsxsj.lqzy is '录取专业';
comment on column ods_zzbyqxsxsj.fs is '分数';
comment on column ods_zzbyqxsxsj.sxcc is '升学层次';
comment on column ods_zzbyqxsxsj.sjcjsj is '数据采集时间';