#充值對賬表 create sequence seq_amount_checking_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TBTEST"."T_AMOUNT_CHECKING" ( "ID" NUMBER(12,0) NOT NULL ENABLE, "TB_NUM" NUMBER(10,0) DEFAULT 0, "ZF_NUM" NUMBER(10,0) DEFAULT 0, "OLD_NUM" NUMBER(10,0) DEFAULT 0, "TB_AMOUNT" NUMBER(12,0) DEFAULT 0, "ZF_AMOUNT" NUMBER(12,0) DEFAULT 0, "OLD_AMOUNT" NUMBER(12,0) DEFAULT 0, "STATUS" VARCHAR2(2 BYTE) DEFAULT 1, "TYPE" VARCHAR2(3 BYTE), "DATEYMD" VARCHAR2(21 BYTE), CONSTRAINT "T_AMOUNT_CHECKING_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 "TBTEST" 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 "TBTEST" ; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."ID" IS 'ID'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."TB_NUM" IS '通寶+條數'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."ZF_NUM" IS '支付結算中心條數'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."OLD_NUM" IS '老支付結算中心條數'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."TB_AMOUNT" IS '通寶+金額'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."ZF_AMOUNT" IS '支付結算中心金額'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."OLD_AMOUNT" IS '老支付結算中心金額'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."STATUS" IS '狀態:1:未比對,2:比對成功,3:比對失敗 '; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."TYPE" IS '1,大額支付,2:微信app支付,3:微信小程序支付,4.支付寶'; COMMENT ON COLUMN "TBTEST"."T_AMOUNT_CHECKING"."DATEYMD" IS '日期';