prompt
prompt Creating table LIB_ACQ_ALLOCATION
prompt =================================
prompt
create table JISHEN.LIB_ACQ_ALLOCATION
(
  libcode VARCHAR2(32 CHAR),
  loccode VARCHAR2(32 CHAR),
  copies  NUMBER(6) not null,
  orderid NUMBER(10) not null,
  doctype VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 1M
    minextents 1
  );
create index JISHEN.LIB_ACQ_ALLOCATION_ORDERID on JISHEN.LIB_ACQ_ALLOCATION (ORDERID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_ACQ_BOOKSELLER
prompt =================================
prompt
create table JISHEN.LIB_ACQ_BOOKSELLER
(
  code    VARCHAR2(32 CHAR) not null,
  libcode VARCHAR2(32 CHAR) not null,
  name    VARCHAR2(20 CHAR) not null,
  linkman VARCHAR2(20 CHAR),
  address VARCHAR2(100 CHAR),
  tel1    VARCHAR2(32 CHAR),
  tel2    VARCHAR2(32 CHAR),
  email   VARCHAR2(60 CHAR),
  level   CHAR(1 CHAR),
  account VARCHAR2(30 CHAR),
  bank    VARCHAR2(30 CHAR),
  note    VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_ACQ_BOOKSELLER
  add constraint PK_LIB_ACQ_BOOKSELLER primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_CHECK
prompt ============================
prompt
create table JISHEN.LIB_ACQ_CHECK
(
  id              NUMBER(10) not null,
  libcode         VARCHAR2(32 CHAR) not null,
  orderid         NUMBER(10),
  bibid           NUMBER(10) not null,
  callno          VARCHAR2(30 CHAR),
  orderno         VARCHAR2(20 CHAR),
  batchno         VARCHAR2(20 CHAR),
  copies          NUMBER(8) not null,
  ncy             VARCHAR2(10 CHAR),
  price           NUMBER(8,2),
  totalprice      NUMBER(8,2),
  orderncy        VARCHAR2(10 CHAR),
  orderprice      NUMBER(8,2) not null,
  ordertotalprice NUMBER(8,2),
  binding         VARCHAR2(10 CHAR),
  docsources      VARCHAR2(10 CHAR),
  finsources      VARCHAR2(10 CHAR),
  mediatype       VARCHAR2(32 CHAR),
  bookseller      VARCHAR2(10 CHAR),
  checkdate       NUMBER(8),
  operid          NUMBER(10),
  volumes         NUMBER(4),
  volinfo         VARCHAR2(30 CHAR),
  note            VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_ACQ_CHECK_BATCHNO_IDX on JISHEN.LIB_ACQ_CHECK (BATCHNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_ACQ_CHECK_BIBID_IDX on JISHEN.LIB_ACQ_CHECK (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_ACQ_CHECK
  add constraint PK_LIB_ACQ_CHECK primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_COLLECTBIB
prompt =================================
prompt
create table JISHEN.LIB_ACQ_COLLECTBIB
(
  id             NUMBER(10) not null,
  marc           LONG not null,
  libcode        VARCHAR2(32 CHAR) not null,
  linkid         NUMBER(10),
  sysid          NUMBER(10) not null,
  ctrlno         VARCHAR2(32 CHAR),
  title          VARCHAR2(512 CHAR) not null,
  author         VARCHAR2(256 CHAR),
  publish        VARCHAR2(256 CHAR),
  publishaddress VARCHAR2(256 CHAR),
  publishdate    VARCHAR2(32 CHAR),
  price          VARCHAR2(32 CHAR),
  classno        VARCHAR2(32 CHAR),
  isbn           VARCHAR2(32 CHAR),
  subject        VARCHAR2(128 CHAR),
  bibsize        VARCHAR2(32 CHAR),
  language       VARCHAR2(16 CHAR),
  page           VARCHAR2(16 CHAR),
  content        VARCHAR2(2048 CHAR),
  seriesname     VARCHAR2(256 CHAR),
  orderno        VARCHAR2(32 CHAR),
  unifiedno      VARCHAR2(32 CHAR),
  attachment     VARCHAR2(50 CHAR),
  catacode       VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_ACQ_COLLECTBIB.linkid
  is '书目记录号';
create index JISHEN.COLLECTBIB_IDX_CATACODE on JISHEN.LIB_ACQ_COLLECTBIB (CATACODE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_ACQ_COLLECTBIB
  add constraint PK_LIB_ACQ_COLLECTBIB primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_COLLECTBIB_IDX
prompt =====================================
prompt
create table JISHEN.LIB_ACQ_COLLECTBIB_IDX
(
  bibid   NUMBER(10) not null,
  type    VARCHAR2(32 CHAR) not null,
  libcode VARCHAR2(32 CHAR) not null,
  sysid   NUMBER(10) not null,
  code    VARCHAR2(32 CHAR),
  value   VARCHAR2(512 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 384K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_ACQ_COLLECTBIB_IDX.type
  is '从索引参数获取';
create index JISHEN.LIB_COLLECTBIB_CODE_VALUE on JISHEN.LIB_ACQ_COLLECTBIB_IDX (CODE, VALUE, SYSID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 384K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_COLLECTCATA
prompt ==================================
prompt
create table JISHEN.LIB_ACQ_COLLECTCATA
(
  code       VARCHAR2(32 CHAR) not null,
  name       VARCHAR2(50 CHAR),
  libcode    VARCHAR2(32 CHAR) not null,
  bookseller VARCHAR2(10 CHAR),
  status     CHAR(1 CHAR),
  note       VARCHAR2(50 CHAR),
  year       NUMBER(4),
  enddate    NUMBER(8),
  sysid      NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_ACQ_COLLECTCATA.status
  is '1在用2未用';
alter table JISHEN.LIB_ACQ_COLLECTCATA
  add constraint PK_LIB_ACQ_COLLECTCATA primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_ORDER
prompt ============================
prompt
create table JISHEN.LIB_ACQ_ORDER
(
  id              NUMBER(10) not null,
  libcode         VARCHAR2(32 CHAR) not null,
  bibid           NUMBER(10) not null,
  orderno         VARCHAR2(20 CHAR),
  batchno         VARCHAR2(20 CHAR),
  copies          NUMBER(8) not null,
  ncy             VARCHAR2(10 CHAR),
  price           NUMBER(8,2),
  totalprice      NUMBER(8,2),
  orderncy        VARCHAR2(10 CHAR),
  orderprice      NUMBER(8,2) not null,
  ordertotalprice NUMBER(8,2),
  binding         VARCHAR2(10 CHAR),
  docsources      VARCHAR2(10 CHAR),
  finsources      VARCHAR2(10 CHAR),
  mediatype       VARCHAR2(32 CHAR),
  bookseller      VARCHAR2(10 CHAR),
  orderdate       NUMBER(8),
  operid          NUMBER(10),
  volumes         NUMBER(4),
  volinfo         VARCHAR2(30 CHAR),
  note            VARCHAR2(30 CHAR),
  billno          VARCHAR2(30 CHAR),
  paydate         NUMBER(8),
  ordstatus       CHAR(1) default '0'
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 2M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_ACQ_ORDER_BATCHNO_IDX on JISHEN.LIB_ACQ_ORDER (BATCHNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 704K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_ACQ_ORDER_BIBID_IDX on JISHEN.LIB_ACQ_ORDER (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 512K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_ACQ_ORDER
  add constraint PK_LIB_ACQ_ORDER primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 384K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_ACQ_RECOMMEND
prompt ================================
prompt
create table JISHEN.LIB_ACQ_RECOMMEND
(
  id        NUMBER(10) not null,
  bibid     NUMBER(10),
  rdrid     NUMBER(10),
  colid     NUMBER(10) not null,
  recstatus CHAR(1 CHAR) not null,
  recdate   NUMBER(10) not null,
  rectime   VARCHAR2(10 CHAR),
  catacode  VARCHAR2(32 CHAR),
  note      VARCHAR2(100 CHAR),
  upddate   NUMBER(8)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
comment on column JISHEN.LIB_ACQ_RECOMMEND.recstatus
  is '0待处理1订购2到馆3退订4未采纳';
create index JISHEN.RECOMMEND_IDX_BIBID on JISHEN.LIB_ACQ_RECOMMEND (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.RECOMMEND_IDX_CATACODE on JISHEN.LIB_ACQ_RECOMMEND (CATACODE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.RECOMMEND_IDX_COLID on JISHEN.LIB_ACQ_RECOMMEND (COLID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.RECOMMEND_IDX_RDRID on JISHEN.LIB_ACQ_RECOMMEND (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_ACQ_RECOMMEND
  add constraint PK_LIB_ACQ_RECOMMEND primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_BIBLIOGRAPHY
prompt ===============================
prompt
create table JISHEN.LIB_BIBLIOGRAPHY
(
  id             NUMBER(10) not null,
  marc           LONG not null,
  libcode        VARCHAR2(32 CHAR) not null,
  status         CHAR(1 CHAR) default '0',
  sysid          NUMBER(10) not null,
  ctrlno         VARCHAR2(32 CHAR),
  title          VARCHAR2(512 CHAR),
  author         VARCHAR2(256 CHAR),
  publish        VARCHAR2(256 CHAR),
  publishaddress VARCHAR2(256 CHAR),
  publishdate    VARCHAR2(32 CHAR),
  price          VARCHAR2(32 CHAR),
  callno         VARCHAR2(32 CHAR),
  classno        VARCHAR2(32 CHAR),
  isbn           VARCHAR2(32 CHAR),
  subject        VARCHAR2(128 CHAR),
  bibsize        VARCHAR2(32 CHAR),
  language       VARCHAR2(16 CHAR),
  page           VARCHAR2(16 CHAR),
  content        VARCHAR2(2048 CHAR),
  seriesname     VARCHAR2(256 CHAR),
  orderno        VARCHAR2(32 CHAR),
  unifiedno      VARCHAR2(32 CHAR),
  createoperid   NUMBER(10),
  createdate     NUMBER(8),
  updateoperid   NUMBER(10),
  updatedate     NUMBER(8),
  bibsources     CHAR(1 CHAR),
  attachment     VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 264M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_BIBLIOGRAPHY.status
  is '0未处理 1审校';
create index JISHEN.LIB_BIB_AUTHOR_IDX on JISHEN.LIB_BIBLIOGRAPHY (AUTHOR)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 8M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_CLASSNO_IDX on JISHEN.LIB_BIBLIOGRAPHY (CLASSNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 5M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_ISBN_IDX on JISHEN.LIB_BIBLIOGRAPHY (ISBN)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 5M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_ORDERNO_IDX on JISHEN.LIB_BIBLIOGRAPHY (ORDERNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_SUBJECT_IDX on JISHEN.LIB_BIBLIOGRAPHY (SUBJECT)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 4M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_TITLE_IDX on JISHEN.LIB_BIBLIOGRAPHY (TITLE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 8M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIB_UNIFIEDNO_IDX on JISHEN.LIB_BIBLIOGRAPHY (UNIFIEDNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_BIBLIOGRAPHY
  add constraint PK_LIB_BIBLIOGRAPHY primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 4M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_BIBLIOS_INDEX
prompt ================================
prompt
create table JISHEN.LIB_BIBLIOS_INDEX
(
  bibid   NUMBER(10) not null,
  type    VARCHAR2(32 CHAR) not null,
  libcode VARCHAR2(32 CHAR) not null,
  sysid   NUMBER(10) not null,
  code    VARCHAR2(32 CHAR),
  value   VARCHAR2(512 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 72M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_BIBLIOS_INDEX.type
  is '从索引参数获取';
create index JISHEN.LIB_BIBIDX_BIBID_IDX on JISHEN.LIB_BIBLIOS_INDEX (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 38M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_BIBLIOS_INDEX_CODE_VALUE on JISHEN.LIB_BIBLIOS_INDEX (TYPE, VALUE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 72M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_BOOKCLASS
prompt ============================
prompt
create table JISHEN.LIB_BOOKCLASS
(
  code       VARCHAR2(32 CHAR) not null,
  name       VARCHAR2(60 CHAR) not null,
  classlevel CHAR(1 CHAR),
  note       VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_BOOKCLASS
  add constraint PK_LIB_BOOKCLASS primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CAT_INSTITUTIONAL
prompt ====================================
prompt
create table JISHEN.LIB_CAT_INSTITUTIONAL
(
  code    VARCHAR2(32 CHAR) not null,
  name    VARCHAR2(64 CHAR) not null,
  address VARCHAR2(64 CHAR),
  area    VARCHAR2(32 CHAR),
  note    VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CAT_INSTITUTIONAL
  add constraint LIB_CAT_INSTITUTIONAL_PK primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CAT_SUBJECT
prompt ==============================
prompt
create table JISHEN.LIB_CAT_SUBJECT
(
  id      NUMBER(10) not null,
  classno VARCHAR2(30 CHAR) not null,
  subject VARCHAR2(128 CHAR) not null,
  note    VARCHAR2(30 CHAR),
  theme   VARCHAR2(30 CHAR),
  area    VARCHAR2(30 CHAR),
  age     VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 7M
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CAT_SUBJECT
  add constraint PK_LIB_CAT_SUBJECT primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 3M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_CURFINE
prompt ==============================
prompt
create table JISHEN.LIB_CIR_CURFINE
(
  fineid   NUMBER(10) not null,
  rdrid    NUMBER(10) not null,
  type     VARCHAR2(32 CHAR) not null,
  money    NUMBER(8,2) not null,
  findate  NUMBER(8),
  fintime  NUMBER(6),
  operid   NUMBER(10),
  note     VARCHAR2(30 CHAR),
  bibid    NUMBER(10),
  hldid    NUMBER(10),
  loccode  VARCHAR2(32 CHAR),
  resefld1 VARCHAR2(10 CHAR),
  resefld2 VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_CIR_CURFINE.type
  is '押金、欠款、预付款等';
create index JISHEN.LIB_CIR_CURFINE_RDRID_IDX on JISHEN.LIB_CIR_CURFINE (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CIR_CURFINE
  add constraint PK_LIB_CIR_CURFINE primary key (FINEID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_FINELOG
prompt ==============================
prompt
create table JISHEN.LIB_CIR_FINELOG
(
  id       NUMBER(10) not null,
  rdrid    NUMBER(10) not null,
  type     VARCHAR2(32 CHAR) not null,
  money    NUMBER(8,2) not null,
  findate  NUMBER(8),
  finstamp NUMBER(16),
  operid   NUMBER(10),
  note     VARCHAR2(30 CHAR),
  bibid    NUMBER(10),
  hldid    NUMBER(10),
  loccode  VARCHAR2(32 CHAR),
  rectype  VARCHAR2(32 CHAR) not null,
  parentid NUMBER(10),
  payway   CHAR(1 CHAR),
  resefld1 VARCHAR2(10 CHAR),
  resefld2 VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 4M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_CIR_FINELOG.type
  is '0押金1过期2污损3丢失4其他5预付款6工本费7验证费';
comment on column JISHEN.LIB_CIR_FINELOG.rectype
  is '0设置1交款2取消3退款';
comment on column JISHEN.LIB_CIR_FINELOG.payway
  is '0现金1IC卡2预付款3微信4支付宝5取消';
create index JISHEN.LIB_CIR_FINELOG_FINDATE_IDX on JISHEN.LIB_CIR_FINELOG (FINDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 3M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_FINELOG_RDRID_IDX on JISHEN.LIB_CIR_FINELOG (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 2M
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CIR_FINELOG
  add constraint PK_LIB_CIR_FINELOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 2M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_LOG
prompt ==========================
prompt
create table JISHEN.LIB_CIR_LOG
(
  id       NUMBER(10) not null,
  logtype  VARCHAR2(32 CHAR) not null,
  libcode  VARCHAR2(32 CHAR),
  rdrid    NUMBER(10),
  bibid    NUMBER(10),
  hldid    NUMBER(10),
  loccode  VARCHAR2(32 CHAR),
  logdate  NUMBER(8),
  logstamp NUMBER(15),
  operid   NUMBER(10),
  info1    VARCHAR2(30 CHAR),
  info2    VARCHAR2(100 CHAR),
  ip       VARCHAR2(50 CHAR),
  note     VARCHAR2(30 CHAR),
  parentid NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 120M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_CIR_LOG.parentid
  is '还回或续借记录';
create index JISHEN.LIB_CIR_LOG_BIBID_IDX on JISHEN.LIB_CIR_LOG (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 32M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_LOG_LOGDATE_IDX on JISHEN.LIB_CIR_LOG (LOGDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 34M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_LOG_RDRID_IDX on JISHEN.LIB_CIR_LOG (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 37M
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CIR_LOG
  add constraint PK_LIB_CIR_LOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 20M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_PECCANCY
prompt ===============================
prompt
create table JISHEN.LIB_CIR_PECCANCY
(
  id       NUMBER(10) not null,
  rdrid    NUMBER(10) not null,
  pectype  CHAR(1 CHAR) not null,
  pecdate  NUMBER(8),
  pecstamp NUMBER(16),
  note     VARCHAR2(30 CHAR),
  bibid    NUMBER(10),
  hldid    NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_PECCANCY_PECDATE_IDX on JISHEN.LIB_CIR_PECCANCY (PECDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_PECCANCY_RDRID_IDX on JISHEN.LIB_CIR_PECCANCY (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CIR_PECCANCY
  add constraint PK_LIB_CIR_PECCANCY primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_READER
prompt =============================
prompt
create table JISHEN.LIB_CIR_READER
(
  id          NUMBER(10) not null,
  libcode     VARCHAR2(32 CHAR) not null,
  rdrno       VARCHAR2(32 CHAR) not null,
  name        VARCHAR2(32 CHAR) not null,
  idcard      VARCHAR2(32 CHAR),
  otherno     VARCHAR2(32 CHAR),
  password    VARCHAR2(64 CHAR),
  status      CHAR(1 CHAR),
  rdrtype     VARCHAR2(32 CHAR),
  rdrfld1     VARCHAR2(32 CHAR),
  rdrfld2     VARCHAR2(32 CHAR),
  rdrfld3     VARCHAR2(32 CHAR),
  rdrfld4     VARCHAR2(32 CHAR),
  birthday    VARCHAR2(8 CHAR),
  gender      CHAR(1 CHAR),
  hobby       VARCHAR2(64 CHAR),
  specialty   VARCHAR2(128 CHAR),
  telephone   VARCHAR2(16 CHAR),
  email       VARCHAR2(32 CHAR),
  nation      VARCHAR2(12 CHAR),
  nativeplace VARCHAR2(64 CHAR),
  address     VARCHAR2(128 CHAR),
  unit        VARCHAR2(128 CHAR),
  createdate  NUMBER(8),
  startdate   NUMBER(8),
  enddate     NUMBER(8),
  canceldate  NUMBER(8),
  photourl    VARCHAR2(256 CHAR),
  note        VARCHAR2(128 CHAR),
  paramjson   VARCHAR2(1024 CHAR),
  openid      VARCHAR2(30 CHAR),
  otherno1    VARCHAR2(60 CHAR),
  otherno2    VARCHAR2(60 CHAR),
  stopdate    NUMBER(8),
  rdruid      VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 3M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_READER_IDCARD_IDX on JISHEN.LIB_CIR_READER (IDCARD)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 576K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_READER_OPENID on JISHEN.LIB_CIR_READER (OPENID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_READER_OTHERNO1 on JISHEN.LIB_CIR_READER (OTHERNO1)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_CIR_READER_OTHERNO2 on JISHEN.LIB_CIR_READER (OTHERNO2)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create unique index JISHEN.LIB_CIR_READER_RDRNO_UNI on JISHEN.LIB_CIR_READER (RDRNO)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 576K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_CIR_READER
  add constraint PK_LIB_CIR_READER primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_CIR_RESERVE
prompt ==============================
prompt
create table JISHEN.LIB_CIR_RESERVE
(
  id          NUMBER(10) not null,
  restype     VARCHAR2(32 CHAR),
  libcode     VARCHAR2(32 CHAR),
  rdrid       NUMBER(10),
  bibid       NUMBER(10),
  hldid       NUMBER(10),
  resstatus   CHAR(1 CHAR),
  resdate     VARCHAR2(8 CHAR),
  expirydate  VARCHAR2(8 CHAR),
  returndate  VARCHAR2(8 CHAR),
  notifyway   CHAR(1 CHAR),
  notifycount NUMBER(2) default 0,
  notifydate  VARCHAR2(8 CHAR),
  fetchdate   VARCHAR2(8 CHAR),
  location    VARCHAR2(32 CHAR),
  note        VARCHAR2(100 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
comment on column JISHEN.LIB_CIR_RESERVE.restype
  is '0预约1预借';
create index JISHEN.RESERVE_BIBID on JISHEN.LIB_CIR_RESERVE (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.RESERVE_RDRID on JISHEN.LIB_CIR_RESERVE (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.RESERVE_RESDATE on JISHEN.LIB_CIR_RESERVE (RESDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_CIR_RESERVE
  add constraint PK_LIB_CIR_RESERVE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_CIR_SPELOAN
prompt ==============================
prompt
create table JISHEN.LIB_CIR_SPELOAN
(
  id         NUMBER(10) not null,
  libcode    VARCHAR2(32 CHAR),
  rdrid      NUMBER(10) not null,
  bibid      NUMBER(10) not null,
  loankey    VARCHAR2(50 CHAR),
  rulecode   VARCHAR2(10 CHAR) not null,
  loandate   VARCHAR2(8 CHAR),
  loantime   VARCHAR2(6 CHAR),
  returndate VARCHAR2(8 CHAR),
  location   VARCHAR2(20 CHAR),
  renewnum   NUMBER(6),
  note       VARCHAR2(100 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
  );
create index JISHEN.SPELOAN_BIBID_IDX on JISHEN.LIB_CIR_SPELOAN (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.SPELOAN_RDRID_IDX on JISHEN.LIB_CIR_SPELOAN (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_CIR_SPELOAN
  add constraint PK_LIB_CIR_SPELOAN primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_COM_CONFIG
prompt =============================
prompt
create table JISHEN.LIB_COM_CONFIG
(
  id        NUMBER(10) not null,
  type      VARCHAR2(32 CHAR) not null,
  paramjson VARCHAR2(2048 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_COM_CONFIG.type
  is 'OPAC_CONFIG：opac设置';
alter table JISHEN.LIB_COM_CONFIG
  add constraint PK_LIB_COM_CONFIG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_FORMAT_DESIGN
prompt ================================
prompt
create table JISHEN.LIB_FORMAT_DESIGN
(
  keycode   VARCHAR2(64 CHAR) not null,
  libcode   VARCHAR2(32 CHAR),
  operid    NUMBER(10),
  code      VARCHAR2(32 CHAR),
  name      VARCHAR2(64 CHAR),
  paramjson VARCHAR2(4000 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_FORMAT_DESIGN.keycode
  is '系统生成，LIBCODE_OPERID_CODE_STAMP';
comment on column JISHEN.LIB_FORMAT_DESIGN.code
  is 'E_*输出 S_*统计';
alter table JISHEN.LIB_FORMAT_DESIGN
  add constraint PK_LIB_FORMAT_DESIGN primary key (KEYCODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_HLDLOG
prompt =========================
prompt
create table JISHEN.LIB_HLDLOG
(
  id       NUMBER(10) not null,
  logtype  VARCHAR2(32 CHAR),
  libcode  VARCHAR2(32 CHAR),
  logdate  NUMBER(8),
  logstamp NUMBER(15),
  operid   NUMBER(10),
  hldid    NUMBER(10),
  info1    NUMBER(10),
  info2    NUMBER(10),
  info3    VARCHAR2(30 CHAR),
  info4    VARCHAR2(100 CHAR),
  note     VARCHAR2(100 CHAR),
  ip       VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
create index JISHEN.LIB_HLDLOG_HLDID_IDX on JISHEN.LIB_HLDLOG (HLDID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.LIB_HLDLOG_LOGDATE_IDX on JISHEN.LIB_HLDLOG (LOGDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_HLDLOG
  add constraint PK_LIB_HLDLOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_HOLDINGS
prompt ===========================
prompt
create table JISHEN.LIB_HOLDINGS
(
  id              NUMBER(10) not null,
  bibid           NUMBER(10) not null,
  checkid         NUMBER(10),
  bindid          NUMBER(10),
  rdrid           NUMBER(10),
  libcode         VARCHAR2(32 CHAR),
  curlibcode      VARCHAR2(32 CHAR),
  barcode         VARCHAR2(64 CHAR) not null,
  status          CHAR(1 CHAR),
  callno          VARCHAR2(32 CHAR),
  location        VARCHAR2(32 CHAR),
  curlocation     VARCHAR2(32 CHAR),
  checkdate       NUMBER(8),
  doctype         VARCHAR2(32 CHAR),
  senddate        NUMBER(8),
  loandate        NUMBER(8),
  loantime        NUMBER(6),
  returndate      NUMBER(8),
  renewnum        NUMBER(10),
  volumenum       NUMBER(10),
  volumeinfo      VARCHAR2(128 CHAR),
  otherno         VARCHAR2(32 CHAR),
  assetno         VARCHAR2(32 CHAR),
  shelfno         VARCHAR2(32 CHAR),
  bindtype        VARCHAR2(32 CHAR),
  docsources      VARCHAR2(10 CHAR),
  mediatype       VARCHAR2(32 CHAR),
  price           NUMBER(8,2),
  totalprice      NUMBER(8,2),
  sumloannum      NUMBER(10),
  sumrenewnum     NUMBER(10),
  sumloandays     NUMBER(10),
  checkprice      NUMBER(8,2),
  checktotalprice NUMBER(8,2),
  hlduid          VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 41M
    next 1M
    minextents 1
    maxextents unlimited
  );
create unique index JISHEN.LIB_HOLDINGS_BARCODE_IDX on JISHEN.LIB_HOLDINGS (BARCODE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 6M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_HOLDINGS_BIBID_IDX on JISHEN.LIB_HOLDINGS (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 9M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_HOLDINGS_CHECKID_IDX on JISHEN.LIB_HOLDINGS (CHECKID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_HOLDINGS_RDRID_IDX on JISHEN.LIB_HOLDINGS (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_HOLDINGS
  add constraint PK_LIB_HOLDINGS primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 6M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_PAGE_CONFIG
prompt ==============================
prompt
create table JISHEN.LIB_PAGE_CONFIG
(
  code      VARCHAR2(50 CHAR) not null,
  operid    NUMBER(10),
  paramjson VARCHAR2(2048 CHAR),
  type      VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_PAGE_CONFIG.code
  is 'OPERID+TYPE';
alter table JISHEN.LIB_PAGE_CONFIG
  add constraint PK_LIB_PAGE_CONFIG primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_PER_ALLOCATION
prompt =================================
prompt
create table JISHEN.LIB_PER_ALLOCATION
(
  libcode VARCHAR2(32 CHAR),
  loccode VARCHAR2(32 CHAR),
  linkid  NUMBER(10) not null,
  copies  NUMBER(6) not null,
  type    VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
  );
comment on column JISHEN.LIB_PER_ALLOCATION.type
  is '0订购 1记到';
create index JISHEN.LIB_PER_ALLOCATION_LINKID_IDX on JISHEN.LIB_PER_ALLOCATION (LINKID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_PER_BIND
prompt ===========================
prompt
create table JISHEN.LIB_PER_BIND
(
  id         NUMBER(10) not null,
  libcode    VARCHAR2(32 CHAR),
  bibid      NUMBER(10) not null,
  barcode    VARCHAR2(60 CHAR),
  callno     VARCHAR2(32),
  batchno    VARCHAR2(20),
  price      NUMBER(8,2),
  totalprice NUMBER(8,2),
  doctype    VARCHAR2(32 CHAR),
  loccode    VARCHAR2(32 CHAR),
  binding    VARCHAR2(10 CHAR),
  docsources VARCHAR2(4 CHAR),
  finsources VARCHAR2(4 CHAR),
  mediatype  VARCHAR2(32 CHAR),
  binddate   NUMBER(8),
  operid     NUMBER(10),
  volinfo    VARCHAR2(30 CHAR),
  note       VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 1M
    minextents 1
  );
create index JISHEN.LIB_PER_BIND_BIBID_IDX on JISHEN.LIB_PER_BIND (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_PER_BIND
  add constraint PK_LIB_PER_BIND primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_PER_CHECK
prompt ============================
prompt
create table JISHEN.LIB_PER_CHECK
(
  id         NUMBER(10) not null,
  libcode    VARCHAR2(32 CHAR),
  type       VARCHAR2(32 CHAR) default '0',
  bibid      NUMBER(10) not null,
  orderno    VARCHAR2(20),
  orderid    NUMBER(10),
  frequency  VARCHAR2(4),
  issuenum   NUMBER(6) not null,
  year       NUMBER(6) not null,
  batchno    VARCHAR2(20),
  copies     NUMBER(8) not null,
  price      NUMBER(8,2) not null,
  yearprice  NUMBER(8,2),
  docsources VARCHAR2(10 CHAR),
  mediatype  VARCHAR2(32 CHAR),
  bookseller VARCHAR2(10 CHAR),
  checkdate  NUMBER(8),
  operid     NUMBER(10),
  allocation VARCHAR2(1000 CHAR),
  note       VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_PER_CHECK.type
  is '0卷期1星期2日期';
create index JISHEN.LIB_PER_CHECK_BIBID_IDX on JISHEN.LIB_PER_CHECK (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_PER_CHECK
  add constraint PK_LIB_PER_CHECK primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_PER_DETAIL_CHECK
prompt ===================================
prompt
create table JISHEN.LIB_PER_DETAIL_CHECK
(
  id          NUMBER(10) not null,
  libcode     VARCHAR2(32 CHAR),
  type        VARCHAR2(32 CHAR) default '0',
  bibid       NUMBER(10),
  checkid     NUMBER(10) not null,
  copies      NUMBER(8),
  sortfld     NUMBER(6),
  volume      VARCHAR2(20 CHAR),
  issuenum    NUMBER(6) not null,
  issue       VARCHAR2(20 CHAR),
  totalissue  VARCHAR2(20 CHAR),
  year        NUMBER(6),
  price       NUMBER(8,2),
  status      CHAR(1 CHAR) default '0' not null,
  actualdate  NUMBER(10),
  expectdate  NUMBER(10),
  allocation  VARCHAR2(1000 CHAR),
  operid      NUMBER(10),
  note        VARCHAR2(30 CHAR),
  ordercopies NUMBER(6)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_PER_DETAIL_CHECK.type
  is '0卷期1星期2日期';
comment on column JISHEN.LIB_PER_DETAIL_CHECK.status
  is '0未到1正常2未到齐';
alter table JISHEN.LIB_PER_DETAIL_CHECK
  add constraint PK_LIB_PER_DETAIL_CHECK primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_PER_ORDER
prompt ============================
prompt
create table JISHEN.LIB_PER_ORDER
(
  id         NUMBER(10) not null,
  libcode    VARCHAR2(32 CHAR),
  ordertype  VARCHAR2(32 CHAR) default '0',
  bibid      NUMBER(10) not null,
  orderno    VARCHAR2(20),
  issuenum   NUMBER(6) not null,
  frequency  VARCHAR2(4),
  yearprice  NUMBER(8,2),
  orderyear  NUMBER(6) not null,
  batchno    VARCHAR2(20),
  copies     NUMBER(8) not null,
  ncy        VARCHAR2(10),
  price      NUMBER(8,2),
  orderncy   VARCHAR2(10),
  orderprice NUMBER(8,2),
  docsources VARCHAR2(10 CHAR),
  finsources VARCHAR2(10 CHAR),
  mediatype  VARCHAR2(32 CHAR),
  bookseller VARCHAR2(10 CHAR),
  orderdate  NUMBER(8),
  operid     NUMBER(10),
  note       VARCHAR2(30 CHAR),
  publisher  VARCHAR2(30 CHAR),
  pertype    VARCHAR2(32 CHAR),
  allocation VARCHAR2(1000 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 3M
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.LIB_PER_ORDER.ordertype
  is '0新订1续订';
create index JISHEN.LIB_PER_ORDER_BIBID_IDX on JISHEN.LIB_PER_ORDER (BIBID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 960K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_PER_ORDER
  add constraint PK_LIB_PER_ORDER primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 448K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_READER_COUNT
prompt ===============================
prompt
create table JISHEN.LIB_READER_COUNT
(
  rdrid        NUMBER(10),
  type         VARCHAR2(32 CHAR),
  year         NUMBER(4),
  eventdate    NUMBER(8),
  eventtime    NUMBER(6),
  eventcontent VARCHAR2(1024 CHAR),
  eventnum     VARCHAR2(32 CHAR),
  note         VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_SYSLOG
prompt =========================
prompt
create table JISHEN.LIB_SYSLOG
(
  id       NUMBER(10) not null,
  operid   NUMBER(10) not null,
  type     VARCHAR2(32 CHAR) default '0',
  logdate  NUMBER(8),
  logtime  NUMBER(6),
  status   CHAR(1 CHAR),
  ip       VARCHAR2(32 CHAR),
  location VARCHAR2(32 CHAR),
  area     VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
comment on column JISHEN.LIB_SYSLOG.type
  is '0登录1登出';
create index JISHEN.LIB_SYSLOG_LOGDATE_IDX on JISHEN.LIB_SYSLOG (LOGDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
create index JISHEN.LIB_SYSLOG_OPERID_IDX on JISHEN.LIB_SYSLOG (OPERID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );
alter table JISHEN.LIB_SYSLOG
  add constraint PK_LIB_SYSLOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table LIB_SYS_OPLOG
prompt ============================
prompt
create table JISHEN.LIB_SYS_OPLOG
(
  id       NUMBER(10) not null,
  logtype  VARCHAR2(32 CHAR),
  libcode  VARCHAR2(32 CHAR),
  logdate  NUMBER(8),
  logstamp NUMBER(15),
  operid   NUMBER(10),
  info1    NUMBER(10),
  info2    NUMBER(10),
  info3    VARCHAR2(100 CHAR),
  info4    VARCHAR2(100 CHAR),
  note     VARCHAR2(100 CHAR),
  ip       VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 2M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index JISHEN.LIB_SYS_OPLOG_LOGDATE_IDX on JISHEN.LIB_SYS_OPLOG (LOGDATE)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 832K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_SYS_OPLOG
  add constraint PK_LIB_SYS_OPLOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 576K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LIB_TITLE_NUMBER
prompt ===============================
prompt
create table JISHEN.LIB_TITLE_NUMBER
(
  id      NUMBER(10) not null,
  libcode VARCHAR2(32 CHAR) not null,
  classno VARCHAR2(30 CHAR) not null,
  titnum  NUMBER(8) not null,
  sysid   NUMBER(10) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 768K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.LIB_TITLE_NUMBER
  add constraint PK_LIB_TITLE_NUMBER primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 384K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table LOG_CENTERTYPE
prompt =============================
prompt
create table JISHEN.LOG_CENTERTYPE
(
  logtype  VARCHAR2(32 CHAR),
  typename NVARCHAR2(20)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_BOOKCASE
prompt ============================
prompt
create table JISHEN.OPAC_BOOKCASE
(
  id      NUMBER(10) not null,
  bibid   NUMBER(10),
  rdrid   NUMBER(10),
  regdate NUMBER(8),
  regtime NUMBER(6),
  status  CHAR(1 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.OPAC_BOOKCASE
  add constraint PK_OPAC_BOOKCASE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_BOOKCLASS
prompt =============================
prompt
create table JISHEN.OPAC_BOOKCLASS
(
  classno VARCHAR2(32 CHAR),
  name    VARCHAR2(32 CHAR),
  type    VARCHAR2(32 CHAR),
  num     NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_BOOKREVIEW
prompt ==============================
prompt
create table JISHEN.OPAC_BOOKREVIEW
(
  id         NUMBER(10) not null,
  bibid      NUMBER(10),
  rdrid      NUMBER(10),
  reviewdate NUMBER(8),
  reviewtime NUMBER(6),
  title      VARCHAR2(32 CHAR),
  content    VARCHAR2(1024 CHAR),
  score      CHAR(1 CHAR),
  status     CHAR(1 CHAR),
  parentid   NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.OPAC_BOOKREVIEW
  add constraint PK_OPAC_BOOKREVIEW primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_MYBOOKSHELF
prompt ===============================
prompt
create table JISHEN.OPAC_MYBOOKSHELF
(
  id       NUMBER(10) not null,
  mbtype   VARCHAR2(32 CHAR),
  rdrid    NUMBER(10),
  bibid    NUMBER(10),
  mbdate   VARCHAR2(8 CHAR),
  mbtime   VARCHAR2(6 CHAR),
  linkname VARCHAR2(100 CHAR),
  linkurl  VARCHAR2(1024 CHAR),
  note     VARCHAR2(500 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
  );
comment on column JISHEN.OPAC_MYBOOKSHELF.mbtype
  is '0我的书架1RSS订阅';
create index JISHEN.MYBOOKSHELF_RDRID on JISHEN.OPAC_MYBOOKSHELF (RDRID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_RETRIEVE_BOOKLOG
prompt ====================================
prompt
create table JISHEN.OPAC_RETRIEVE_BOOKLOG
(
  id       NUMBER(10) not null,
  bibid    NUMBER(10),
  type     VARCHAR2(32 CHAR),
  way      VARCHAR2(32 CHAR),
  keyword  VARCHAR2(128 CHAR),
  logdate  NUMBER(8),
  logtime  NUMBER(6),
  classno  VARCHAR2(32 CHAR),
  status   CHAR(1 CHAR),
  ip       VARCHAR2(32 CHAR),
  location VARCHAR2(32 CHAR),
  area     VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.OPAC_RETRIEVE_BOOKLOG
  add constraint PK_OPAC_RETRIEVE_BOOKLOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table OPAC_RETRIEVE_RDRLOG
prompt ===================================
prompt
create table JISHEN.OPAC_RETRIEVE_RDRLOG
(
  id       NUMBER(10) not null,
  rdrid    NUMBER(10),
  bibid    NUMBER(10),
  type     VARCHAR2(32 CHAR),
  way      VARCHAR2(32 CHAR),
  keyword  VARCHAR2(128 CHAR),
  logdate  NUMBER(8),
  logtime  NUMBER(6),
  classno  VARCHAR2(32 CHAR),
  status   CHAR(1 CHAR),
  ip       VARCHAR2(32 CHAR),
  location VARCHAR2(32 CHAR),
  area     VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.OPAC_RETRIEVE_RDRLOG
  add constraint PK_OPAC_RETRIEVE_RDRLOG primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table OPAC_VISIT
prompt =========================
prompt
create table JISHEN.OPAC_VISIT
(
  id       NUMBER(10) not null,
  ip       VARCHAR2(32 CHAR),
  location VARCHAR2(32 CHAR),
  area     VARCHAR2(32 CHAR),
  visits   NUMBER(10),
  vdate    NUMBER(8),
  type     VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.OPAC_VISIT
  add constraint PK_OPAC_VISIT primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table PAR_ACQ_BATCHNO
prompt ==============================
prompt
create table JISHEN.PAR_ACQ_BATCHNO
(
  code       VARCHAR2(32 CHAR) not null,
  libcode    VARCHAR2(32 CHAR) not null,
  bookseller VARCHAR2(10 CHAR),
  type       VARCHAR2(32 CHAR) not null,
  status     CHAR(1 CHAR),
  note       VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_ACQ_BATCHNO.type
  is '1订购2到书3验收';
comment on column JISHEN.PAR_ACQ_BATCHNO.status
  is '1在用2未用';
alter table JISHEN.PAR_ACQ_BATCHNO
  add constraint PK_PAR_ACQ_BATCHNO primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_ACQ_BIND
prompt ===========================
prompt
create table JISHEN.PAR_ACQ_BIND
(
  code VARCHAR2(32 CHAR) not null,
  name VARCHAR2(32 CHAR) not null,
  note VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_ACQ_BIND
  add constraint PK_PAR_ACQ_BIND primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_ACQ_DOCSOURCES
prompt =================================
prompt
create table JISHEN.PAR_ACQ_DOCSOURCES
(
  code VARCHAR2(32 CHAR) not null,
  name VARCHAR2(32 CHAR) not null,
  note VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_ACQ_DOCSOURCES
  add constraint PK_PAR_ACQ_DOCSOURCES primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_ACQ_FINSOURCES
prompt =================================
prompt
create table JISHEN.PAR_ACQ_FINSOURCES
(
  code VARCHAR2(32 CHAR) not null,
  name VARCHAR2(32 CHAR) not null,
  note VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_ACQ_FINSOURCES
  add constraint PK_PAR_ACQ_FINSOURCES primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_ACQ_MEDIA
prompt ============================
prompt
create table JISHEN.PAR_ACQ_MEDIA
(
  code VARCHAR2(32 CHAR) not null,
  name VARCHAR2(32 CHAR) not null,
  note VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_ACQ_MEDIA
  add constraint PK_PAR_ACQ_MEDIA primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_ACQ_RATE
prompt ===========================
prompt
create table JISHEN.PAR_ACQ_RATE
(
  id            NUMBER(10) not null,
  originalncy   VARCHAR2(8 CHAR) not null,
  conversionncy VARCHAR2(8 CHAR) not null,
  rate          NUMBER(8,4) not null,
  note          VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_ACQ_RATE
  add constraint PK_PAR_ACQ_RATE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_CTRLNO
prompt =============================
prompt
create table JISHEN.PAR_CAT_CTRLNO
(
  code          VARCHAR2(32 CHAR) not null,
  libcode       VARCHAR2(32 CHAR),
  name          VARCHAR2(30 CHAR),
  startctrlno   VARCHAR2(32 CHAR),
  endctrlno     VARCHAR2(32 CHAR),
  currentctrlno VARCHAR2(32 CHAR),
  prefix        VARCHAR2(6 CHAR),
  note          VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CAT_CTRLNO
  add constraint PK_PAR_CAT_CTRLNO primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_FIELDHINT
prompt ================================
prompt
create table JISHEN.PAR_CAT_FIELDHINT
(
  field      VARCHAR2(3 CHAR) not null,
  hint       VARCHAR2(30 CHAR) not null,
  indicator1 VARCHAR2(30 CHAR),
  indicator2 VARCHAR2(30 CHAR),
  necess1    CHAR(1 CHAR),
  necess3    CHAR(1 CHAR),
  necess4    CHAR(1 CHAR),
  repeat     CHAR(2 CHAR),
  length     NUMBER(8)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CAT_FIELDHINT
  add constraint PK_PAR_CAT_FIELDHINT primary key (FIELD)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_INDICATORHINT
prompt ====================================
prompt
create table JISHEN.PAR_CAT_INDICATORHINT
(
  field CHAR(3 CHAR) not null,
  type  VARCHAR2(32 CHAR) default '1' not null,
  code  CHAR(1 CHAR) not null,
  hint  VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_CAT_INDICATORHINT.type
  is '1指示符1 2指示符2';

prompt
prompt Creating table PAR_CAT_REPEAT
prompt =============================
prompt
create table JISHEN.PAR_CAT_REPEAT
(
  id        NUMBER(10) not null,
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  sysid     NUMBER(10) not null,
  way       CHAR(1 CHAR) not null,
  paramjson VARCHAR2(500 CHAR) not null,
  note      VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_CAT_REPEAT.way
  is '0与1或';
alter table JISHEN.PAR_CAT_REPEAT
  add constraint PK_PAR_CAT_REPEAT primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_SUBFLDHINT
prompt =================================
prompt
create table JISHEN.PAR_CAT_SUBFLDHINT
(
  field   CHAR(3 CHAR) not null,
  subfld  CHAR(1 CHAR) not null,
  hint    VARCHAR2(30 CHAR) not null,
  symbol  VARCHAR2(10 CHAR),
  necess1 CHAR(1 CHAR),
  necess3 CHAR(1 CHAR),
  necess4 CHAR(1 CHAR),
  repeat  CHAR(2 CHAR),
  length  NUMBER(8)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_TEMPLATE
prompt ===============================
prompt
create table JISHEN.PAR_CAT_TEMPLATE
(
  id        NUMBER(10) not null,
  sysid     NUMBER(10) not null,
  name      VARCHAR2(32 CHAR) not null,
  paramjson VARCHAR2(2048 CHAR) not null,
  note      VARCHAR2(32 CHAR),
  editmodel VARCHAR2(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CAT_TEMPLATE
  add constraint PK_PAR_CAT_TEMPLATE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CAT_Z3950
prompt ============================
prompt
create table JISHEN.PAR_CAT_Z3950
(
  id          NUMBER(10) not null,
  libcode     VARCHAR2(32 CHAR) not null,
  name        VARCHAR2(30 CHAR) not null,
  host        VARCHAR2(50 CHAR) not null,
  port        NUMBER(8) not null,
  database    VARCHAR2(30 CHAR) not null,
  validateway CHAR(1 CHAR),
  account     VARCHAR2(30),
  password    VARCHAR2(30),
  charset     VARCHAR2(10) not null,
  delfield    VARCHAR2(50),
  note        VARCHAR2(30)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_CAT_Z3950.validateway
  is '0帐号密码1免验证';
alter table JISHEN.PAR_CAT_Z3950
  add constraint PK_PAR_CAT_Z3950 primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_CIRRULE
prompt ==============================
prompt
create table JISHEN.PAR_CIR_CIRRULE
(
  id       NUMBER(10) not null,
  libcode  VARCHAR2(32 CHAR) not null,
  rdrtype  VARCHAR2(32 CHAR) not null,
  doctype  VARCHAR2(32 CHAR) not null,
  loanrule VARCHAR2(32) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CIR_CIRRULE
  add constraint PK_PAR_CIR_CIRRULE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_DELAY
prompt ============================
prompt
create table JISHEN.PAR_CIR_DELAY
(
  id      NUMBER(10) not null,
  libcode VARCHAR2(32 CHAR) not null,
  type    VARCHAR2(32 CHAR),
  delay   VARCHAR2(30 CHAR),
  note    VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CIR_DELAY
  add constraint PK_PAR_CIR_DELAY primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_DOCTYPE
prompt ==============================
prompt
create table JISHEN.PAR_CIR_DOCTYPE
(
  code      VARCHAR2(32 CHAR) not null,
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  paramjson VARCHAR2(200 CHAR),
  sortfld   NUMBER(4) default 9999
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CIR_DOCTYPE
  add constraint PK_PAR_CIR_DOCTYPE primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_LOANRULE
prompt ===============================
prompt
create table JISHEN.PAR_CIR_LOANRULE
(
  code      VARCHAR2(32 CHAR) not null,
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  paramjson VARCHAR2(500 CHAR) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CIR_LOANRULE
  add constraint PK_PAR_CIR_LOANRULE primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_READERFIELD
prompt ==================================
prompt
create table JISHEN.PAR_CIR_READERFIELD
(
  id       NUMBER(10) not null,
  name     VARCHAR2(30 CHAR) not null,
  sortfld  NUMBER(3) default 999,
  parentid NUMBER(10)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_CIR_READERFIELD
  add constraint PK_PAR_CIR_READERFIELD primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_READERTYPE
prompt =================================
prompt
create table JISHEN.PAR_CIR_READERTYPE
(
  code      VARCHAR2(32 CHAR) not null,
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  used      CHAR(1 CHAR) default '1',
  sortfld   NUMBER(3) default 999,
  paramjson VARCHAR2(500 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_CIR_READERTYPE.used
  is '0否1是';
alter table JISHEN.PAR_CIR_READERTYPE
  add constraint PK_PAR_CIR_READERTYPE primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_CIR_SPECIAL
prompt ==============================
prompt
create table JISHEN.PAR_CIR_SPECIAL
(
  code      VARCHAR2(32 CHAR) not null,
  spetype   VARCHAR2(32 CHAR),
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  rdrtype   VARCHAR2(32 CHAR) not null,
  loccode   VARCHAR2(32 CHAR) not null,
  paramjson VARCHAR2(500 CHAR) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
  );
comment on column JISHEN.PAR_CIR_SPECIAL.spetype
  is '1专项外借2专项阅览3电子阅览室';
alter table JISHEN.PAR_CIR_SPECIAL
  add constraint PK_PAR_CIR_SPECIAL primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table PAR_PER_FREQUENCY
prompt ================================
prompt
create table JISHEN.PAR_PER_FREQUENCY
(
  code      VARCHAR2(4 CHAR) not null,
  name      VARCHAR2(30 CHAR) not null,
  frequency NUMBER(4) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_PER_FREQUENCY
  add constraint PK_PAR_PER_FREQUENCY primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_PER_PERTYPE
prompt ==============================
prompt
create table JISHEN.PAR_PER_PERTYPE
(
  code VARCHAR2(4 CHAR) not null,
  name VARCHAR2(30 CHAR) not null,
  note VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_PER_PERTYPE
  add constraint PK_PAR_PER_PERTYPE primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_AUTHORITYGROUP
prompt =====================================
prompt
create table JISHEN.PAR_SYS_AUTHORITYGROUP
(
  id           NUMBER(10) not null,
  name         VARCHAR2(10 CHAR) not null,
  funauthority VARCHAR2(3072 CHAR),
  sysauthority VARCHAR2(32 CHAR),
  note         VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_SYS_AUTHORITYGROUP
  add constraint PK_PAR_SYS_AUTHORITYGROUP primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_BARCODE
prompt ==============================
prompt
create table JISHEN.PAR_SYS_BARCODE
(
  id         NUMBER(10) not null,
  type       VARCHAR2(32 CHAR),
  addprefix  VARCHAR2(10 CHAR),
  delprefix  VARCHAR2(10 CHAR),
  length     NUMBER(6),
  conversion CHAR(1 CHAR),
  note       VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 1M
    minextents 1
  );
comment on column JISHEN.PAR_SYS_BARCODE.type
  is '0文献1读者';
comment on column JISHEN.PAR_SYS_BARCODE.length
  is '前缀处理前的长度';
comment on column JISHEN.PAR_SYS_BARCODE.conversion
  is '0不处理 1全小写 2全大写';
alter table JISHEN.PAR_SYS_BARCODE
  add constraint PK_PAR_SYS_BARCODE primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table PAR_SYS_EMAIL
prompt ============================
prompt
create table JISHEN.PAR_SYS_EMAIL
(
  id       NUMBER(10) not null,
  username VARCHAR2(50 CHAR) not null,
  name     VARCHAR2(30 CHAR),
  libcode  VARCHAR2(32 CHAR),
  password VARCHAR2(50 CHAR),
  smtp     VARCHAR2(50 CHAR) not null,
  note     VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.PAR_SYS_EMAIL
  add constraint PK_PAR_SYS_EMAIL primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table PAR_SYS_LIBRARY
prompt ==============================
prompt
create table JISHEN.PAR_SYS_LIBRARY
(
  code         VARCHAR2(32 CHAR) not null,
  parentcode   VARCHAR2(32 CHAR),
  name         VARCHAR2(32 CHAR) not null,
  liblevel     CHAR(1 CHAR),
  note         VARCHAR2(32 CHAR),
  paramjson    VARCHAR2(2048 CHAR),
  completecode VARCHAR2(300 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_SYS_LIBRARY.liblevel
  is '0参数共享馆、1一级馆';
alter table JISHEN.PAR_SYS_LIBRARY
  add constraint PK_PAR_SYS_LIBRARY primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_LOCATION
prompt ===============================
prompt
create table JISHEN.PAR_SYS_LOCATION
(
  code      VARCHAR2(32 CHAR) not null,
  libcode   VARCHAR2(32 CHAR) not null,
  name      VARCHAR2(32 CHAR) not null,
  sortfield NUMBER(4) default 9999,
  note      VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_SYS_LOCATION
  add constraint PK_PAR_SYS_LOCATION primary key (CODE)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_MENU
prompt ===========================
prompt
create table JISHEN.PAR_SYS_MENU
(
  id         NUMBER(10) not null,
  title      VARCHAR2(30 CHAR) not null,
  modulecode VARCHAR2(32 CHAR) not null
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_SYS_MENU.modulecode
  is 'acq.cat.hld.per.cir.par';
alter table JISHEN.PAR_SYS_MENU
  add constraint PK_PAR_SYS_MENU primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_OPERATOR
prompt ===============================
prompt
create table JISHEN.PAR_SYS_OPERATOR
(
  id             NUMBER(10) not null,
  libcode        VARCHAR2(32 CHAR) not null,
  account        VARCHAR2(32 CHAR) not null,
  name           VARCHAR2(32 CHAR) not null,
  password       VARCHAR2(128 CHAR) not null,
  authoritygroup VARCHAR2(124 CHAR),
  note           VARCHAR2(32 CHAR),
  paramjson      VARCHAR2(1024 CHAR),
  opertype       VARCHAR2(32 CHAR) default '0'
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create unique index JISHEN.PAR_SYS_OPERATOR_ACCOUNT_IDX on JISHEN.PAR_SYS_OPERATOR (ACCOUNT)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_SYS_OPERATOR
  add constraint PK_PAR_SYS_OPERATOR primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_OPERLOCATION
prompt ===================================
prompt
create table JISHEN.PAR_SYS_OPERLOCATION
(
  operid    NUMBER(10) not null,
  code      VARCHAR2(32 CHAR) not null,
  authority VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_SYS_OPERLOCATION.authority
  is '(1借、2还、3采编)';
create index JISHEN.PAR_OPERLOCATION_OPERID_IDX on JISHEN.PAR_SYS_OPERLOCATION (OPERID)
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_RULELOCATION
prompt ===================================
prompt
create table JISHEN.PAR_SYS_RULELOCATION
(
  ruleid NUMBER(10),
  code   VARCHAR2(32 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_SCHEDULEDTASK
prompt ====================================
prompt
create table JISHEN.PAR_SYS_SCHEDULEDTASK
(
  id        NUMBER(10) not null,
  type      VARCHAR2(32 CHAR),
  libcode   VARCHAR2(32 CHAR),
  exetime   VARCHAR2(20 CHAR),
  paramjson VARCHAR2(1000 CHAR),
  note      VARCHAR2(50 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 320K
    next 1M
    minextents 1
  );
alter table JISHEN.PAR_SYS_SCHEDULEDTASK
  add constraint PK_PAR_SYS_SCHEDULEDTASK primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
  );

prompt
prompt Creating table PAR_SYS_SUBMENU
prompt ==============================
prompt
create table JISHEN.PAR_SYS_SUBMENU
(
  id         NUMBER(10) not null,
  name       VARCHAR2(30 CHAR) not null,
  url        VARCHAR2(200 CHAR) not null,
  iconcls    VARCHAR2(30 CHAR),
  modulecode VARCHAR2(32 CHAR) not null,
  menuid     NUMBER(10) not null,
  showlevel  NUMBER(6) default 0
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column JISHEN.PAR_SYS_SUBMENU.modulecode
  is 'acq.cat.hld.per.cir.par';
alter table JISHEN.PAR_SYS_SUBMENU
  add constraint PK_PAR_SYS_SUBMENU primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table PAR_SYS_SUBSYSTEM
prompt ================================
prompt
create table JISHEN.PAR_SYS_SUBSYSTEM
(
  id         NUMBER(10) not null,
  name       VARCHAR2(30 CHAR) not null,
  type       VARCHAR2(32 CHAR) default '0',
  marctype   VARCHAR2(32 CHAR) default 'CN',
  showfield  VARCHAR2(500 CHAR),
  indexfield VARCHAR2(1000 CHAR),
  note       VARCHAR2(30 CHAR)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table JISHEN.PAR_SYS_SUBSYSTEM
  add constraint PK_PAR_SYS_SUBSYSTEM primary key (ID)
  using index 
  tablespace JISHEN
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TMP_FINELOG
prompt ==========================
prompt
create table JISHEN.TMP_FINELOG
(
  id       INTEGER,
  rdrid    NUMBER,
  type     CHAR(1),
  money    NUMBER(18,2),
  findate  VARCHAR2(8),
  finstamp VARCHAR2(43),
  operid   NUMBER,
  loccode  NVARCHAR2(20),
  barcode  NVARCHAR2(20),
  hldid    NUMBER,
  bibid    NUMBER,
  rectype  CHAR(1),
  note     NVARCHAR2(500),
  payway   CHAR(1)
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 6M
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TOAD_PLAN_TABLE
prompt ==============================
prompt
create table JISHEN.TOAD_PLAN_TABLE
(
  statement_id      VARCHAR2(30),
  plan_id           NUMBER,
  timestamp         DATE,
  remarks           VARCHAR2(4000),
  operation         VARCHAR2(30),
  options           VARCHAR2(255),
  object_node       VARCHAR2(128),
  object_owner      VARCHAR2(30),
  object_name       VARCHAR2(30),
  object_alias      VARCHAR2(65),
  object_instance   INTEGER,
  object_type       VARCHAR2(30),
  optimizer         VARCHAR2(255),
  search_columns    NUMBER,
  id                INTEGER,
  parent_id         INTEGER,
  depth             INTEGER,
  position          INTEGER,
  cost              INTEGER,
  cardinality       INTEGER,
  bytes             INTEGER,
  other_tag         VARCHAR2(255),
  partition_start   VARCHAR2(255),
  partition_stop    VARCHAR2(255),
  partition_id      INTEGER,
  other             LONG,
  distribution      VARCHAR2(30),
  cpu_cost          INTEGER,
  io_cost           INTEGER,
  temp_space        INTEGER,
  access_predicates VARCHAR2(4000),
  filter_predicates VARCHAR2(4000),
  projection        VARCHAR2(4000),
  time              INTEGER,
  qblock_name       VARCHAR2(30),
  other_xml         CLOB
)
tablespace JISHEN
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating sequence LIB_ACQ_CHECK_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_ACQ_CHECK_SEQ
minvalue 1
maxvalue 10000000000
start with 46
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_ACQ_COLLECTBIB_SEQ
prompt ========================================
prompt
create sequence JISHEN.LIB_ACQ_COLLECTBIB_SEQ
minvalue 1
maxvalue 10000000000
start with 678
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_ACQ_ORDER_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_ACQ_ORDER_SEQ
minvalue 1
maxvalue 10000000000
start with 121616
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_ACQ_RECOMMEND_SEQ
prompt =======================================
prompt
create sequence JISHEN.LIB_ACQ_RECOMMEND_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_BIBLIOGRAPHY_SEQ
prompt ======================================
prompt
create sequence JISHEN.LIB_BIBLIOGRAPHY_SEQ
minvalue 1
maxvalue 10000000000
start with 5000004836
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_BOOKCLASS_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_BOOKCLASS_SEQ
minvalue 1
maxvalue 1000000000000000000000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CAT_SUBJECT_SEQ
prompt =====================================
prompt
create sequence JISHEN.LIB_CAT_SUBJECT_SEQ
minvalue 1
maxvalue 10000000000
start with 154059
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_FINELOG_SEQ
prompt =====================================
prompt
create sequence JISHEN.LIB_CIR_FINELOG_SEQ
minvalue 1
maxvalue 10000000000
start with 431300
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_LOG_SEQ
prompt =================================
prompt
create sequence JISHEN.LIB_CIR_LOG_SEQ
minvalue 1
maxvalue 10000000000
start with 1511635
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_PECCANCY_SEQ
prompt ======================================
prompt
create sequence JISHEN.LIB_CIR_PECCANCY_SEQ
minvalue 1
maxvalue 10000000000
start with 12
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_READER_SEQ
prompt ====================================
prompt
create sequence JISHEN.LIB_CIR_READER_SEQ
minvalue 1
maxvalue 10000000000
start with 25760
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_RESERVE_SEQ
prompt =====================================
prompt
create sequence JISHEN.LIB_CIR_RESERVE_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_CIR_SPELOAN_SEQ
prompt =====================================
prompt
create sequence JISHEN.LIB_CIR_SPELOAN_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_COM_CONFIG_SEQ
prompt ====================================
prompt
create sequence JISHEN.LIB_COM_CONFIG_SEQ
minvalue 1
maxvalue 10000000000
start with 168
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_HLDLOG_SEQ
prompt ================================
prompt
create sequence JISHEN.LIB_HLDLOG_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_HOLDINGS_SEQ
prompt ==================================
prompt
create sequence JISHEN.LIB_HOLDINGS_SEQ
minvalue 1
maxvalue 10000000000
start with 471111
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_PAGE_CONFIG_SEQ
prompt =====================================
prompt
create sequence JISHEN.LIB_PAGE_CONFIG_SEQ
minvalue 1
maxvalue 1000000000000000000000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_PER_BIND_SEQ
prompt ==================================
prompt
create sequence JISHEN.LIB_PER_BIND_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_PER_CHECK_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_PER_CHECK_SEQ
minvalue 1
maxvalue 10000000000
start with 21
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_PER_DETAIL_CHECK_SEQ
prompt ==========================================
prompt
create sequence JISHEN.LIB_PER_DETAIL_CHECK_SEQ
minvalue 1
maxvalue 10000000000
start with 21
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_PER_ORDER_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_PER_ORDER_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_SYSLOG_SEQ
prompt ================================
prompt
create sequence JISHEN.LIB_SYSLOG_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_SYS_OPLOG_SEQ
prompt ===================================
prompt
create sequence JISHEN.LIB_SYS_OPLOG_SEQ
minvalue 1
maxvalue 10000000000
start with 771
increment by 1
cache 20;

prompt
prompt Creating sequence LIB_TITLE_NUMBER_SEQ
prompt ======================================
prompt
create sequence JISHEN.LIB_TITLE_NUMBER_SEQ
minvalue 1
maxvalue 10000000000
start with 20531
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_BOOKCASE_SEQ
prompt ===================================
prompt
create sequence JISHEN.OPAC_BOOKCASE_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_BOOKREVIEW_SEQ
prompt =====================================
prompt
create sequence JISHEN.OPAC_BOOKREVIEW_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_MYBOOKSHELF_SEQ
prompt ======================================
prompt
create sequence JISHEN.OPAC_MYBOOKSHELF_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_RETRIEVE_BOOKLOG_SEQ
prompt ===========================================
prompt
create sequence JISHEN.OPAC_RETRIEVE_BOOKLOG_SEQ
minvalue 1
maxvalue 10000000000
start with 8
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_RETRIEVE_RDRLOG_SEQ
prompt ==========================================
prompt
create sequence JISHEN.OPAC_RETRIEVE_RDRLOG_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence OPAC_VISIT_SEQ
prompt ================================
prompt
create sequence JISHEN.OPAC_VISIT_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_ACQ_RATE_SEQ
prompt ==================================
prompt
create sequence JISHEN.PAR_ACQ_RATE_SEQ
minvalue 1
maxvalue 10000000000
start with 103
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CAT_REPEAT_SEQ
prompt ====================================
prompt
create sequence JISHEN.PAR_CAT_REPEAT_SEQ
minvalue 1
maxvalue 10000000000
start with 23
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CAT_TEMPLATE_SEQ
prompt ======================================
prompt
create sequence JISHEN.PAR_CAT_TEMPLATE_SEQ
minvalue 1
maxvalue 10000000000
start with 3
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CAT_Z3950_SEQ
prompt ===================================
prompt
create sequence JISHEN.PAR_CAT_Z3950_SEQ
minvalue 1
maxvalue 10000000000
start with 6
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CIR_CIRRULE_SEQ
prompt =====================================
prompt
create sequence JISHEN.PAR_CIR_CIRRULE_SEQ
minvalue 1
maxvalue 10000000000
start with 528
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CIR_DELAY_SEQ
prompt ===================================
prompt
create sequence JISHEN.PAR_CIR_DELAY_SEQ
minvalue 1
maxvalue 10000000000
start with 2
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_CIR_READERFIELD_SEQ
prompt =========================================
prompt
create sequence JISHEN.PAR_CIR_READERFIELD_SEQ
minvalue 1
maxvalue 10000000000
start with 121
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_AUTHORITYGROUP_SEQ
prompt ============================================
prompt
create sequence JISHEN.PAR_SYS_AUTHORITYGROUP_SEQ
minvalue 1
maxvalue 10000000000
start with 8
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_BARCODE_SEQ
prompt =====================================
prompt
create sequence JISHEN.PAR_SYS_BARCODE_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_EMAIL_SEQ
prompt ===================================
prompt
create sequence JISHEN.PAR_SYS_EMAIL_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_MENU_SEQ
prompt ==================================
prompt
create sequence JISHEN.PAR_SYS_MENU_SEQ
minvalue 1
maxvalue 10000000000
start with 7101
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_OPERATOR_SEQ
prompt ======================================
prompt
create sequence JISHEN.PAR_SYS_OPERATOR_SEQ
minvalue 1
maxvalue 10000000000
start with 110281
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_SCHEDULEDTASK_SEQ
prompt ===========================================
prompt
create sequence JISHEN.PAR_SYS_SCHEDULEDTASK_SEQ
minvalue 1
maxvalue 10000000000
start with 1
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_SUBMENU_SEQ
prompt =====================================
prompt
create sequence JISHEN.PAR_SYS_SUBMENU_SEQ
minvalue 1
maxvalue 10000000000
start with 7103
increment by 1
cache 20;

prompt
prompt Creating sequence PAR_SYS_SUBSYSTEM_SEQ
prompt =======================================
prompt
create sequence JISHEN.PAR_SYS_SUBSYSTEM_SEQ
minvalue 1
maxvalue 10000000000
start with 3
increment by 1
cache 20;

prompt
prompt Creating sequence TOAD_PLAN_TABLE_SEQ
prompt =====================================
prompt
create sequence JISHEN.TOAD_PLAN_TABLE_SEQ
minvalue 1
maxvalue 10000000000
start with 18
increment by 1
cache 20;

prompt
prompt Creating procedure HANDLESEQ
prompt ============================
prompt
CREATE OR REPLACE PROCEDURE JISHEN."HANDLESEQ" (param_tab varchar2)
Authid Current_User is
cursor tabCursor is
SELECT TABLE_NAME FROM SYS.USER_TAB_COLUMNS WHERE COLUMN_NAME='ID' and length(TABLE_NAME)<25 ;
maxIdStr varchar2(10) ;--当前编号的最大值
sqlStr varchar2(200);--sql语句
seqName varchar2(30);--sequence名字
begin
for tab in tabCursor loop
IF param_tab IS NULL OR param_tab=tab.table_name THEN
maxIdStr:=NULL;
seqName:=tab.table_name||'_SEQ';
sqlStr:='select to_char(case when count(0)=0 then 1 WHEN MAX(T.ID) IS NULL THEN COUNT(0)+1 else max(T.ID)+1 end) from '||tab.table_name ||' T';
execute immediate sqlStr into maxIdStr;
begin
sqlStr:='DROP SEQUENCE '||seqName;
execute immediate sqlStr;
EXCEPTION 
when others then null;
END;

if maxIdStr is not null  then
sqlStr:='CREATE SEQUENCE '||seqName||' START WITH '||maxIdStr||' MAXVALUE 10000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER' ;
else
sqlStr:='CREATE SEQUENCE '||seqName||' START WITH 1 MAXVALUE 10000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER' ;
end if;
execute immediate sqlStr;
end if;
end loop;
end;
/