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,否';