|
-
- create table ods_zzsxjcsj
- (
- gzsxjysjid varchar2(32) not null,
- xxjgdm varchar2(36) not null,
- xxjgmc varchar2(80) not null,
- xsxh varchar2(45) not null,
- xsxm varchar2(45) not null,
- zymc varchar2(120) not null,
- xn varchar2(50) not null,
- xq varchar2(50) not null,
- sxbj varchar2(100) not null,
- sxxmmc varchar2(250) not null,
- sxlb varchar2(10) not null,
- sxsfks varchar2(10) not null,
- sxsfjs varchar2(10) not null,
- sxhy varchar2(4) not null,
- sxkssj varchar2(32) not null,
- sxjssj varchar2(32) not null,
- sxqx varchar2(10) ,
- sxdwly varchar2(10) not null,
- sxcslx varchar2(10) not null,
- sxjdh varchar2(10) not null,
- sxdwmc varchar2(165) ,
- sxdwdz varchar2(132) ,
- sxgwmc varchar2(110) ,
- zsap varchar2(10) ,
- zydkcd varchar2(10) ,
- gmbxzl varchar2(10) ,
- bxgmf varchar2(10) ,
- sjcjsj varchar2(64) not null,
- IsPush varchar2(2) not null
- );
- alter table ods_zzsxjcsj add constraint ods_zzsxjcsj_gzsxjysjid primary key (gzsxjysjid);
- comment on table ods_zzsxjcsj is '中职实习基础数据表';
- comment on column ods_zzsxjcsj.gzsxjysjid is '主键数据唯一性标识';
- comment on column ods_zzsxjcsj.xxjgdm is '学校机构代码';
- comment on column ods_zzsxjcsj.xxjgmc is '学校机构名称';
- comment on column ods_zzsxjcsj.xsxh is '学生学号';
- comment on column ods_zzsxjcsj.xsxm is '学生姓名';
- comment on column ods_zzsxjcsj.zymc is '专业名称';
- comment on column ods_zzsxjcsj.xn is '学年';
- comment on column ods_zzsxjcsj.xq is '学期';
- comment on column ods_zzsxjcsj.sxbj is '实习班级';
- comment on column ods_zzsxjcsj.sxxmmc is '实习项目名称';
- comment on column ods_zzsxjcsj.sxlb is '实习类别';
- comment on column ods_zzsxjcsj.sxsfks is '实习是否开始';
- comment on column ods_zzsxjcsj.sxsfjs is '实习是否结束';
- comment on column ods_zzsxjcsj.sxhy is '实习行业';
- comment on column ods_zzsxjcsj.sxkssj is '实习开始时间';
- comment on column ods_zzsxjcsj.sxjssj is '实习结束时间';
- comment on column ods_zzsxjcsj.sxqx is '实习去向';
- comment on column ods_zzsxjcsj.sxdwly is '实习单位来源';
- comment on column ods_zzsxjcsj.sxcslx is '实习场所类型';
- comment on column ods_zzsxjcsj.sxjdh is '实训基地号';
- comment on column ods_zzsxjcsj.sxdwmc is '实习单位名称';
- comment on column ods_zzsxjcsj.sxdwdz is '实习单位地址';
- comment on column ods_zzsxjcsj.sxgwmc is '实习岗位名称';
- comment on column ods_zzsxjcsj.zsap is '住宿安排';
- comment on column ods_zzsxjcsj.zydkcd is '专业对口程度';
- comment on column ods_zzsxjcsj.gmbxzl is '购买保险种类';
- comment on column ods_zzsxjcsj.bxgmf is '保险购买方';
- comment on column ods_zzsxjcsj.sjcjsj is '数据采集时间';
|
