zhihuidanao/DataSendApi.Program/sqlscript/校内实训基地数据表(ods_xnsxjdsj).sql

create table ods_xnsxjdsj
(
  gzzyqksjid   varchar2(32) ,
  xxjgdm   varchar2(36) ,
  xxjgmc   varchar2(80) ,
  sxjdh   varchar2(32) ,
  sxjdmc   varchar2(200) ,
  clnd   varchar2(10) ,
  mxzy   varchar2(200) ,
  zcbm   varchar2(10) not null,
  pzrq   varchar2(20) not null,
  sxss   number not null,
  sxxmzs   number ,
  jdlb   varchar2(10) ,
  jzmj   number ,
  yqsbzs   number ,
  sjjxgws   number ,
  glryzz   varchar2(12) ,
  glryjz   varchar2(12) ,
  sjcjsj   varchar2(60),
  IsPush   varchar2(2) not null
);
alter table ods_xnsxjdsj add constraint ods_xnsxjdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_xnsxjdsj is '校内实训基地数据表';
comment on column ods_xnsxjdsj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_xnsxjdsj.xxjgdm is '学校机构代码';
comment on column ods_xnsxjdsj.xxjgmc is '学校机构名称';
comment on column ods_xnsxjdsj.sxjdh is '实训基地号';
comment on column ods_xnsxjdsj.sxjdmc is '实训基地名称';
comment on column ods_xnsxjdsj.clnd is '成立年度';
comment on column ods_xnsxjdsj.mxzy is '面向专业';
comment on column ods_xnsxjdsj.zcbm is '被列为实训基地项目支持部门';
comment on column ods_xnsxjdsj.pzrq is '批准日期';
comment on column ods_xnsxjdsj.sxss is '实训室数';
comment on column ods_xnsxjdsj.sxxmzs is '实训项目总数';
comment on column ods_xnsxjdsj.jdlb is '基地类别';
comment on column ods_xnsxjdsj.jzmj is '建筑面积';
comment on column ods_xnsxjdsj.yqsbzs is '仪器设备总数';
comment on column ods_xnsxjdsj.sjjxgws is '实践教学工位数';
comment on column ods_xnsxjdsj.glryzz is '管理人员(专职)';
comment on column ods_xnsxjdsj.glryjz is '管理人员(兼职)';
comment on column ods_xnsxjdsj.sjcjsj is '数据采集时间';