#消費表-增加代他付積分消費
alter table t_consume add tph_amount NUMBER(10,2) default 0 ;
comment on column t_consume .tph_amount is '消費代他付金額(贈送積分)';
#白名單增加代他付
alter table t_white_list add payhim_status NUMBER(10,2) default 2 ;
comment on column t_white_list .payhim_status is '代他付';
#消費表-增加代他付積分消費類型
alter table t_consume add paytype VARCHAR2(20) default '801' ;
comment on column t_consume .paytype is '消費類型:默認:801 代他付消費:802';
#明細表-增加代他付消費積分
alter table t_accountdetails add tph_amount NUMBER(10,2) default 0 ;
comment on column t_accountdetails.tph_amount is '消費代他付金額(贈送積分)'';
#賬戶表--添加字段timer(計數器) 用于樂觀鎖
alter table t_amount add timer VARCHAR2(20) default 0 ;
comment on column t_amount .timer is '添加字段timer(計數器) 用于樂觀鎖';
#賬戶表--添加字段timer(計數器) 用于樂觀鎖
alter table t_amount add timer VARCHAR2(20) default 0 ;
comment on column t_amount .timer is '添加字段timer(計數器) 用于樂觀鎖';
#賬戶表計數器增加自增的信息
create sequence seq_timer_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
#代他付設置表
create sequence seq_topayhim_rule_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
#表名t_ToPayHim_rule
CREATE TABLE "TONGBAO"."T_TOPAYHIM_RULE"
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"ORIGIN_AMOUNT" NUMBER(12,2),
"ORIGIN_SCORE" NUMBER(12,2),
"LV" NUMBER(12,2),
"RECHARGE_LV" NUMBER(12,2),
"OUT_WX_LV" NUMBER(12,2),
"IS_OUT_WX_SHOW" VARCHAR2(20 BYTE) DEFAULT 1,
"QZKDJ_WX_LV" VARCHAR2(20 BYTE) DEFAULT 1,
"IS_QZKDJ_WX_SHOW" VARCHAR2(20 BYTE) DEFAULT 1,
"QZDYP_WX_LV" NUMBER(12,2),
"IS_QZDYP_WX_SHOW" VARCHAR2(20 BYTE) DEFAULT 1,
"PHONE_WX_LV" NUMBER(12,2),
"IS_PHONE_WX_SHOW" VARCHAR2(20 BYTE) DEFAULT 1,
"OIL_WX_LV" NUMBER(12,2),
"IS_OIL_WX_SHOW" VARCHAR2(20 BYTE) DEFAULT 1,
"DATETIME" VARCHAR2(20 BYTE),
"USERID" VARCHAR2(20 BYTE),
"USERNAME" VARCHAR2(20 BYTE),
"TEXT_RULE" CLOB,
CONSTRAINT "T_TOPAYHIM_RULE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."ORIGIN_AMOUNT" IS '設置門檻';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."ORIGIN_SCORE" IS '開通門檻';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."LV" IS '充入通寶+本金是消耗贈送積分的比例';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."RECHARGE_LV" IS '手續費率';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."OUT_WX_LV" IS '外拓微信支付折扣';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."IS_OUT_WX_SHOW" IS '是否開啟外拓微信支付折扣 默認1:關閉 2:開啟';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."QZKDJ_WX_LV" IS '千豬肯德基微信支付折扣';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."IS_QZKDJ_WX_SHOW" IS '是否開啟千豬肯德基微信支付折扣 默認1:關閉 2:開啟';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."QZDYP_WX_LV" IS '千豬電影票微信支付折扣';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."IS_QZDYP_WX_SHOW" IS '是否開啟千豬肯德基微信支付折扣 默認1:關閉 2:開啟';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."PHONE_WX_LV" IS '話費充值微信支付折扣';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."IS_PHONE_WX_SHOW" IS '是否開啟話費微信充值折扣 默認1:關閉 2:開啟';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."OIL_WX_LV" IS '加油卡充值微信支付折扣';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."IS_OIL_WX_SHOW" IS '是否開啟j加油卡微信充值折扣 默認1:關閉 2:開啟';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."DATETIME" IS '創建的時間';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."USERID" IS '用戶的id';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."USERNAME" IS '用戶的名稱';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_RULE"."TEXT_RULE" IS '規則文本描述';
#代他付記錄表
create sequence seq_topayhim_log_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
#表名t_ToPayHim_log
CREATE TABLE "TONGBAO"."T_TOPAYHIM_LOG"
(
"ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"NUM" VARCHAR2(50 BYTE),
"OUTNO" VARCHAR2(50 BYTE),
"CUSTOMID" VARCHAR2(20 BYTE),
"CONTENT" VARCHAR2(200 BYTE),
"TYPE" VARCHAR2(20 BYTE) DEFAULT 1,
"SCORE" NUMBER(12,2),
"BEFOR_SCORE" NUMBER(12,2),
"AFTER_SCORE" NUMBER(12,2),
"DATETIME" VARCHAR2(20 BYTE),
"DATEYMD" VARCHAR2(20 BYTE),
"ADDTIME" VARCHAR2(20 BYTE),
"IS_SHOW" VARCHAR2(20 BYTE)DEFAULT 2 ,
CONSTRAINT "T_TOPAYHIM_LOG_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."NUM" IS '流水號(充值,活消費)';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."OUTNO" IS '外部流水號';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."CUSTOMID" IS '會員ID';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."CONTENT" IS '消費內容';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."TYPE" IS '1,代他付2,會員消費 3.設置額度操作';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."SCORE" IS '交易金額';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."BEFOR_SCORE" IS '交易前金額';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."AFTER_SCORE" IS '交易后金額';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."DATETIME" IS '交易時間(此時間為業務方發生交易時間)';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."DATEYMD" IS '交易日期';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."ADDTIME" IS '添加時間';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_LOG"."IS_SHOW" IS '前端是否展示1.關閉,2正常 默認2';
#代他付賬戶表
create sequence seq_topayhim_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
#表名t_ToPayHim
CREATE TABLE "TONGBAO"."T_TOPAYHIM"
(
"ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"NUM" VARCHAR2(50 BYTE),
"CUSTOMID" VARCHAR2(20 BYTE),
"SET_AMOUNT" NUMBER(12,2) DEFAULT 0,
"AMOUNT" NUMBER(12,2) DEFAULT 0,
"RANKING" VARCHAR2(200 BYTE) DEFAULT 0,
"ORDERING" VARCHAR2(200 BYTE) DEFAULT 1,
"DATETIME" VARCHAR2(20 BYTE),
"STATUS" VARCHAR2(20 BYTE) DEFAULT 2,
"IS_SHOW" VARCHAR2(20 BYTE) DEFAULT 2,
"TIMER" VARCHAR2(200 BYTE) DEFAULT 0,
CONSTRAINT "T_TOPAYHIM_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."NUM" IS '設置開啟代他付num訂單信息';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."CUSTOMID" IS '會員ID';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."SET_AMOUNT" IS '開通金額';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."AMOUNT" IS '當前剩余開通額度';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."RANKING" IS '主排序';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."ORDERING" IS '次排序 1是不開啟，2是開啟，默認1';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."DATETIME" IS '開通時間';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."STATUS" IS '是否關閉1,關閉,2正常';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."IS_SHOW" IS '前端是否展示1.關閉,2正常';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM"."TIMER" IS '添加字段timer(計數器) 用于樂觀鎖';
#代他付超賣表
create sequence seq_topayhim_error_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
#表名t_ToPayHim
CREATE TABLE "TONGBAO"."T_TOPAYHIM_ERROR"
(
"ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"STATUS" VARCHAR2(20 BYTE) DEFAULT 1,
"TYPE" VARCHAR2(20 BYTE) DEFAULT 1,
"DATA" VARCHAR2(2000 BYTE),
"OUTNO" VARCHAR2(50 BYTE),
CONSTRAINT "T_TOPAYHIM_ERROR_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_ERROR"."STATUS" IS 'status狀態:1未處理2已處理';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_ERROR"."DATA" IS 'json數據';
COMMENT ON COLUMN "TONGBAO"."T_TOPAYHIM_ERROR"."OUTNO" 外部訂單';
- 通寶+后臺
- 新數據字典
- 測試數據庫配置
- 核心賬戶改造需求文檔
- 物業霸王餐
- 物業霸王餐上線流程
- 4月27版本上線數據庫變動情況
- 5月7日2.22版本上線數據庫變動情況
- 5月7日2.22版本上線須知
- 5月26日2.23版本數據庫變動情況
- 6月9日2.24版本數據庫變動情況
- 7月22日2.25版本數據庫變動情況
- 9月4日2.26版本數據庫變動情況
- 11月11日添加匯款規則設置
- 20.11.23大額轉賬轉用大額組件
- 20.11.25監控mns異常消息
- 20.12.04 通寶+入口限制
- 20.12.24 3.0通寶+階梯利率
- 21.01.08 通寶+遷移景安方案
- 21.01.29 物業霸王餐2.0
- 21.02.02 結算添加88折補貼金額
- 21.03.22 大額匯款贈送活動增加限制條件
- 21.05.20 代他付
- 21.06.28 充值對賬
- 21.07.03 添加折扣退款補貼
- 8月14版本,前端icon優化
- D0對賬
- 賬戶注銷
- 通寶+充值作廢
- 通寶+商家商戶信息
- 上線注意事項
- 上線執行sql語句
- 物業繳費
- 1.查詢用戶欠費綁定的信息
- 2.1手機號查詢信息接口