🔥码云GVP开源项目 12k star Uniapp+ElementUI 功能强大 支持多语言、二开方便！ 广告
### **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 '处理作废的订单号';