alter table t_gross_amount add endowment number(12,2);--墊付金額
alter table t_gross_amount add repayment number(12,2);--償還金額
alter table t_orders add toolid char(8);--管家ID
create sequence seq_history_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_gross_detail_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
CREATE TABLE "TONGBAO"."T_GROSS_DETAIL"
( "ID" VARCHAR2(20 BYTE),
"BALANCE" NUMBER(12,2),
"SCORE" NUMBER(12,2),
"RESERVED" NUMBER(14,2),
"CURRENTFUND" NUMBER(14,2),
"HASINVESTED" NUMBER(14,2),
"FROST" NUMBER(14,2),
"ENDOWMENT" NUMBER(14,2),
"REPAYMENT" NUMBER(14,2),
"DATETIME" VARCHAR2(20 BYTE),
"DATEYMD" VARCHAR2(20 BYTE),
"TYPE" VARCHAR2(20 BYTE),
"NUM" VARCHAR2(50 BYTE),
"AMOUNT" NUMBER(14,2),
"AMOUNT_AFTER" NUMBER(14,2),
"RESERVED_AFTER" NUMBER(14,2),
"CURRENTFUND_AFTER" NUMBER(14,2),
"HASINVESTED_AFTER" NUMBER(14,2),
"FROST_AFTER" NUMBER(14,2),
"ENDOWMENT_AFTER" NUMBER(14,2),
"REPAYMENT_AFTER" NUMBER(14,2),
"CUSTOMID" CHAR(8 BYTE)
) 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_GROSS_DETAIL"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."BALANCE" IS '本金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."SCORE" IS '積分';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."RESERVED" IS '操作前預留資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."CURRENTFUND" IS '操作前當前賬戶資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."HASINVESTED" IS '操作前當前已投資';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."FROST" IS '操作前凍結資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."ENDOWMENT" IS '操作前墊付金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."REPAYMENT" IS '操作前償還金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."DATETIME" IS '添加時間';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."DATEYMD" IS '添加日期';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."TYPE" IS '操作類型';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."NUM" IS '流水號';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."AMOUNT" IS '操作前總金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."AMOUNT_AFTER" IS '操作后總金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."RESERVED_AFTER" IS '操作后預留資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."CURRENTFUND_AFTER" IS '操作后當前賬戶資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."HASINVESTED_AFTER" IS '操作后當前已投資';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."FROST_AFTER" IS '操作后凍結資金';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."ENDOWMENT_AFTER" IS '操作后墊付金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."REPAYMENT_AFTER" IS '操作后償還金額';
COMMENT ON COLUMN "TONGBAO"."T_GROSS_DETAIL"."CUSTOMID" IS '會員ID';
CREATE TABLE "TONGBAO"."T_HISTORY"
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"CURRENTFUND" NUMBER(14,2),
"RESERVED" NUMBER(14,2),
"HASINVESTED" NUMBER(14,2),
"ENDOWMENT" NUMBER(14,2),
"REPAYMENT" NUMBER(14,2),
"AMOUNT" NUMBER(14,2),
"FROST" NUMBER(14,2),
"GIVE_ALLSCORE" NUMBER(14,2),
"GIVE_DAY" NUMBER(14,2),
"GIVE_DAY_A" NUMBER(14,2),
"GIVE_DAY_B" NUMBER(14,2),
"GIVE_DAY_C" NUMBER(14,2),
"GIVE_DAY_D" NUMBER(14,2),
"RE_BALANCE" NUMBER(14,2),
"RE_PAYAMOUNT" NUMBER(14,2),
"RE_DAY_PAYAMOUNT" NUMBER(14,2),
"RE_DAY_BALANCE" NUMBER(14,2),
"RE_PAYAMOUNT_SP" NUMBER(14,2),
"RE_BALANCE_SP" NUMBER(14,2),
"RE_DAY_PAYAMOUNT_SP" NUMBER(14,2),
"RE_DAY_BALANCE_SP" NUMBER(14,2),
"RE_PAYAMOUNT_WY" NUMBER(14,2),
"RE_BALANCE_WY" NUMBER(14,2),
"RE_DAY_PAYAMOUNT_WY" NUMBER(14,2),
"RE_DAY_BALANCE_WY" NUMBER(14,2),
"RE_DAY_AMOUNT" NUMBER(14,2),
"RE_DAY_COUNT" NUMBER(14,2),
"RE_DAY_NOAMOUNT" NUMBER(14,2),
"RE_DAY_NOCOUNT" NUMBER(14,2),
"RE_DAY_COUNT_NO" NUMBER(14,2),
"RE_DAY_CUSTOMID_B" NUMBER(14,2),
"RE_DAY_PAYAMOUNT_B" NUMBER(14,2),
"RE_DAY_COUNT_B" NUMBER(14,2),
"RE_DAY_PAYAMOUNT_A" NUMBER(14,2),
"RE_DAY_COUNT_A" NUMBER(14,2),
"AM_BALANCE" NUMBER(14,2),
"AM_SCORE" NUMBER(14,2),
"AM_ALLSCORE" NUMBER(14,2),
"AM_NOBALANCE" NUMBER(14,2),
"AM_DEPOSIT_AMOUNT" NUMBER(14,2),
"AM_AMOUNT" NUMBER(14,2),
"RAN_AMOUNT" NUMBER(14,2),
"RAN_AMOUNT_DAY" NUMBER(14,2),
"RAN_COUNT_DAY" NUMBER(14,2),
"RAN_CUSTOMID_DAY" NUMBER(14,2),
"RAN_AMOUNT_BACK" NUMBER(14,2),
"RAN_COUNT_BACK" NUMBER(14,2),
"CON_AMOUNT" NUMBER(14,2),
"CON_SCORE" NUMBER(14,2),
"CON_TAL_DAY" NUMBER(14,2),
"CON_COUNT_DAY" NUMBER(14,2),
"CON_CUSOTMID_DAY" NUMBER(14,2),
"CON_AMOUNT_DAY" NUMBER(14,2),
"CON_SCORE_DAY" NUMBER(14,2),
"CON_CUSOTMID_DAY_A" NUMBER(14,2),
"CON_COUNT_DAY_A" NUMBER(14,2),
"CON_CUSOTMID_DAY_B" NUMBER(14,2),
"CON_COUNT_DAY_B" NUMBER(14,2),
"CONBACK_COUNT_DAY" NUMBER(14,2),
"CONBACK_CUSOTMID_DAY" NUMBER(14,2),
"CONBACK_AMOUNT_DAY" NUMBER(14,2),
"CONBACK_SCORE_DAY" NUMBER(14,2),
"CONBACK_COUNT_DAY_A" NUMBER(14,2),
"CONBACK_CUSOTMID_DAY_A" NUMBER(14,2),
"CONBACK_COUNT_DAY_B" NUMBER(14,2),
"CONBACK_CUSOTMID_DAY_B" NUMBER(14,2),
"CU_COUNT" NUMBER(14,2),
"CU_COUNT_A" NUMBER(14,2),
"CU_COUNT_B" NUMBER(14,2),
"CU_COUNT_C" NUMBER(14,2),
"CU_COUNT_D" NUMBER(14,2),
"CU_COUNT_E" NUMBER(14,2),
"CU_COUNT_I" NUMBER(14,2),
"DATETIME" VARCHAR2(20 BYTE),
"DATEYMD" VARCHAR2(20 BYTE),
CONSTRAINT "T__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_HISTORY"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CURRENTFUND" IS '閑置資金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RESERVED" IS '備付金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."HASINVESTED" IS '再投資金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."ENDOWMENT" IS '墊付資金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."REPAYMENT" IS '償還資金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AMOUNT" IS '系統賬戶余額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."FROST" IS '系統凍結資金';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_ALLSCORE" IS '總贈送積分';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_DAY" IS '日贈送積分';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_DAY_A" IS '日普通贈送';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_DAY_B" IS '日補償贈送';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_DAY_C" IS '日商品霸王餐贈送';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."GIVE_DAY_D" IS '日物業霸王餐贈送';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_BALANCE" IS '子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_PAYAMOUNT" IS '子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_PAYAMOUNT" IS '日子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_BALANCE" IS '日子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_PAYAMOUNT_SP" IS '商品霸王餐子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_BALANCE_SP" IS '商品霸王餐子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_PAYAMOUNT_SP" IS '日商品霸王餐子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_BALANCE_SP" IS '日商品霸王餐子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_PAYAMOUNT_WY" IS '物業霸王餐子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_BALANCE_WY" IS '物業霸王餐子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_PAYAMOUNT_WY" IS '日物業霸王餐子賬戶總充值';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_BALANCE_WY" IS '日物業霸王餐子賬戶總剩余';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_AMOUNT" IS '當日參與計息的金額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_COUNT" IS '當日參與計息的總條數';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_NOAMOUNT" IS '低于計息條件子賬戶余額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_NOCOUNT" IS '低于計息條件子賬戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_COUNT_NO" IS '無效子賬戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_CUSTOMID_B" IS '非普通本金購買人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_PAYAMOUNT_B" IS '非普通本金購買金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_COUNT_B" IS '非普通本金購買筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_PAYAMOUNT_A" IS '普通本金購買金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RE_DAY_COUNT_A" IS '普通本金購買筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_BALANCE" IS '個人賬戶總余額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_SCORE" IS '個人賬戶總剩余積分';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_ALLSCORE" IS '個人賬戶總贈送積分';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_NOBALANCE" IS '個人賬戶總凍結金額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_DEPOSIT_AMOUNT" IS '個人賬戶總定存金額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."AM_AMOUNT" IS '個人賬戶總余額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_AMOUNT" IS '用戶累計提現金額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_AMOUNT_DAY" IS '贖回本金金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_COUNT_DAY" IS '贖回本金筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_CUSTOMID_DAY" IS '贖回本金人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_AMOUNT_BACK" IS '贖回回退';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."RAN_COUNT_BACK" IS '贖回回退筆數';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_AMOUNT" IS '用戶累計消費金額';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_SCORE" IS '用戶累計消費積分';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_TAL_DAY" IS '消費金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_COUNT_DAY" IS '消費筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_CUSOTMID_DAY" IS '消費人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_AMOUNT_DAY" IS '消費本金金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_SCORE_DAY" IS '消費積分金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_CUSOTMID_DAY_A" IS '含本金消費人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_COUNT_DAY_A" IS '含本金消費筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_CUSOTMID_DAY_B" IS '含積分消費人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CON_COUNT_DAY_B" IS '含積分消費筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_COUNT_DAY" IS '退款筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_CUSOTMID_DAY" IS '退款人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_AMOUNT_DAY" IS '退款金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_SCORE_DAY" IS '退款本金金額合計(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_COUNT_DAY_A" IS '含本金退款筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_CUSOTMID_DAY_A" IS '含本金退款人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_COUNT_DAY_B" IS '含本金退款筆數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CONBACK_CUSOTMID_DAY_B" IS '含本金退款人數(日)';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT" IS '用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_A" IS '認證用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_B" IS '有余額用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_C" IS '參與計息用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_D" IS '日活用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_E" IS '月活用戶數量';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."CU_COUNT_I" IS '新增實名人數';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."DATETIME" IS '添加時間';
COMMENT ON COLUMN "TONGBAO"."T_HISTORY"."DATEYMD" IS '添加日期';
- 通寶+后臺
- 新數據字典
- 測試數據庫配置
- 核心賬戶改造需求文檔
- 物業霸王餐
- 物業霸王餐上線流程
- 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手機號查詢信息接口