表：t_billNumber

-- Create table
create table T_BILLNUMBER
(
  F_INTBILLNUMBERID  NUMBER(10) not null,
  F_STRCATEGORY      NVARCHAR2(100) not null,
  F_STRBILLNAME      NVARCHAR2(100) not null,
  F_STRPRESTRING     NVARCHAR2(100),
  F_STRSUFSTRING     NVARCHAR2(100),
  F_INTCURRENTNUMBER NUMBER(10),
  F_STRFORMAT        NVARCHAR2(100),
  F_STRNOTE          NVARCHAR2(2000),
  F_SEQ_NAME         NVARCHAR2(100)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table T_BILLNUMBER
  is '单据编号表';
-- Add comments to the columns 
comment on column T_BILLNUMBER.F_INTBILLNUMBERID
  is '主键';
comment on column T_BILLNUMBER.F_STRCATEGORY
  is '单据编号代码（唯一）';
comment on column T_BILLNUMBER.F_STRBILLNAME
  is '单据编号名称';
comment on column T_BILLNUMBER.F_STRPRESTRING
  is '前缀';
comment on column T_BILLNUMBER.F_STRSUFSTRING
  is '后缀';
comment on column T_BILLNUMBER.F_INTCURRENTNUMBER
  is '当前编号(废止)';
comment on column T_BILLNUMBER.F_STRFORMAT
  is '格式';
comment on column T_BILLNUMBER.F_STRNOTE
  is '备注';
comment on column T_BILLNUMBER.F_SEQ_NAME
  is '序列名称( Sequences )';
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_BILLNUMBER
  add constraint PK_BILLNUMBER primary key (F_INTBILLNUMBERID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate check constraints 
alter table T_BILLNUMBER
  add constraint CK_F_INTCURRENTNUMBER
  check (F_INTCURRENTNUMBER>-1);
-- Create/Recreate indexes 
create unique index UN_F_STRCATEGORY on T_BILLNUMBER (F_STRCATEGORY)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );