CREATE TABLE "axj_mate_change_hi" ( "code" varchar(40) COLLATE "pg_catalog"."default" NOT NULL, "creationtime" char(19) COLLATE "pg_catalog"."default", "creator" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "dataoriginflag" int2 DEFAULT 0, "def1" varchar(101) COLLATE "pg_catalog"."default", "def10" varchar(101) COLLATE "pg_catalog"."default", "def11" varchar(101) COLLATE "pg_catalog"."default", "def12" varchar(101) COLLATE "pg_catalog"."default", "def13" varchar(101) COLLATE "pg_catalog"."default", "def14" varchar(101) COLLATE "pg_catalog"."default", "def15" varchar(101) COLLATE "pg_catalog"."default", "def16" varchar(101) COLLATE "pg_catalog"."default", "def17" varchar(101) COLLATE "pg_catalog"."default", "def18" varchar(101) COLLATE "pg_catalog"."default", "def19" varchar(101) COLLATE "pg_catalog"."default", "def2" varchar(101) COLLATE "pg_catalog"."default", "def20" varchar(101) COLLATE "pg_catalog"."default", "def21" varchar(101) COLLATE "pg_catalog"."default", "def22" varchar(101) COLLATE "pg_catalog"."default", "def23" varchar(101) COLLATE "pg_catalog"."default", "def24" varchar(101) COLLATE "pg_catalog"."default", "def25" varchar(101) COLLATE "pg_catalog"."default", "def26" varchar(101) COLLATE "pg_catalog"."default", "def27" varchar(101) COLLATE "pg_catalog"."default", "def28" varchar(101) COLLATE "pg_catalog"."default", "def29" varchar(101) COLLATE "pg_catalog"."default", "def3" varchar(101) COLLATE "pg_catalog"."default", "def30" varchar(101) COLLATE "pg_catalog"."default", "def31" varchar(101) COLLATE "pg_catalog"."default", "def32" varchar(101) COLLATE "pg_catalog"."default", "def33" varchar(101) COLLATE "pg_catalog"."default", "def34" varchar(101) COLLATE "pg_catalog"."default", "def35" varchar(101) COLLATE "pg_catalog"."default", "def36" varchar(101) COLLATE "pg_catalog"."default", "def37" varchar(101) COLLATE "pg_catalog"."default", "def38" varchar(101) COLLATE "pg_catalog"."default", "def39" varchar(101) COLLATE "pg_catalog"."default", "def4" varchar(101) COLLATE "pg_catalog"."default", "def40" varchar(101) COLLATE "pg_catalog"."default", "def41" varchar(101) COLLATE "pg_catalog"."default", "def42" varchar(101) COLLATE "pg_catalog"."default", "def43" varchar(101) COLLATE "pg_catalog"."default", "def44" varchar(101) COLLATE "pg_catalog"."default", "def45" varchar(101) COLLATE "pg_catalog"."default", "def46" varchar(101) COLLATE "pg_catalog"."default", "def47" varchar(101) COLLATE "pg_catalog"."default", "def48" varchar(101) COLLATE "pg_catalog"."default", "def49" varchar(101) COLLATE "pg_catalog"."default", "def5" varchar(101) COLLATE "pg_catalog"."default", "def50" varchar(101) COLLATE "pg_catalog"."default", "def6" varchar(101) COLLATE "pg_catalog"."default", "def7" varchar(101) COLLATE "pg_catalog"."default", "def8" varchar(101) COLLATE "pg_catalog"."default", "def9" varchar(101) COLLATE "pg_catalog"."default", "deletestate" int2, "delperson" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "deltime" char(19) COLLATE "pg_catalog"."default", "discountflag" char(1) COLLATE "pg_catalog"."default" DEFAULT 'N'::bpchar, "dr" int2 DEFAULT 0, "electronicsale" char(1) COLLATE "pg_catalog"."default", "ematerialspec" varchar(400) COLLATE "pg_catalog"."default", "enablestate" int4 NOT NULL DEFAULT 2, "ename" varchar(200) COLLATE "pg_catalog"."default", "featureclass" varchar(20) COLLATE "pg_catalog"."default", "fee" char(1) COLLATE "pg_catalog"."default" DEFAULT 'N'::bpchar, "goodsprtname" varchar(200) COLLATE "pg_catalog"."default", "graphid" varchar(50) COLLATE "pg_catalog"."default", "intolerance" numeric(20,4) NOT NULL DEFAULT 0, "iselectrans" char(1) COLLATE "pg_catalog"."default", "isfeature" char(1) COLLATE "pg_catalog"."default", "ishproitems" char(1) COLLATE "pg_catalog"."default", "latest" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'N'::bpchar, "matchmode" int4, "materialbarcode" varchar(30) COLLATE "pg_catalog"."default", "materialmgt" int2, "materialmnecode" varchar(50) COLLATE "pg_catalog"."default", "materialshortname" varchar(300) COLLATE "pg_catalog"."default", "materialspec" varchar(400) COLLATE "pg_catalog"."default", "materialtype" varchar(400) COLLATE "pg_catalog"."default", "memo" varchar(150) COLLATE "pg_catalog"."default", "modifiedtime" char(19) COLLATE "pg_catalog"."default", "modifier" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "name" varchar(300) COLLATE "pg_catalog"."default" NOT NULL, "name2" varchar(300) COLLATE "pg_catalog"."default", "name3" varchar(300) COLLATE "pg_catalog"."default", "name4" varchar(300) COLLATE "pg_catalog"."default", "name5" varchar(300) COLLATE "pg_catalog"."default", "name6" varchar(300) COLLATE "pg_catalog"."default", "outcloselowerlimit" numeric(20,4) NOT NULL DEFAULT 0, "outtolerance" numeric(20,4) NOT NULL DEFAULT 0, "pk_brand" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_goodscode" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_group" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_marasstframe" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_marbasclass" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_material" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_material_pf" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_mattaxes" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT '~'::character varying, "pk_measdoc" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_org" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_prodline" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_source" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "pk_taxitems" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "prodarea" varchar(20) COLLATE "pg_catalog"."default" DEFAULT '~'::character varying, "productfamily" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'N'::bpchar, "prolifeperiod" int2, "retail" char(1) COLLATE "pg_catalog"."default" DEFAULT 'N'::bpchar, "setpartsflag" char(1) COLLATE "pg_catalog"."default" DEFAULT 'N'::bpchar, "storeunitnum" numeric(20,8), "ts" char(19) COLLATE "pg_catalog"."default" DEFAULT to_char(now(), 'yyyy-mm-dd hh24:mi:ss'::text), "unitheight" varchar(20) COLLATE "pg_catalog"."default", "unitlength" varchar(20) COLLATE "pg_catalog"."default", "unitvolume" numeric(20,8) DEFAULT 0, "unitweight" numeric(20,8) DEFAULT 0, "unitwidth" varchar(20) COLLATE "pg_catalog"."default", "version" int4 NOT NULL DEFAULT 1, "pk_mate_change_hi" char(20) COLLATE "pg_catalog"."default" NOT NULL, "pk_mate_change_h" varchar(255) COLLATE "pg_catalog"."default", "pk_mate_change_b" varchar(255) COLLATE "pg_catalog"."default", CONSTRAINT "bd_material_copy2_pkey" PRIMARY KEY ("pk_mate_change_hi") ) ; CREATE INDEX "i_material_1_copy2" ON "axj_mate_change_hi" USING btree ( "pk_org" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST, "pk_group" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST ); CREATE INDEX "i_material_2_copy2" ON "axj_mate_change_hi" USING btree ( "pk_source" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); CREATE INDEX "i_material_3_copy2" ON "axj_mate_change_hi" USING btree ( "pk_marbasclass" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST ); CREATE INDEX "i_material_4_copy2" ON "axj_mate_change_hi" USING btree ( "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); CREATE INDEX "i_material_5_copy2" ON "axj_mate_change_hi" USING btree ( "name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); CREATE INDEX "i_material_6_copy2" ON "axj_mate_change_hi" USING btree ( "materialmnecode" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); CREATE INDEX "i_material_ts_copy2" ON "axj_mate_change_hi" USING btree ( "ts" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST );