uapbd/mate_change/script/物料变更物料历史表.sql

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
);