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 '添加日期';