通寶+充值作廢 · 通寶+平臺

### **t_give_obsolete**（原贈送記錄表t_give）贈送作廢的訂單** create sequence seq_give_obsolete_id increment by 1 start with 1 nomaxvalue nominvalue nocache; ### 創建表 CREATE TABLE "TONGBAO"."T_GIVE_OBSOLETE" ( "ID" CHAR(10 BYTE) NOT NULL ENABLE, "GIVE_ID" CHAR(10 BYTE) NOT NULL ENABLE, "RNUM" VARCHAR2(60 BYTE), "CUSTOMID" CHAR(8 BYTE) NOT NULL ENABLE, "ACCOUNTID" CHAR(10 BYTE) NOT NULL ENABLE, "SCORE" NUMBER(10,2), "TYPE" VARCHAR2(5 BYTE) DEFAULT 6, "PAYTYPE" VARCHAR2(5 BYTE) NOT NULL ENABLE, "DATETIME" VARCHAR2(20 BYTE) NOT NULL ENABLE, "VERSIONS" VARCHAR2(50 BYTE) NOT NULL ENABLE, "DATEYMD" VARCHAR2(20 BYTE), "BALANCE" NUMBER(10,2), "GIVESTATUS" VARCHAR2(2 BYTE) DEFAULT 1, "ORIGINAL_DATETIME" VARCHAR2(20 BYTE) NOT NULL ENABLE, CONSTRAINT "T_GIVE_OBSOLETE_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ; ###備注信息 COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."GIVE_ID" IS '原贈送id'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."RNUM" IS '充值單號'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."CUSTOMID" IS '會員ID'； COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."ACCOUNTID" IS '賬戶ID'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."SCORE" IS '贈送積分'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."TYPE" IS '默認6:系統'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."PAYTYPE" IS '積分補償（611）、福利積分（612）、活動贈送（613）、充值活動贈送（614）、普通贈送（666）'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."DATETIME" IS '寫入時間,時間戳'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."VERSIONS" IS '版本號'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."DATEYMD" IS '日期'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."BALANCE" IS '計息金額'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."GIVESTATUS" IS '1領取2未領取'; COMMENT ON COLUMN "TONGBAO"."T_GIVE_OBSOLETE"."ORIGINAL_DATETIME" IS '原訂單時間'; ### **t_recharge_obsolete**（原贈送記錄表t_recharge）贈送作廢的訂單** create sequence seq_recharge_obsolete_id increment by 1 start with 1 nomaxvalue nominvalue nocache; ### 創建表 CREATE TABLE "TONGBAO"."T_RECHARGE_OBSOLETE" ( "ID" CHAR(10 BYTE) NOT NULL ENABLE, "NUM" VARCHAR2(60 BYTE), "PAYAMOUNT" NUMBER(10,2), "BALANCE" NUMBER(10,2), "ORIGINAL_TIME" VARCHAR2(20 BYTE) NOT NULL ENABLE, "DATETIME" VARCHAR2(20 BYTE) NOT NULL ENABLE, CONSTRAINT "T_RECHARGE_OBSOLETE_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ; ### 備注信息 COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."NUM" IS '原充值訂單號'; COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."PAYAMOUNT" IS '充值的訂單積分'; COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."BALANCE" IS '充值剩余的訂單積分'; COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."ORIGINAL_TIME" IS '原充值訂單時間'; COMMENT ON COLUMN "TONGBAO"."T_RECHARGE_OBSOLETE"."DATETIME" IS '處理訂單時間'; ### **t_AMOUNT_record**（原贈送記錄表t_amount）贈送作廢的訂單** create sequence seq_amount_record_id increment by 1 start with 1 nomaxvalue nominvalue nocache; ### 創建表 CREATE TABLE "TONGBAO"."T_AMOUNT_RECORD" ( "ID" CHAR(10 BYTE) NOT NULL ENABLE, "ORIGINAL_ACCOUNT" VARCHAR2(2000 BYTE), "CHANGE_ACCOUNT" VARCHAR2(2000 BYTE), "AMOUNT" NUMBER(10,2), "TYPE" VARCHAR2(2 BYTE) NOT NULL ENABLE, "REMARK" VARCHAR2(200 BYTE) NOT NULL ENABLE, "DATETIME" VARCHAR2(20 BYTE) NOT NULL ENABLE, “OBSOLETE_NUM” VARCHAR2(200 BYTE) NOT NULL ENABLE, CONSTRAINT "T_AMOUNT_RECORD_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ; ### 備注信息 COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."ORIGINAL_ACCOUNT" IS '原賬戶所有的信息'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."CHANGE_ACCOUNT" IS '變更后的賬戶所有的信息'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."AMOUNT" IS '處理的積分'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."TYPE" IS '1是本金，2是贈送積分'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."REMARK" IS '備注信息'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."DATETIME" IS '處理訂單時間'; COMMENT ON COLUMN "TONGBAO"."T_AMOUNT_RECORD"."OBSOLETE_NUM" IS '處理作廢的訂單號';