1. 账户明细表
去除空格 update t_accountdetails set num=trim(num);
2. 消费表
去除空格 update t_consume set num=trim(num);
3. 退款记录表
CREATE TABLE "TONGBAO"."T_CONSUME_BACK"
( "ID" CHAR(10 BYTE) NOT NULL ENABLE,
"CCNUM" VARCHAR2(50 BYTE),
"CNUM" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"TYPE" VARCHAR2(5 BYTE) DEFAULT 6 NOT NULL ENABLE,
"PAYTYPE" VARCHAR2(5 BYTE) NOT NULL ENABLE,
"AMOUNT" NUMBER(10,2),
"SCORE" NUMBER(10,2),
"RNUM" VARCHAR2(50 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"VERSIONS" VARCHAR2(1000 BYTE),
"ORDERNO" VARCHAR2(100 BYTE),
"NUM" VARCHAR2(50 BYTE),
CONSTRAINT "T_CONSUME_BACK_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_CONSUME_BACK"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."CCNUM" IS ' 消费流水号(子订单)';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."CNUM" IS '消费流水号(大订单)
';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."TYPE" IS '默认6:系统';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."PAYTYPE" IS '消费退款（621）退款积分（631）';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."AMOUNT" IS ' 退款本金';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."SCORE" IS '退款积分';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."RNUM" IS '影响充值订单号';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."DATETIME" IS '退款时间';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."VERSIONS" IS '版本号';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."ORDERNO" IS '外部订单号';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."NUM" IS '退款订单号';
4. 消费子订单表
CREATE TABLE "TONGBAO"."T_CONSUME_CHILD"
( "ID" CHAR(10 BYTE) NOT NULL ENABLE,
"CNUM" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"CCNUM" VARCHAR2(50 BYTE),
"TYPE" VARCHAR2(5 BYTE) DEFAULT 1,
"AMOUNT" NUMBER(10,2),
"SCORE" NUMBER(10,2),
"RNUM" VARCHAR2(50 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"VERSIONS" VARCHAR2(500 BYTE),
"REFUND_AMOUNT" NUMBER(10,2),
"REFUND_SCORE" NUMBER(10,2),
CONSTRAINT "T_CONSUME_CHILD_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_CONSUME_CHILD"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."CNUM" IS ' 消费流水号(大订单)';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."CCNUM" IS '消费流水号(小订单)';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."TYPE" IS ' 默认1:正常 2,退款';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."AMOUNT" IS '消费本金';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."SCORE" IS '消费积分';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."RNUM" IS '充值订单号
';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."DATETIME" IS ' 回退时间';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."VERSIONS" IS '版本号';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."REFUND_AMOUNT" IS '退款本金';
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_CHILD"."REFUND_SCORE" IS '退款积分';
5. 定存支取记录表(t_deposit_getback)
CREATE TABLE "TONGBAO"."T_DEPOSIT_GETBACK"
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"RNUM" VARCHAR2(50 BYTE),
"DEPOSIT_AMOUNT" NUMBER(10,2),
"AMOUNT" NUMBER(10,2),
"BROKERAGE" NUMBER(10,2),
"RATE" NUMBER(10,2),
"TYPE" VARCHAR2(5 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"RANUM" VARCHAR2(50 BYTE),
"RECOVERY" NUMBER(10,2),
CONSTRAINT "T_DEPOSIT_GETBACK_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_DEPOSIT_GETBACK"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."RNUM" IS '充值流水号';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."DEPOSIT_AMOUNT" IS '定存金额';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."AMOUNT" IS '实际取出金额';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."BROKERAGE" IS '手续费金额';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."RATE" IS '费率';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."TYPE" IS '类型1,提前支取,2.到期转入通宝+';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."DATETIME" IS '添加时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."RANUM" IS '赎回大订单';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_GETBACK"."RECOVERY" IS '商品回本';
5. 定存利率设置表(T_DEPOSIT_RUL)
CREATE TABLE "TONGBAO"."T_DEPOSIT_RULE"
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"LV" VARCHAR2(20 BYTE),
"RULE_NUM" VARCHAR2(20 BYTE),
"START_MONTH" VARCHAR2(20 BYTE),
"END_MONTH" VARCHAR2(20 BYTE),
"USERID" VARCHAR2(200 BYTE),
"USERNAME" VARCHAR2(20 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
CONSTRAINT "T_DEPOSIT_RULE_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_DEPOSIT_RULE"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."LV" IS '利率等级';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."RULE_NUM" IS '利率';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."START_MONTH" IS '开始时间:单位(月)';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."END_MONTH" IS '结束时间:单位(月)';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."USERID" IS '更改人ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."USERNAME" IS '更改人姓名';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_RULE"."DATETIME" IS '最后更改或添加时间';
6. 定存时间表
CREATE TABLE "TONGBAO"."T_DEPOSIT_TIME"
( "ID" VARCHAR2(20 BYTE),
"MIN_TIME" VARCHAR2(20 BYTE),
"MAX_TIME" VARCHAR2(20 BYTE),
"TYPE" VARCHAR2(20 BYTE),
"USERID" VARCHAR2(20 BYTE),
"USERNAME" VARCHAR2(200 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"RATE" VARCHAR2(20 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_DEPOSIT_TIME"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."MIN_TIME" IS '最小时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."MAX_TIME" IS '最大时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."TYPE" IS '类型:1霸王餐';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."USERID" IS '管理员ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."USERNAME" IS '管理员姓名';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."DATETIME" IS '修改时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_TIME"."RATE" IS '费率';
7.赠送表
CREATE TABLE "TONGBAO"."T_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),
CONSTRAINT "T_GIVE_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"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."RNUM" IS '充值单号';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."CUSTOMID" IS '会员ID';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."ACCOUNTID" IS '账户ID';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."SCORE" IS '赠送积分';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."TYPE" IS '默认6:系统';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."PAYTYPE" IS '积分补偿（611）、福利积分（612）、活动赠送（613）、充值活动赠送（614）、普通赠送（666）';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."DATETIME" IS '写入时间,时间戳';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."VERSIONS" IS '版本号';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."DATEYMD" IS '日期';
COMMENT ON COLUMN "TONGBAO"."T_GIVE"."BALANCE" IS '计息金额';
8.消费表
去除空格 update t_ransom set num=trim(num);
9.赎回回退
CREATE TABLE "TONGBAO"."T_RANSOM_BACK"
( "ID" CHAR(10 BYTE) NOT NULL ENABLE,
"RANUM" VARCHAR2(200 BYTE) NOT NULL ENABLE,
"RACNUM" VARCHAR2(200 BYTE),
"TYPE" VARCHAR2(5 BYTE) NOT NULL ENABLE,
"PAYTYPE" VARCHAR2(5 BYTE) NOT NULL ENABLE,
"AMOUNT" NUMBER(10,2) NOT NULL ENABLE,
"RNUM" VARCHAR2(200 BYTE),
"DATETIME" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"VERSIONS" VARCHAR2(200 BYTE),
"NUM" VARCHAR2(200 BYTE),
CONSTRAINT "T_RANSOM_BACK_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_RANSOM_BACK"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."RANUM" IS ' 赎回流水号(大订单)';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."RACNUM" IS '赎回流水号(小订单)';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."TYPE" IS '默认6:系统';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."PAYTYPE" IS '赎回回退（641）撤销（651）';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."AMOUNT" IS ' 回退本金
';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."RNUM" IS '影响充值订单';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."DATETIME" IS ' 回退时间';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."VERSIONS" IS '版本号';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_BACK"."NUM" IS '赎回回退流水号';
10.赎回子订单
CREATE TABLE "TONGBAO"."T_RANSOM_CHILD"
( "ID" CHAR(10 BYTE) NOT NULL ENABLE,
"RANUM" VARCHAR2(50 BYTE),
"RACNUM" VARCHAR2(50 BYTE),
"TYPE" VARCHAR2(5 BYTE),
"AMOUNT" NUMBER(10,2),
"RNUM" VARCHAR2(50 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"VERSIONS" VARCHAR2(1000 BYTE),
CONSTRAINT "T_RANSOM_CHILD_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_RANSOM_CHILD"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."RANUM" IS '赎回流水号(大订单)';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."RACNUM" IS '赎回流水号(小订单)';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."TYPE" IS '默认1:正常 2,退回 3 撤销';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."AMOUNT" IS '本金金额';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."RNUM" IS '充值订单号';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."DATETIME" IS '回退时间';
COMMENT ON COLUMN "TONGBAO"."T_RANSOM_CHILD"."VERSIONS" IS '版本号';
11.充值表
去除空格 update t_recharge set num=trim(num);
12.账户表
update t_amount set deposit_amount='0';
13 物业霸王餐商品表(t_deposit_shop)
CREATE TABLE "TONGBAO"."T_DEPOSIT_SHOP"
( "ID" CHAR(10 BYTE) NOT NULL ENABLE,
"SORDER" VARCHAR2(50 BYTE),
"DEPOSIT_AMOUNT" VARCHAR2(200 BYTE),
"DEPOSIT_SCORE" VARCHAR2(20 BYTE),
"DEPOSIT_DATE" VARCHAR2(200 BYTE),
"DEPOSIT_RULE" VARCHAR2(200 BYTE),
"DEPOSIT_DETAILS" VARCHAR2(200 BYTE),
"CUSTOMID" VARCHAR2(50 BYTE),
"DATETIME" VARCHAR2(200 BYTE),
"UPDATETIME" VARCHAR2(200 BYTE),
"DEPOSIT_TYPE" VARCHAR2(20 BYTE) DEFAULT 0,
"STATUS" VARCHAR2(20 BYTE) DEFAULT 0,
CONSTRAINT "T_DEPOSIT_SHOP_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_DEPOSIT_SHOP"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."SORDER" IS '商品订单';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_AMOUNT" IS '定存的金额';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_SCORE" IS '定存计息';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_DATE" IS '定存日期';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_RULE" IS '定存规则';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_DETAILS" IS '定存信息';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."CUSTOMID" IS '会员id';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DATETIME" IS '添加时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."UPDATETIME" IS '修改时间';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_TYPE" IS '支付方式 1 pos 2 大额 0未选择支付方式';
COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."STATUS" IS '0 创建中 1确定支付方式 2进行中 3支付完成 4失效 5 退款';
### **免单订单提交的订单信息**
createsequence seq_free_order_id
increment by1
startwith1
NOMAXVALUE
NOMINVALUE
NOCACHE;
CREATETABLE"TONGBAO"."T_FREE_ORDER"
(
"ID"CHAR(10 BYTE) NOTNULLENABLE,
"OUT_ORDER"VARCHAR2(100 BYTE) DEFAULT 0,
"FREE_NUM"VARCHAR2(50 BYTE) NOTNULLENABLE,
"AMOUNT"NUMBER(10,2) DEFAULT 0,
"TYPE"VARCHAR2(20 BYTE) NOTNULLENABLE,
"PANTERID"CHAR(8 BYTE) NOTNULLENABLE,
"CUSTOMID"CHAR(8 BYTE) NOTNULLENABLE,
"FREE_LV"VARCHAR2(100 BYTE),
"FREE_AMOUNT"NUMBER(10,2) DEFAULT 0,
"STATUS"VARCHAR2(20 BYTE) NOTNULLENABLE,
"ORDERTIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
"DATETIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
"UPDATETIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
CONSTRAINT"T_FREE_ORDER_PK"PRIMARYKEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536NEXT1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "JYCARD"ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536NEXT1048576 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_FREE_ORDER"."OUT_ORDER" IS '消费订单号';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_NUM" IS '免单订单号';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."AMOUNT" IS '消费金额';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."TYPE" IS '免单的类型 1: 自有资金 2: 备付金（至尊卡）3 通宝 4 通宝+';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."PANTERID" IS '商户id';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."CUSTOMID" IS '会员id';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_LV" IS '免单等级';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_AMOUNT" IS '免单金额';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."STATUS" IS '类型 1 申请免单，2免单成功 3，免单失败 ';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."ORDERTIME" IS '消费订单的时间';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."DATETIME" IS '下单的时间';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."UPDATETIME" IS '更新的时间';
### **消费表添加的字段**
alter table T_CONSUME add SUBSIDY VARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."SUBSIDY" IS '补贴';
alter table T_CONSUME add ORIGINAL_PRICEVARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."ORIGINAL_PRICE" IS '折扣前订单金额';
### **消费退款添加的字段**
alter table T_CONSUME_BACK add SUBSIDY VARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."SUBSIDY" 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手机号查询信息接口