oracle 标准建表语句

create table TABLENAME
(
  STOCKID       NUMBER not null,
  USERID        NUMBER,
  MODEL         VARCHAR2(100),
  MAKER         VARCHAR2(100),
  AMOUNT        NUMBER default 0,
  LOTNUMBER     VARCHAR2(100),
  UPTRANSDATE   DATE default SYSDATE,
  PRICE         NUMBER(8,2) default 0,
  STATE         NUMBER default 0,
  ENCAPSULATION VARCHAR2(50),
  DESCRIBE      VARCHAR2(1000),
  VOUCH         NUMBER default 1,
  SPOTGOODS     NUMBER default 0
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 16
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table TABLENAME
  add constraint PK_SYSICSTOCK primary key (STOCKID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );
alter table TABLENAME
  add constraint FK_SYSICSTO_IC foreign key (USERID)
  references SYSMEMBER (USERID);
-- Create/Recreate indexes 
create index INDEX_MODEL on TABLENAME (MODEL)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );