20.12.04 通寶+入口限制 · 通寶+平臺

create sequence seq_purpose_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_PURPOSE" ("ID" CHAR(10 BYTE) NOT NULL ENABLE, "LINKTEL" VARCHAR2(15 BYTE), "NAME" VARCHAR2(20 BYTE), "CONTENT" VARCHAR2(2000 BYTE), "ADDTIME" VARCHAR2(20 BYTE), "TITLE" VARCHAR2(200 BYTE), "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_PURPOSE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."LINKTEL" IS '手機號'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."NAME" IS '名字'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."TITLE" IS '標題'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."CONTENT" IS '內容'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."ADDTIME" IS '時間'; COMMENT ON COLUMN "TONGBAO"."T_PURPOSE"."CUSTOMID" IS '申請人會員id'; create sequence seq_user_apply_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_USER_APPLY" ( "ID" CHAR(10 BYTE) NOT NULL ENABLE, "PROPOSER_LINKTEL" VARCHAR2(15 BYTE), "PROPOSER_CUSTOMID" CHAR(8 BYTE), "PROPOSER_NAME" VARCHAR2(200 BYTE), "UP_CUSTOMID" CHAR(8 BYTE), "UP_NAME" VARCHAR2(200 BYTE), "STATUS" VARCHAR2(20 BYTE), "TYPE" VARCHAR2(20 BYTE), "ADDTIME" VARCHAR2(20 BYTE), "ENDTIME" VARCHAR2(20 BYTE), "UP_LINKTEL" VARCHAR2(20 BYTE), "PAY_STATUS" VARCHAR2(20 BYTE) DEFAULT 2 ) 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_USER_APPLY"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."PROPOSER_LINKTEL" IS '申請人手機號'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."PROPOSER_CUSTOMID" IS '申請人會員id'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."PROPOSER_NAME" IS '申請人姓名'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."UP_CUSTOMID" IS '老用戶得會員id'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."UP_NAME" IS '老用戶用戶姓名'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."STATUS" IS '0是提交申請，1是審批通過，2審核不通過，3是撤銷'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."TYPE" IS ' 1是常規申請，2是快速申請，3是老用戶分享'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."ADDTIME" IS '申請得時間'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."ENDTIME" IS '最后審核時間'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."UP_LINKTEL" IS '老用戶的手機號'; COMMENT ON COLUMN "TONGBAO"."T_USER_APPLY"."PAY_STATUS" IS '1:是,2,否';