zhihuidanao/DataSendApi.Program/sqlscript/教材选用数据表(ods_jcxysj).sql

create table ods_jcxysj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  jcmc   varchar2(150) not null,
  jcbh   varchar2(80) not null,
  jcxz   varchar2(10) not null,
  isbn   varchar2(200) not null,
  zzxm   varchar2(100) ,
  cbrq   varchar2(100) ,
  cbs   varchar2(120) ,
  sycc   varchar2(10) ,
  jg   varchar2(30) ,
  bc   number not null,
  yc   number not null,
  sfylxc   varchar2(10) ,
  sfyjcjf   varchar2(10) ,
  hjqk   varchar2(10) ,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_jcxysj add constraint ods_jcxysj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_jcxysj is '教材选用数据表';
comment on column ods_jcxysj.gzzyqksjid is '主键数据唯一性标识';
comment on column ods_jcxysj.xxjgdm is '学校机构代码';
comment on column ods_jcxysj.xxjgmc is '学校机构名称';
comment on column ods_jcxysj.jcmc is '教材名称';
comment on column ods_jcxysj.jcbh is '教材编号';
comment on column ods_jcxysj.jcxz is '教材性质';
comment on column ods_jcxysj.isbn is 'ISBN 号';
comment on column ods_jcxysj.zzxm is '作者';
comment on column ods_jcxysj.cbrq is '出版日期';
comment on column ods_jcxysj.cbs is '出版社';
comment on column ods_jcxysj.sycc is '适用层次';
comment on column ods_jcxysj.jg is '价格（元）';
comment on column ods_jcxysj.bc is '版次';
comment on column ods_jcxysj.yc is '印次';
comment on column ods_jcxysj.sfylxc is '是否有练习册';
comment on column ods_jcxysj.sfyjcjf is '是否有教参教辅';
comment on column ods_jcxysj.hjqk is '获奖情况';
comment on column ods_jcxysj.sjcjsj is '数据采集时间';