上線執行sql語句 · 通寶+平臺

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 '補貼';