QSL建表，建序列，建触发器

 酬金支付表
-- Create table
create table PARENTPAYFEE
(
  ID              NUMBER not null,
  MONTH           VARCHAR2(32),
  PARENTID        VARCHAR2(32),
  PARENTNAME      VARCHAR2(32),
  BANKNUMBER      VARCHAR2(32),
  NOWMONTHPAYFEE  VARCHAR2(32),
  NOPAYFEE        VARCHAR2(32),
  CHANGEFEE       VARCHAR2(32),
  NEXTMONTHPAYFEE VARCHAR2(32),
  NOWPAYFEE       VARCHAR2(32) default 0,
  PAYSTATE        VARCHAR2(32) default 0,
  REMARK          VARCHAR2(32)
)
tablespace ZMCC
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns
comment on column PARENTPAYFEE.MONTH
  is '月份';
comment on column PARENTPAYFEE.PARENTID
  is '用户ID';
comment on column PARENTPAYFEE.PARENTNAME
  is '用户姓名';
comment on column PARENTPAYFEE.BANKNUMBER
  is '银行账号';
comment on column PARENTPAYFEE.NOWMONTHPAYFEE
  is '本月销售酬金';
comment on column PARENTPAYFEE.NOPAYFEE
  is '历史未结账酬金';
comment on column PARENTPAYFEE.CHANGEFEE
  is '调整酬金';
comment on column PARENTPAYFEE.NEXTMONTHPAYFEE
  is '转下月发放酬金';
comment on column PARENTPAYFEE.NOWPAYFEE
  is '本月应发酬金';
comment on column PARENTPAYFEE.PAYSTATE
  is '支付状态';
comment on column PARENTPAYFEE.REMARK
  is '备注';

-- Create/Recreate primary, unique and foreign key constraints

alter table PARENTPAYFEE
  add constraint PK_PARENTPAYFEE primary key (ID)
  using index
  tablespace ZMCC
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

序列
create sequence SEQ_parentpayfee
minvalue 1
maxvalue 9999999999999999999999999
start with 21
increment by 1
cache 10
order;

建触发器
CREATE OR REPLACE TRIGGER tr_parentpayfee
BEFORE INSERT
ON ZMCC.parentpayfee
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
  select SEQ_parentpayfee.Nextval into :new.id from dual;
END;