-
Notifications
You must be signed in to change notification settings - Fork 7
表结构
CoderDream edited this page Apr 19, 2022
·
1 revision
-- ----------------------------
-- Table structure for pdm_partmaster
-- ----------------------------
DROP TABLE IF EXISTS "pdmsaas"."pdm_partmaster";
CREATE TABLE "pdmsaas"."pdm_partmaster" (
"id" int8 NOT NULL,
"createtime" timestamp(6),
"creator" varchar(128) COLLATE "pg_catalog"."default",
"hibernateversion" int4,
"lastupdatetime" timestamp(6),
"modifier" varchar(128) COLLATE "pg_catalog"."default",
"rdmdeleteflag" int4,
"rdmextensiontype" varchar(255) COLLATE "pg_catalog"."default",
"rdmversion" int4,
"_tenanttype" varchar(255) COLLATE "pg_catalog"."default",
"_tenantid" int8,
"datasort" int4,
"_defaultuomtype" varchar(255) COLLATE "pg_catalog"."default",
"_defaultuomid" int8,
"enditem" int4,
"_foldertype" varchar(255) COLLATE "pg_catalog"."default",
"_folderid" int8,
"generictype" varchar(50) COLLATE "pg_catalog"."default",
"hidepartinstructure" int8,
"partnumber" varchar(500) COLLATE "pg_catalog"."default",
"phantom" int4
)
;
-- ----------------------------
-- Indexes structure for table pdm_partmaster
-- ----------------------------
CREATE INDEX "index_b17c564df9cdc2d3b987ef9895adc06555a71701" ON "pdmsaas"."pdm_partmaster" USING btree (
"_defaultuomid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_bcbfeaacb2e091ca88faac258054624f204b6c02" ON "pdmsaas"."pdm_partmaster" USING btree (
"_folderid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_cb133dd5b57ddb05d2849a47fe9c201f7428897d" ON "pdmsaas"."pdm_partmaster" USING btree (
"lastupdatetime" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversionmaster_partnumber_idx" ON "pdmsaas"."pdm_partmaster" USING btree (
"partnumber" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
-- Primary Key structure for table pdm_partmaster
-- ----------------------------
ALTER TABLE "pdmsaas"."pdm_partmaster" ADD CONSTRAINT "pdm_partmaster_pkey" PRIMARY KEY ("id");
-- ----------------------------
-- Table structure for pdm_part
-- ----------------------------
DROP TABLE IF EXISTS "pdmsaas"."pdm_part";
CREATE TABLE "pdmsaas"."pdm_part" (
"id" int8 NOT NULL,
"createtime" timestamp(6),
"creator" varchar(128) COLLATE "pg_catalog"."default",
"hibernateversion" int4,
"lastupdatetime" timestamp(6),
"modifier" varchar(128) COLLATE "pg_catalog"."default",
"rdmdeleteflag" int4,
"rdmextensiontype" varchar(255) COLLATE "pg_catalog"."default",
"rdmversion" int4,
"_tenanttype" varchar(255) COLLATE "pg_catalog"."default",
"_tenantid" int8,
"description" varchar(1024) COLLATE "pg_catalog"."default",
"kiaguid" varchar(50) COLLATE "pg_catalog"."default",
"name" varchar(500) COLLATE "pg_catalog"."default",
"securitylevel" varchar(50) COLLATE "pg_catalog"."default",
"_branchtype" varchar(255) COLLATE "pg_catalog"."default",
"_branchid" int8,
"iteration" int4,
"latest" int4,
"latestiteration" int4 NOT NULL,
"latestversion" int4 NOT NULL,
"_mastertype" varchar(255) COLLATE "pg_catalog"."default",
"_masterid" int8,
"version" varchar(100) COLLATE "pg_catalog"."default",
"versioncode" int4,
"workingcopy" int4,
"workingstate" varchar(255) COLLATE "pg_catalog"."default",
"_atgatestateprecision" int4,
"_atgatestatevalue" numeric(70,30),
"businessversion" varchar(20) COLLATE "pg_catalog"."default",
"checkoutinfoid" int8,
"clsattrs" json,
"codate" timestamp(6),
"couserid" varchar(100) COLLATE "pg_catalog"."default",
"descriptionen" varchar(2000) COLLATE "pg_catalog"."default",
"iopstateinteropinfo" varchar(100) COLLATE "pg_catalog"."default",
"iterationnote" varchar(4000) COLLATE "pg_catalog"."default",
"_lifecyclestatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecyclestateid" int8,
"_lifecycletemplatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecycletemplateid" int8,
"lockflag" int4,
"notelock" varchar(2000) COLLATE "pg_catalog"."default",
"oneoffversion" int4,
"_organizationtype" varchar(255) COLLATE "pg_catalog"."default",
"_organizationid" int8,
"ownerid" varchar(600) COLLATE "pg_catalog"."default",
"_parttemplatetype" varchar(255) COLLATE "pg_catalog"."default",
"_parttemplateid" int8,
"_parttemplateattrsettype" varchar(255) COLLATE "pg_catalog"."default",
"_parttemplateattrsetid" int8,
"parttemplatekey" varchar(500) COLLATE "pg_catalog"."default",
"parttypekey" varchar(50) COLLATE "pg_catalog"."default",
"phase" varchar(100) COLLATE "pg_catalog"."default",
"projectid" varchar(50) COLLATE "pg_catalog"."default",
"source" varchar(90) COLLATE "pg_catalog"."default",
"sourceiterationid" int8,
"stateinteropinfo" varchar(100) COLLATE "pg_catalog"."default",
"variation1" varchar(100) COLLATE "pg_catalog"."default",
"variation2" varchar(100) COLLATE "pg_catalog"."default",
"versionsort" varchar(600) COLLATE "pg_catalog"."default",
"_viewtype" varchar(255) COLLATE "pg_catalog"."default",
"_viewid" int8,
"viewisnull" int4,
"viewname" varchar(200) COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Indexes structure for table pdm_part
-- ----------------------------
CREATE INDEX "index_03e7fe2b87a87cbb8013db736e79048b0fdb34ec" ON "pdmsaas"."pdm_part" USING btree (
"_lifecyclestateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_19667c4a3b2b93ee9f9ef5562b5301090ea76911" ON "pdmsaas"."pdm_part" USING btree (
"_lifecycletemplateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_208b96a90872941cdcb35f6dc1d227fd14dc1088" ON "pdmsaas"."pdm_part" USING btree (
"lastupdatetime" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
CREATE INDEX "index_2b71242b213faa9b801c601e85abf048defa3188" ON "pdmsaas"."pdm_part" USING btree (
"_parttemplateattrsetid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_7b30ee0db979fe47af2c6f81d18f545c23b39482" ON "pdmsaas"."pdm_part" USING btree (
"_masterid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_ab1664ad09e739326dbc5eeca47df8be46282be2" ON "pdmsaas"."pdm_part" USING btree (
"_viewid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_ad6f2a8ad69bb26b382ed6cc6b519ed6c9ca1419" ON "pdmsaas"."pdm_part" USING btree (
"_parttemplateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_eaa4e81ff2914c03097178736993d426e24f84a6" ON "pdmsaas"."pdm_part" USING btree (
"_branchid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_f7170ebc246e5de0c3fe6cf1c1aeaf58438602b4" ON "pdmsaas"."pdm_part" USING btree (
"_organizationid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_latest_idx" ON "pdmsaas"."pdm_part" USING btree (
"latest" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_parttemplateid_idx" ON "pdmsaas"."pdm_part" USING btree (
"_parttemplateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_rdmextensiontype_idx" ON "pdmsaas"."pdm_part" USING btree (
"rdmextensiontype" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_source_idx" ON "pdmsaas"."pdm_part" USING btree (
"source" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_tenantid_idx" ON "pdmsaas"."pdm_part" USING btree (
"_tenantid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_partversion_version_idx" ON "pdmsaas"."pdm_part" USING btree (
"version" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
-- Uniques structure for table pdm_part
-- ----------------------------
ALTER TABLE "pdmsaas"."pdm_part" ADD CONSTRAINT "index_0bf910cddde681c07b224689fa73f7b5eb68e9a9" UNIQUE ("_masterid", "versioncode", "iteration", "workingcopy", "latest");
-- ----------------------------
-- Primary Key structure for table pdm_part
-- ----------------------------
ALTER TABLE "pdmsaas"."pdm_part" ADD CONSTRAINT "pdm_part_pkey" PRIMARY KEY ("id");
-- ----------------------------
-- Table structure for pdm_bom
-- ----------------------------
DROP TABLE IF EXISTS "pdmsaas"."pdm_bom";
CREATE TABLE "pdmsaas"."pdm_bom" (
"id" int8 NOT NULL,
"createtime" timestamp(6),
"creator" varchar(128) COLLATE "pg_catalog"."default",
"hibernateversion" int4,
"lastupdatetime" timestamp(6),
"modifier" varchar(128) COLLATE "pg_catalog"."default",
"rdmdeleteflag" int4,
"rdmextensiontype" varchar(255) COLLATE "pg_catalog"."default",
"rdmversion" int4,
"_tenanttype" varchar(255) COLLATE "pg_catalog"."default",
"_tenantid" int8,
"description" varchar(1024) COLLATE "pg_catalog"."default",
"kiaguid" varchar(50) COLLATE "pg_catalog"."default",
"name" varchar(500) COLLATE "pg_catalog"."default",
"securitylevel" varchar(50) COLLATE "pg_catalog"."default",
"allocationtype" varchar(2000) COLLATE "pg_catalog"."default",
"_childpartmastertype" varchar(255) COLLATE "pg_catalog"."default",
"_childpartmasterid" int8,
"clsattrs" json,
"componentid" varchar(1200) COLLATE "pg_catalog"."default",
"_defaultuomtype" varchar(255) COLLATE "pg_catalog"."default",
"_defaultuomid" int8,
"findnumber" varchar(120) COLLATE "pg_catalog"."default",
"_foldertype" varchar(255) COLLATE "pg_catalog"."default",
"_folderid" int8,
"inclusionoption" varchar(1200) COLLATE "pg_catalog"."default",
"_lifecyclestatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecyclestateid" int8,
"_lifecycletemplatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecycletemplateid" int8,
"linenumberisnull" int8,
"_parentparttype" varchar(255) COLLATE "pg_catalog"."default",
"_parentpartid" int8,
"_quantityprecision" int4,
"_quantityvalue" numeric(70,30),
"quantityrelated" varchar(500) COLLATE "pg_catalog"."default",
"sequencenumber" int4
)
;
-- ----------------------------
-- Indexes structure for table pdm_bom
-- ----------------------------
CREATE INDEX "index_02643558db719a870c6d387c49eeb3f9c6329d58" ON "pdmsaas"."pdm_bom" USING btree (
"_defaultuomid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_23fe5f107572e084df0562a4365391b13fd6a23e" ON "pdmsaas"."pdm_bom" USING btree (
"_lifecycletemplateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_273e736e1fcf80279813b513f125a1347f28b9a5" ON "pdmsaas"."pdm_bom" USING btree (
"_folderid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_28e72a5ff7cabc3644b9d36f8011822eea36dbeb" ON "pdmsaas"."pdm_bom" USING btree (
"_childpartmasterid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_2b32428af6b407c72d4a6995d24a0185725f7be2" ON "pdmsaas"."pdm_bom" USING btree (
"_parentpartid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_edcef3b0b20e88e3c0e18c19bdf74db60faef285" ON "pdmsaas"."pdm_bom" USING btree (
"lastupdatetime" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
CREATE INDEX "index_f9be5efb3ebb2eace4b645193b815010b792c352" ON "pdmsaas"."pdm_bom" USING btree (
"_lifecyclestateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_bom_rdmextensiontype_index" ON "pdmsaas"."pdm_bom" USING btree (
"rdmextensiontype" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "pdm_bom_sequencenumber_idx" ON "pdmsaas"."pdm_bom" USING btree (
"sequencenumber" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-- ----------------------------
-- Primary Key structure for table pdm_bom
-- ----------------------------
ALTER TABLE "pdmsaas"."pdm_bom" ADD CONSTRAINT "pdm_bom_pkey" PRIMARY KEY ("id");
-- ----------------------------
-- Table structure for pdm_bomsubstitutelink
-- ----------------------------
DROP TABLE IF EXISTS "pdmsaas"."pdm_bomsubstitutelink";
CREATE TABLE "pdmsaas"."pdm_bomsubstitutelink" (
"id" int8 NOT NULL,
"createtime" timestamp(6),
"creator" varchar(128) COLLATE "pg_catalog"."default",
"hibernateversion" int4,
"lastupdatetime" timestamp(6),
"modifier" varchar(128) COLLATE "pg_catalog"."default",
"rdmdeleteflag" int4,
"rdmextensiontype" varchar(255) COLLATE "pg_catalog"."default",
"rdmversion" int4,
"_tenanttype" varchar(255) COLLATE "pg_catalog"."default",
"_tenantid" int8,
"alternatedesignatorcode" varchar(50) COLLATE "pg_catalog"."default",
"_bomtype" varchar(255) COLLATE "pg_catalog"."default",
"_bomid" int8,
"clsattrs" json,
"_defaultinvorgtype" varchar(255) COLLATE "pg_catalog"."default",
"_defaultinvorgid" int8,
"_foldertype" varchar(255) COLLATE "pg_catalog"."default",
"_folderid" int8,
"_lifecyclestatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecyclestateid" int8,
"_lifecycletemplatetype" varchar(255) COLLATE "pg_catalog"."default",
"_lifecycletemplateid" int8,
"_quantityprecision" int4,
"_quantityvalue" numeric(70,30),
"_substitutepartmastertype" varchar(255) COLLATE "pg_catalog"."default",
"_substitutepartmasterid" int8,
"substitutetype" varchar(30) COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Indexes structure for table pdm_bomsubstitutelink
-- ----------------------------
CREATE INDEX "index_011e02c3c4df638cd75aac01c2b75b90ab85a280" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_folderid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_1e69227b21d3416f487246113354e8a1e81f636b" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"lastupdatetime" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
CREATE INDEX "index_47a0d6809d641378a564fda1a4871aec1ba1db90" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_lifecyclestateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_91e65d4e54a27a23d05bd96b81954127fe2b98a6" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_substitutepartmasterid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_992e3d7bdcf92c6bdb46166ac317c6592308b958" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_defaultinvorgid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_c355544a55a57f1099f7999b6007af5e524abbdb" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_lifecycletemplateid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "index_e6633911912b1e9cc75a8873d1142ebefb90ba62" ON "pdmsaas"."pdm_bomsubstitutelink" USING btree (
"_bomid" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-- ----------------------------
-- Primary Key structure for table pdm_bomsubstitutelink
-- ----------------------------
ALTER TABLE "pdmsaas"."pdm_bomsubstitutelink" ADD CONSTRAINT "pdm_bomsubstitutelink_pkey" PRIMARY KEY ("id");