#消费表-增加代他付积分消费
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手机号查询信息接口