ZX创建表 提现结果

admin

CREATE TABLE   LJ_WITH_RESULT(

  "ID" NUMBER,
  "USER_ID"  VARCHAR2(15),
  "USER_NAME" VARCHAR2(64),
  "TRANS_DT" DATE,
  "BUSS_ID" VARCHAR2(64),
  "WITH_AMT"  DECIMAL(17,2) ,
   "FEE" DECIMAL(17,2) ,
   "ORI_USER_SSN" VARCHAR2(64),
   "WITH_nature"  VARCHAR2(2),
   "WITH_ACCNAME"  VARCHAR2(64),
   "WITH_ID" VARCHAR2(32),
   "WITH_TYPE"  VARCHAR2(2),
    "result"  VARCHAR2(2),
    "describe"  VARCHAR2(200),
   "FEE_TYPE"  VARCHAR2(1)

)

'创建唯一值,防止重复插入
Alter Table LJ_WITH_RESULT
add primary key (ORI_USER_SSN)


'创建ID索引 自增
create sequence  LJ_WITH_RESULT_id_seq
increment by 1
start with 1
maxvalue 999999999 ;



create trigger LJ_WITH_RESULT_tri  before
insert on LJ_WITH_RESULT  for each row
when (new.id is null)  
begin
select LJ_WITH_RESULT_id_seq.nextval into:new.id from dual;
end;
--创建索引
create index Idx_LJ_WITH_RESULT_id_seq on LJ_WITH_RESULT(ID);