建表参数

create sequence TOUSUADMIN_SEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 1201
increment by 1
cache 20;

-- Create table
create table TOUSUADMIN
(
  TOUSUID                NUMBER(10) not null,
  TOUSUPERSON            VARCHAR2(10),
  TOUSUCONTACT           VARCHAR2(20),
  TOUSUTIMES             DATE default SYSDATE,
  TOUSUDEP               VARCHAR2(500),
  TOUSUPASSIVEPERSON     VARCHAR2(20),
  TOUSUCONTENT           VARCHAR2(3000),
  TOUSUENTERTAINEDPERSON VARCHAR2(10),
  TOUSUVERIFYTIMES       DATE default SYSDATE,
  TOUSUVERIFYCONTENT     VARCHAR2(3000),
  TOUSUVERIFYPERSON      VARCHAR2(3000),
  TOUSUFEEDBACKRESULTS   VARCHAR2(3000),
  TOUSUFEEDBACKTIMES     DATE default SYSDATE,
  TOUSUFEEDBACKPERSON    VARCHAR2(3000),
  TOUSUSTATE             NUMBER(1),
  TOUSUTYPESTR           VARCHAR2(40),
  TOUSUISTRUE            NUMBER(1) default 0,
  TOUSUFORDOCUMENTS      VARCHAR2(200),
  TOUSUFORDOCUMENTSID    VARCHAR2(20),
  TOUSUNETFLAG           NUMBER(1)
)
tablespace SYSTEM
  pctfree 10 
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table TOUSUADMIN
  add constraint PK_TOUSUADMIN primary key (TOUSUID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );