create sequence seq_mns_error_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_MNS_ERROR" ( "ID" VARCHAR2(20 BYTE), "TYPE" VARCHAR2(20 BYTE), "STATUS" VARCHAR2(20 BYTE), "JSON" VARCHAR2(4000 BYTE), "DATETIME" VARCHAR2(20 BYTE), "DATEYMD" VARCHAR2(20 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."TYPE" IS '类型1.生产,2.消费'; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."STATUS" IS '状态1,未处理,2已处理'; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."JSON" IS 'json数据'; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."DATETIME" IS '添加时间'; COMMENT ON COLUMN "TONGBAO"."T_MNS_ERROR"."DATEYMD" IS '添加日期';