|
-
- create table ods_xwsxjdsj
- (
- gzzyqksjid varchar2(32) ,
- xxjgdm varchar2(36) ,
- xxjgmc varchar2(80) ,
- sxsxjdh varchar2(32) ,
- sxsxjdmc varchar2(200) ,
- ytdwmc varchar2(300) ,
- ytdwxz varchar2(10) ,
- dwzzjgdm varchar2(60) not null,
- zgzgzs number not null,
- szqy varchar2(120) ,
- xxdz varchar2(300) ,
- jdlxrxm varchar2(30) ,
- lxrdh varchar2(30),
- lxryx varchar2(30),
- jdclny varchar2(10) ,
- sshy varchar2(10) ,
- sscy varchar2(10) ,
- mxzy varchar2(65) ,
- hzkssj varchar2(60) not null,
- hzjssj varchar2(60) not null,
- hzxyqszt varchar2(10) ,
- hzzt varchar2(10) ,
- sjcjsj varchar2(60),
- IsPush varchar2(2) not null
- );
- alter table ods_xwsxjdsj add constraint ods_xwsxjdsj_gzzyqksjid primary key (gzzyqksjid);
- comment on table ods_xwsxjdsj is '校外实训基地数据表';
- comment on column ods_xwsxjdsj.gzzyqksjid is '主键数据唯一性标识';
- comment on column ods_xwsxjdsj.xxjgdm is '学校机构代码';
- comment on column ods_xwsxjdsj.xxjgmc is '学校机构名称';
- comment on column ods_xwsxjdsj.sxsxjdh is '实习实训基地号';
- comment on column ods_xwsxjdsj.sxsxjdmc is '实习实训基地名称';
- comment on column ods_xwsxjdsj.ytdwmc is '依托单位名称';
- comment on column ods_xwsxjdsj.ytdwxz is '依托单位性质';
- comment on column ods_xwsxjdsj.dwzzjgdm is '单位组织机构代码';
- comment on column ods_xwsxjdsj.zgzgzs is '在岗职工总数';
- comment on column ods_xwsxjdsj.szqy is '所在区域';
- comment on column ods_xwsxjdsj.xxdz is '详细地址';
- comment on column ods_xwsxjdsj.jdlxrxm is '基地联系人姓名';
- comment on column ods_xwsxjdsj.lxrdh is '联系人电话';
- comment on column ods_xwsxjdsj.lxryx is '联系人邮箱';
- comment on column ods_xwsxjdsj.jdclny is '基地成立年月';
- comment on column ods_xwsxjdsj.sshy is '所属行业';
- comment on column ods_xwsxjdsj.sscy is '所属产业';
- comment on column ods_xwsxjdsj.mxzy is '面向专业';
- comment on column ods_xwsxjdsj.hzkssj is '合作开始时间';
- comment on column ods_xwsxjdsj.hzjssj is '合作结束时间';
- comment on column ods_xwsxjdsj.hzxyqszt is '合作协议签署状态';
- comment on column ods_xwsxjdsj.hzzt is '合作状态';
- comment on column ods_xwsxjdsj.sjcjsj is '数据采集时间';
|
