uapbd/mate_change/script/物料变更创表脚本.sql

CREATE TABLE "axj_mate_change_h" (
  "def20" varchar(101) COLLATE "pg_catalog"."default",
  "def19" varchar(101) COLLATE "pg_catalog"."default",
  "def18" varchar(101) COLLATE "pg_catalog"."default",
  "def17" varchar(101) COLLATE "pg_catalog"."default",
  "def16" varchar(101) COLLATE "pg_catalog"."default",
  "def15" varchar(101) COLLATE "pg_catalog"."default",
  "def14" varchar(101) COLLATE "pg_catalog"."default",
  "def13" varchar(101) COLLATE "pg_catalog"."default",
  "def12" varchar(101) COLLATE "pg_catalog"."default",
  "def11" varchar(101) COLLATE "pg_catalog"."default",
  "def10" varchar(101) COLLATE "pg_catalog"."default",
  "def9" varchar(101) COLLATE "pg_catalog"."default",
  "def8" varchar(101) COLLATE "pg_catalog"."default",
  "def7" varchar(101) COLLATE "pg_catalog"."default",
  "def6" varchar(101) COLLATE "pg_catalog"."default",
  "def5" varchar(101) COLLATE "pg_catalog"."default",
  "def4" varchar(101) COLLATE "pg_catalog"."default",
  "def3" varchar(101) COLLATE "pg_catalog"."default",
  "def2" varchar(101) COLLATE "pg_catalog"."default",
  "def1" varchar(101) COLLATE "pg_catalog"."default",
  "srcbilltype" varchar(50) COLLATE "pg_catalog"."default",
  "srcbillid" varchar(50) COLLATE "pg_catalog"."default",
  "busitype" varchar(20) COLLATE "pg_catalog"."default",
  "billmaker" varchar(20) COLLATE "pg_catalog"."default",
  "emendenum" int4,
  "approvestatus" int2,
  "approvedate" char(19) COLLATE "pg_catalog"."default",
  "approver" varchar(20) COLLATE "pg_catalog"."default",
  "approvenote" varchar(50) COLLATE "pg_catalog"."default",
  "transtypepk" varchar(20) COLLATE "pg_catalog"."default",
  "transtype" varchar(50) COLLATE "pg_catalog"."default",
  "billtype" varchar(50) COLLATE "pg_catalog"."default",
  "billversionpk" varchar(50) COLLATE "pg_catalog"."default",
  "lastmaketime" char(19) COLLATE "pg_catalog"."default",
  "maketime" char(19) COLLATE "pg_catalog"."default",
  "pk_org_v" varchar(20) COLLATE "pg_catalog"."default",
  "modifiedtime" char(19) COLLATE "pg_catalog"."default",
  "modifier" varchar(20) COLLATE "pg_catalog"."default",
  "creationtime" char(19) COLLATE "pg_catalog"."default",
  "creator" varchar(20) COLLATE "pg_catalog"."default",
  "name" varchar(50) COLLATE "pg_catalog"."default",
  "code" varchar(50) COLLATE "pg_catalog"."default",
  "pk_group" varchar(20) COLLATE "pg_catalog"."default",
  "pk_org" varchar(20) COLLATE "pg_catalog"."default",
  "pk_mate_change_h" char(20) COLLATE "pg_catalog"."default" NOT NULL,
  "ts" char(19) COLLATE "pg_catalog"."default" DEFAULT to_char(CURRENT_TIMESTAMP, 'yyyy-mm-dd hh24:mi:ss'::text),
  "dr" int2,
  CONSTRAINT "axj_mate_change_h_pk" PRIMARY KEY ("pk_mate_change_h")
)
;



CREATE TABLE "axj_mate_change_b" (
  "def50" varchar(101) COLLATE "pg_catalog"."default",
  "def49" varchar(101) COLLATE "pg_catalog"."default",
  "def48" varchar(101) COLLATE "pg_catalog"."default",
  "def47" varchar(101) COLLATE "pg_catalog"."default",
  "def46" varchar(101) COLLATE "pg_catalog"."default",
  "def45" varchar(101) COLLATE "pg_catalog"."default",
  "def44" varchar(101) COLLATE "pg_catalog"."default",
  "def43" varchar(101) COLLATE "pg_catalog"."default",
  "def42" varchar(101) COLLATE "pg_catalog"."default",
  "def41" varchar(101) COLLATE "pg_catalog"."default",
  "def40" varchar(101) COLLATE "pg_catalog"."default",
  "def39" varchar(101) COLLATE "pg_catalog"."default",
  "def38" varchar(101) COLLATE "pg_catalog"."default",
  "def37" varchar(101) COLLATE "pg_catalog"."default",
  "def36" varchar(101) COLLATE "pg_catalog"."default",
  "def35" varchar(101) COLLATE "pg_catalog"."default",
  "def34" varchar(101) COLLATE "pg_catalog"."default",
  "def33" varchar(101) COLLATE "pg_catalog"."default",
  "def32" varchar(101) COLLATE "pg_catalog"."default",
  "def31" varchar(101) COLLATE "pg_catalog"."default",
  "def30" varchar(101) COLLATE "pg_catalog"."default",
  "def29" varchar(101) COLLATE "pg_catalog"."default",
  "def28" varchar(101) COLLATE "pg_catalog"."default",
  "def27" varchar(101) COLLATE "pg_catalog"."default",
  "def26" varchar(101) COLLATE "pg_catalog"."default",
  "def25" varchar(101) COLLATE "pg_catalog"."default",
  "def24" varchar(101) COLLATE "pg_catalog"."default",
  "def23" varchar(101) COLLATE "pg_catalog"."default",
  "def22" varchar(101) COLLATE "pg_catalog"."default",
  "def21" varchar(101) COLLATE "pg_catalog"."default",
  "def20" varchar(101) COLLATE "pg_catalog"."default",
  "def19" varchar(101) COLLATE "pg_catalog"."default",
  "def18" varchar(101) COLLATE "pg_catalog"."default",
  "def17" varchar(101) COLLATE "pg_catalog"."default",
  "def16" varchar(101) COLLATE "pg_catalog"."default",
  "def15" varchar(101) COLLATE "pg_catalog"."default",
  "def14" varchar(101) COLLATE "pg_catalog"."default",
  "def13" varchar(101) COLLATE "pg_catalog"."default",
  "def12" varchar(101) COLLATE "pg_catalog"."default",
  "def11" varchar(101) COLLATE "pg_catalog"."default",
  "def10" varchar(101) COLLATE "pg_catalog"."default",
  "def9" varchar(101) COLLATE "pg_catalog"."default",
  "def8" varchar(101) COLLATE "pg_catalog"."default",
  "def7" varchar(101) COLLATE "pg_catalog"."default",
  "def6" varchar(101) COLLATE "pg_catalog"."default",
  "def5" varchar(101) COLLATE "pg_catalog"."default",
  "def4" varchar(101) COLLATE "pg_catalog"."default",
  "def3" varchar(101) COLLATE "pg_catalog"."default",
  "def2" varchar(101) COLLATE "pg_catalog"."default",
  "def1" varchar(101) COLLATE "pg_catalog"."default",
  "enablestatereason" varchar(50) COLLATE "pg_catalog"."default",
  "enablestate" varchar(50) COLLATE "pg_catalog"."default",
  "pk_material" varchar(20) COLLATE "pg_catalog"."default",
  "pk_mattaxes" varchar(20) COLLATE "pg_catalog"."default",
  "pk_brand" varchar(20) COLLATE "pg_catalog"."default",
  "scalefactor" varchar(50) COLLATE "pg_catalog"."default",
  "pk_measdoc" varchar(20) COLLATE "pg_catalog"."default",
  "materialtype" varchar(50) COLLATE "pg_catalog"."default",
  "materialspec" varchar(50) COLLATE "pg_catalog"."default",
  "name" varchar(50) COLLATE "pg_catalog"."default",
  "srcrowno" varchar(50) COLLATE "pg_catalog"."default",
  "rowno" varchar(50) COLLATE "pg_catalog"."default",
  "pk_mate_change_b" char(20) COLLATE "pg_catalog"."default" NOT NULL,
  "pk_mate_change_h" char(20) COLLATE "pg_catalog"."default" NOT NULL,
  "ts" char(19) COLLATE "pg_catalog"."default" DEFAULT to_char(CURRENT_TIMESTAMP, 'yyyy-mm-dd hh24:mi:ss'::text),
  "dr" int2,
  CONSTRAINT "axj_mate_change_b_pk" PRIMARY KEY ("pk_mate_change_b")
)
;



CREATE INDEX "i_axj_mate_change_b_1" ON "axj_mate_change_b" USING btree (
  "pk_mate_change_h" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST
);