From 5b6313f16f508882a0ea67716b7dbaa1c6967f04 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 30 Jun 2025 08:28:13 +0000
Subject: (대표님) 20250630 16시 - 유저 도메인별 라우터 분리와 보안성검토 대응
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations/0170_curved_chimera.sql | 1661 +++++++++++++++++++++++++++++++++
 1 file changed, 1661 insertions(+)
 create mode 100644 db/migrations/0170_curved_chimera.sql

(limited to 'db/migrations/0170_curved_chimera.sql')

diff --git a/db/migrations/0170_curved_chimera.sql b/db/migrations/0170_curved_chimera.sql
new file mode 100644
index 00000000..92eeaca2
--- /dev/null
+++ b/db/migrations/0170_curved_chimera.sql
@@ -0,0 +1,1661 @@
+CREATE SCHEMA "mdg";
+--> statement-breakpoint
+CREATE SCHEMA "soap";
+--> statement-breakpoint
+CREATE TABLE "menu_assignments" (
+	"id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "menu_assignments_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"menu_path" varchar(255) NOT NULL,
+	"menu_title" varchar(255) NOT NULL,
+	"menu_description" text,
+	"menu_group" varchar(100),
+	"section_title" varchar(255),
+	"domain" "user_domain" DEFAULT 'evcp' NOT NULL,
+	"manager1_id" integer,
+	"manager2_id" integer,
+	"is_active" boolean DEFAULT true NOT NULL,
+	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
+	"updated_at" timestamp with time zone DEFAULT now() NOT NULL,
+	CONSTRAINT "menu_assignments_menu_path_unique" UNIQUE("menu_path")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BP_HEADER" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_HEADER_unique" UNIQUE("BP_HEADER")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ADDRNO" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CONSNUMBER" varchar(10) NOT NULL,
+	"DATE_FROM" varchar(10) NOT NULL,
+	"SMTP_ADDR" varchar(241),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CONSNUMBER" varchar(10) NOT NULL,
+	"COUNTRY" varchar(10),
+	"DATE_FROM" varchar(10) NOT NULL,
+	"FAX_EXTENS" varchar(10),
+	"FAX_NUMBER" varchar(30),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CITY1" varchar(40),
+	"CITY2" varchar(40),
+	"COUNTRY" varchar(10),
+	"HOUSE_NUM1" varchar(10),
+	"LANGU" varchar(10),
+	"NAME1" varchar(40),
+	"NAME2" varchar(40),
+	"NAME3" varchar(40),
+	"NAME4" varchar(40),
+	"NATION" varchar(10) NOT NULL,
+	"POST_CODE1" varchar(10),
+	"POST_CODE2" varchar(10),
+	"PO_BOX" varchar(10),
+	"REGION" varchar(10),
+	"SORT1" varchar(20),
+	"SORT2" varchar(20),
+	"STREET" varchar(60),
+	"TAXJURCODE" varchar(15),
+	"TIME_ZONE" varchar(10),
+	"TITLE" varchar(10),
+	"TRANSPZONE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CONSNUMBER" varchar(10) NOT NULL,
+	"COUNTRY" varchar(10),
+	"DATE_FROM" varchar(10) NOT NULL,
+	"R3_USER" varchar(10),
+	"TEL_EXTENS" varchar(10),
+	"TEL_NUMBER" varchar(30),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CONSNUMBER" varchar(10) NOT NULL,
+	"DATE_FROM" varchar(10) NOT NULL,
+	"URI_ADDR" text,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ANRED" varchar(15),
+	"AUFSD" varchar(10),
+	"FAKSD" varchar(10),
+	"GFORM" varchar(10),
+	"JMJAH" varchar(10),
+	"JMZAH" varchar(10),
+	"J_1KFREPRE" varchar(10),
+	"J_1KFTBUS" varchar(30),
+	"J_1KFTIND" varchar(30),
+	"KATR1" varchar(10),
+	"KDKG1" varchar(10),
+	"KTOKD" varchar(10),
+	"KUNNR" varchar(10) NOT NULL,
+	"LIFNR" varchar(10),
+	"LIFSD" varchar(10),
+	"LOEVM" varchar(10),
+	"NIELS" varchar(10),
+	"NODEL" varchar(10),
+	"PUGRP" varchar(20),
+	"SPERR" varchar(10),
+	"SPRAS" varchar(10),
+	"STCD1" varchar(16),
+	"STCD2" varchar(11),
+	"STCD3" varchar(18),
+	"STCD4" varchar(18),
+	"STCEG" varchar(20),
+	"UMJAH" varchar(10),
+	"UWAER" varchar(10),
+	"VBUND" varchar(10),
+	"ZZAPPDT_C" varchar(10),
+	"ZZAPPTM_C" varchar(10),
+	"ZZAPPUS_C" varchar(12),
+	"ZZBA" varchar(10),
+	"ZZBRSCH_C" varchar(10),
+	"ZZCRMCD" varchar(20),
+	"ZZDOKAR_C" varchar(10),
+	"ZZDOKNR_C" varchar(25),
+	"ZZDOKTL_C" varchar(10),
+	"ZZDOKVR_C" varchar(10),
+	"ZZDUNS" varchar(11),
+	"ZZFTBU" varchar(10),
+	"ZZFTBUNM" varchar(40),
+	"ZZFTDT" varchar(10),
+	"ZZFTDTNM" varchar(40),
+	"ZZFTGT" varchar(10),
+	"ZZFTGTNM" varchar(40),
+	"ZZINBFLGC" varchar(10),
+	"ZZLAMDT_C" varchar(10),
+	"ZZLAMTM_C" varchar(10),
+	"ZZLAMUS_C" varchar(12),
+	"ZZORT01_C" varchar(35),
+	"ZZORT02_C" varchar(35),
+	"ZZREASON" varchar(10),
+	"ZZREGDT_C" varchar(10),
+	"ZZREGTM_C" varchar(10),
+	"ZZREGUS_C" varchar(12),
+	"ZZSTCDT_C" varchar(10),
+	"ZZSTRAS_C" varchar(35),
+	"ZZSUBSEQ_C" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"AKONT" varchar(10),
+	"BUKRS" varchar(10) NOT NULL,
+	"FDGRV" varchar(10),
+	"LOEVM" varchar(10),
+	"SPERR" varchar(10),
+	"ZAHLS" varchar(10),
+	"ZTERM" varchar(10),
+	"ZUAWA" varchar(10),
+	"ZWELS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"AUFSD" varchar(10),
+	"AWAHR" varchar(10),
+	"BZIRK" varchar(10),
+	"FAKSD" varchar(10),
+	"INCO1" varchar(10),
+	"INCO2" varchar(28),
+	"KALKS" varchar(10),
+	"KDGRP" varchar(10),
+	"KONDA" varchar(10),
+	"KTGRD" varchar(10),
+	"KURST" varchar(10),
+	"KZAZU" varchar(10),
+	"LIFSD" varchar(10),
+	"LOEVM" varchar(10),
+	"LPRIO" varchar(10),
+	"PLTYP" varchar(10),
+	"SPART" varchar(10) NOT NULL,
+	"VERSG" varchar(10),
+	"VKBUR" varchar(10),
+	"VKGRP" varchar(10),
+	"VKORG" varchar(10) NOT NULL,
+	"VSBED" varchar(10),
+	"VTWEG" varchar(10) NOT NULL,
+	"VWERK" varchar(10),
+	"WAERS" varchar(10),
+	"ZTERM" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEFPA" varchar(10),
+	"KUNN2" varchar(10),
+	"PARVW" varchar(10) NOT NULL,
+	"PARZA" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ALAND" varchar(10) NOT NULL,
+	"TATYP" varchar(10) NOT NULL,
+	"TAXKD" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LAND1" varchar(10) NOT NULL,
+	"STCEG" varchar(20),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM" (
+	"BP_HEADER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"TAXNUM" varchar(20),
+	"TAXTYPE" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BICD" varchar(20),
+	"BIZAREA" varchar(10),
+	"CCCD" varchar(10),
+	"COMPCD" varchar(20),
+	"CORPCD" varchar(10) NOT NULL,
+	"DEPTCD" varchar(10) NOT NULL,
+	"DEPTLVL" varchar(10),
+	"DEPTPOSNO" varchar(30),
+	"DHEMPID" varchar(20),
+	"GNCD" varchar(20),
+	"PCCD" varchar(10),
+	"PDEPTCD" varchar(10),
+	"VALIDFROMDT" varchar(10),
+	"VALIDTODT" varchar(10),
+	"WERKS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTCD_unique" UNIQUE("DEPTCD")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM" (
+	"DEPTCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"COMPNM" varchar(90),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM" (
+	"DEPTCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CORPNM" varchar(90),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM" (
+	"DEPTCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEPTNM" varchar(90),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ADDRCNTRY" varchar(10),
+	"AEDAT" varchar(10),
+	"AENAM" varchar(12),
+	"AEZET" varchar(10),
+	"BICD" varchar(20),
+	"BIZAREA" varchar(10),
+	"BSCADDR" varchar(35),
+	"COMPCD" varchar(20),
+	"CORPCD" varchar(10),
+	"COUNTRYCD" varchar(10),
+	"CSFROMDT" varchar(10),
+	"CSTODT" varchar(10),
+	"CTIROLE" varchar(10),
+	"DEL" varchar(10),
+	"DEPENDDT" varchar(10),
+	"DEPTCD" varchar(10),
+	"DHJOBGRDCD" varchar(29),
+	"DHNAME" varchar(70),
+	"DHSINGLID" varchar(12),
+	"DISPATCH" varchar(10),
+	"DPSTARTDT" varchar(10),
+	"DTLADDR" varchar(35),
+	"DTLADDR2" varchar(35),
+	"EMAIL" varchar(40),
+	"EMPADR" varchar(10),
+	"EMPID" varchar(20) NOT NULL,
+	"EMPTYPE" varchar(20),
+	"ENGNAME" varchar(70),
+	"EPID" varchar(50),
+	"ERDAT" varchar(10),
+	"ERNAM" varchar(12),
+	"ERZET" varchar(10),
+	"FORIGNFLG" varchar(10),
+	"GJOBCD" varchar(20),
+	"GJOBDUTYCD" varchar(20),
+	"GJOBGRDCD" varchar(20),
+	"GNCD" varchar(20),
+	"HRMANAGE" varchar(10),
+	"IDNO" varchar(32),
+	"JOBCD" varchar(20),
+	"JOBCLASS" varchar(20),
+	"JOBDUTYCD" varchar(15),
+	"JOBGRDCD" varchar(12),
+	"KTL_EMP" varchar(10),
+	"LVABSENCE" varchar(10),
+	"MBPHONE" varchar(20),
+	"NAME" varchar(70),
+	"OKTL_EMPL" varchar(10),
+	"ORGBICD" varchar(20),
+	"ORGCOMPCD" varchar(20),
+	"ORGCORPCD" varchar(10),
+	"ORGDEPTCD" varchar(10),
+	"ORGPDEPCD" varchar(10),
+	"PAYPLC" varchar(10),
+	"PDEPTCD" varchar(10),
+	"PSTLCODE" varchar(10),
+	"RETIRE" varchar(10),
+	"SEX" varchar(10),
+	"SINGLEID" varchar(12),
+	"SINGLRQ" varchar(10),
+	"SOCIALID" varchar(16),
+	"SOCIALID_DECR" varchar(16),
+	"SOJRNEMP" varchar(10),
+	"TELNUM" varchar(20),
+	"TMPJDIV" varchar(20),
+	"USEDSYS" varchar(20),
+	"VALFROMDT" varchar(10),
+	"VALTODT" varchar(10),
+	"WFREQUIRE" varchar(10),
+	"WORKPLC" varchar(16),
+	"ZPRFLG" varchar(10),
+	"ZZBUKRS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_unique" UNIQUE("EMPID")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GTEXT" varchar(30),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BINM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"COMPNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CORPNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"COUNTRYNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"PCCD" varchar(10),
+	"WERKS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"KTEXT" varchar(20),
+	"LTEXT" varchar(40),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEPTNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"JOBGRDNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GJOBDUTYNM" varchar(21),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GJOBGRDNM" varchar(21),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ISEXECUT" varchar(10),
+	"JOBGRDTYPE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GJOBNM" varchar(20),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GNNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"JOBDUTYNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ISEXECUT" varchar(10),
+	"JOBGRDNM" varchar(60),
+	"JOBGRDTYPE" varchar(10),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"JOBNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LTEXT" varchar(40),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LTEXT" varchar(40),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BINM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"COMPNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CORPNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEPTNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEPTNM" varchar(60),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM" (
+	"EMPID" varchar(20) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DEPTNM" varchar(60),
+	"SPRAS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ADTL_01" varchar(10),
+	"ADTL_02" varchar(10),
+	"CORPCD" varchar(10) NOT NULL,
+	"GRPCD" varchar(10) NOT NULL,
+	"MAINCD" varchar(20) NOT NULL,
+	"VALIDFROMDT" varchar(10),
+	"VALIDTODT" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_GRPCD_unique" UNIQUE("GRPCD")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME" (
+	"GRPCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"NAME" varchar(90),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BISMT" varchar(18),
+	"BRGEW" varchar(13),
+	"GEWEI" varchar(10),
+	"GROES" varchar(32),
+	"LVORM" varchar(10),
+	"MAGRV" varchar(10),
+	"MATKL" varchar(10),
+	"MATNR" varchar(18) NOT NULL,
+	"MBRSH" varchar(10),
+	"MEABM" varchar(10),
+	"MEINS" varchar(10),
+	"MSTAE" varchar(10),
+	"MSTDE" varchar(10),
+	"MTART" varchar(10),
+	"NTGEW" varchar(16),
+	"PRDHA" varchar(18),
+	"SPART" varchar(10),
+	"VHART" varchar(10),
+	"VOLEH" varchar(10),
+	"ZZAPPDT" varchar(10),
+	"ZZAPPTM" varchar(10),
+	"ZZAPPUS" varchar(12),
+	"ZZDESC" varchar(255),
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZNAME" varchar(40),
+	"ZZPRFLG" varchar(10),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"ZZSPEC" varchar(255),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "EQUP_MASTER_MATL_MATNR_unique" UNIQUE("MATNR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL_CHARASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_CHARASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ATAW1" varchar(10),
+	"ATAWE" varchar(10),
+	"ATBEZ" varchar(30),
+	"ATFLB" varchar(16),
+	"ATFLV" varchar(16),
+	"ATNAM" varchar(30),
+	"ATWRT" varchar(30),
+	"ATWTB" varchar(30),
+	"CLASS" varchar(18),
+	"KLART" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL_CLASSASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_CLASSASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CLASS" varchar(18),
+	"KLART" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL_DESC" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_DESC_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"MAKTX" varchar(40),
+	"SPRAS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL_PLNT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_PLNT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LVORM" varchar(10),
+	"MMSTA" varchar(10),
+	"MMSTD" varchar(10),
+	"WERKS" varchar(10),
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZMTARP" varchar(10),
+	"ZZPRFLG" varchar(10),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."EQUP_MASTER_MATL_UNIT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."EQUP_MASTER_MATL_UNIT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"GEWEI" varchar(10),
+	"MEABM" varchar(10),
+	"MEINH" varchar(10),
+	"UMREN" varchar(10),
+	"UMREZ" varchar(10),
+	"VOLEH" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BISMT" varchar(18),
+	"BRGEW" varchar(13),
+	"GEWEI" varchar(10),
+	"GROES" varchar(32),
+	"LVORM" varchar(10),
+	"MAGRV" varchar(10),
+	"MATKL" varchar(10),
+	"MATNR" varchar(18) NOT NULL,
+	"MBRSH" varchar(10),
+	"MEABM" varchar(10),
+	"MEINS" varchar(10),
+	"MSTAE" varchar(10),
+	"MSTDE" varchar(10),
+	"MTART" varchar(10),
+	"NTGEW" varchar(16),
+	"PRDHA" varchar(18),
+	"SPART" varchar(10),
+	"VHART" varchar(10),
+	"VOLEH" varchar(10),
+	"ZZACT" varchar(18),
+	"ZZAPPDT" varchar(10),
+	"ZZAPPTM" varchar(10),
+	"ZZAPPUS" varchar(12),
+	"ZZCERT" varchar(10),
+	"ZZDESC" varchar(255),
+	"ZZINSP" varchar(10),
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZMMTYP" varchar(10),
+	"ZZMRC" varchar(10),
+	"ZZNAME" varchar(40),
+	"ZZPJT" varchar(24),
+	"ZZPLMID" varchar(50),
+	"ZZPRCD_SCV_CTLP" varchar(10),
+	"ZZPRFLG" varchar(12),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"ZZREPMAT" varchar(18),
+	"ZZREP_DIA" varchar(10),
+	"ZZREP_DIA_UOM" varchar(10),
+	"ZZREP_ITM_MATL" varchar(60),
+	"ZZSMID" varchar(18),
+	"ZZSPEC" varchar(255),
+	"ZZSTL" varchar(50),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "MATERIAL_MASTER_PART_MATL_MATNR_unique" UNIQUE("MATNR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL_CHARASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_CHARASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ATAW1" varchar(10),
+	"ATAWE" varchar(10),
+	"ATBEZ" varchar(30),
+	"ATFLB" varchar(16),
+	"ATFLV" varchar(16),
+	"ATNAM" varchar(30) NOT NULL,
+	"ATWRT" varchar(30),
+	"ATWTB" varchar(30),
+	"CLASS" varchar(18) NOT NULL,
+	"KLART" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL_CLASSASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_CLASSASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CLASS" varchar(18) NOT NULL,
+	"KLART" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL_DESC" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_DESC_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"MAKTX" varchar(40),
+	"SPRAS" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL_PLNT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_PLNT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LVORM" varchar(10),
+	"MMSTA" varchar(10),
+	"MMSTD" varchar(10),
+	"WERKS" varchar(10) NOT NULL,
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZMTARP" varchar(10),
+	"ZZPRFLG" varchar(10),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_MATL_UNIT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_MATL_UNIT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BREIT" varchar(13),
+	"BRGEW" varchar(13),
+	"GEWEI" varchar(10),
+	"HOEHE" varchar(13),
+	"LAENG" varchar(13),
+	"MEABM" varchar(10),
+	"MEINH" varchar(10) NOT NULL,
+	"UMREN" varchar(10),
+	"UMREZ" varchar(10),
+	"VOLEH" varchar(10),
+	"VOLUM" varchar(13),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MATERIAL_MASTER_PART_RETURN_CMCTB_MAT_BSE" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MATERIAL_MASTER_PART_RETURN_CMCTB_MAT_BSE_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"IF_MSG" varchar(100),
+	"IF_STAT" varchar(10),
+	"MAT_CD" varchar(18) NOT NULL,
+	"MAT_ID" varchar(50),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "MATERIAL_MASTER_PART_RETURN_CMCTB_MAT_BSE_MAT_CD_unique" UNIQUE("MAT_CD")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BISMT" varchar(18),
+	"BRGEW" varchar(13),
+	"GEWEI" varchar(10),
+	"GROES" varchar(32),
+	"LVORM" varchar(10),
+	"MAGRV" varchar(10),
+	"MATKL" varchar(10),
+	"MATNR" varchar(18) NOT NULL,
+	"MBRSH" varchar(10),
+	"MEABM" varchar(10),
+	"MEINS" varchar(10),
+	"MSTAE" varchar(10),
+	"MSTDE" varchar(10),
+	"MTART" varchar(10),
+	"NTGEW" varchar(16),
+	"PRDHA" varchar(18),
+	"SPART" varchar(10),
+	"VHART" varchar(10),
+	"VOLEH" varchar(10),
+	"ZZAPPDT" varchar(10),
+	"ZZAPPTM" varchar(10),
+	"ZZAPPUS" varchar(12),
+	"ZZDESC" varchar(255),
+	"ZZDOKAR" varchar(10),
+	"ZZDOKNR" varchar(25),
+	"ZZDOKTL" varchar(10),
+	"ZZDOKVR" varchar(10),
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZMMTYP" varchar(10),
+	"ZZNAME" varchar(40),
+	"ZZPRFLG" varchar(10),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"ZZSPEC" varchar(255),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "MODEL_MASTER_MATL_MATNR_unique" UNIQUE("MATNR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL_CHARASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_CHARASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ATAW1" varchar(10),
+	"ATAWE" varchar(10),
+	"ATBEZ" varchar(30),
+	"ATFLB" varchar(16),
+	"ATFLV" varchar(16),
+	"ATNAM" varchar(30),
+	"ATWRT" varchar(30),
+	"ATWTB" varchar(30),
+	"CLASS" varchar(18),
+	"KLART" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL_CLASSASGN" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_CLASSASGN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CLASS" varchar(18),
+	"KLART" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL_DESC" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_DESC_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"MAKTX" varchar(40),
+	"SPRAS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL_PLNT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_PLNT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LVORM" varchar(10),
+	"MMSTA" varchar(10),
+	"MMSTD" varchar(10),
+	"WERKS" varchar(10),
+	"ZZLAMDT" varchar(10),
+	"ZZLAMTM" varchar(10),
+	"ZZLAMUS" varchar(12),
+	"ZZMTARP" varchar(10),
+	"ZZPRFLG" varchar(10),
+	"ZZREGDT" varchar(10),
+	"ZZREGTM" varchar(10),
+	"ZZREGUS" varchar(12),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."MODEL_MASTER_MATL_UNIT" (
+	"MATNR" varchar(18) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."MODEL_MASTER_MATL_UNIT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BREIT" varchar(13),
+	"BRGEW" varchar(13),
+	"GEWEI" varchar(10),
+	"HOEHE" varchar(13),
+	"LAENG" varchar(13),
+	"MEABM" varchar(10),
+	"MEINH" varchar(10),
+	"UMREN" varchar(10),
+	"UMREZ" varchar(10),
+	"VOLEH" varchar(10),
+	"VOLUM" varchar(13),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ABTEI" varchar(12),
+	"ANRED" varchar(15),
+	"BKZER" varchar(10),
+	"BKZKP" varchar(10),
+	"BKZKS" varchar(10),
+	"BKZOB" varchar(10),
+	"BUKRS" varchar(10),
+	"CCTR" varchar(10) NOT NULL,
+	"DATAB" varchar(10),
+	"DATBI" varchar(10) NOT NULL,
+	"DATLT" varchar(14),
+	"DRNAM" varchar(10),
+	"FUNC_AREA" varchar(16),
+	"GSBER" varchar(10),
+	"KHINR" varchar(12),
+	"KOKRS" varchar(10) NOT NULL,
+	"KOSAR" varchar(10),
+	"LAND1" varchar(10),
+	"MGEFL" varchar(10),
+	"NAME1" varchar(70),
+	"NAME2" varchar(70),
+	"NAME3" varchar(70),
+	"NAME4" varchar(70),
+	"ORT01" varchar(35),
+	"ORT02" varchar(35),
+	"PFACH" varchar(10),
+	"PKZER" varchar(10),
+	"PKZKP" varchar(10),
+	"PKZKS" varchar(10),
+	"PRCTR" varchar(10),
+	"PSTL2" varchar(10),
+	"PSTLZ" varchar(10),
+	"REGIO" varchar(10),
+	"SPRAS" varchar(10),
+	"STRAS" varchar(35),
+	"TELBX" varchar(15),
+	"TELF1" varchar(16),
+	"TELF2" varchar(16),
+	"TELFX" varchar(31),
+	"TELTX" varchar(30),
+	"TELX1" varchar(30),
+	"TXJCD" varchar(15),
+	"VERAK" varchar(60),
+	"VERAK_USE" varchar(12),
+	"VMETH" varchar(10),
+	"WAERS" varchar(10),
+	"ZZBRANCH" varchar(10),
+	"ZZDELETE" varchar(10),
+	"ZZFCTRI" varchar(10),
+	"ZZSECCODE" varchar(10),
+	"ZZSEGMENT" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_CCTR_CCTR_unique" UNIQUE("CCTR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT" (
+	"CCTR" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"KTEXT" varchar(60),
+	"LTEXT" varchar(120),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT_CCTR_unique" UNIQUE("CCTR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_PCTR" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_PCTR_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ABTEI" varchar(12),
+	"DATAB" varchar(10),
+	"DATBI" varchar(10) NOT NULL,
+	"KHINR" varchar(12),
+	"KOKRS" varchar(10) NOT NULL,
+	"LOCK_IND" varchar(10),
+	"PCTR" varchar(10) NOT NULL,
+	"SEGMENT" varchar(10),
+	"TXJCD" varchar(15),
+	"VERAK" varchar(20),
+	"VERAK_USE" varchar(12),
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_PCTR_PCTR_unique" UNIQUE("PCTR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZBUKRS" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZBUKRS_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CURR_BUKR" varchar(10),
+	"ZBUKRS" varchar(10) NOT NULL,
+	"ZZBUTXT" varchar(50),
+	"ZZCITY" varchar(50),
+	"ZZCOUNTRY" varchar(10),
+	"ZZDELETE" varchar(10),
+	"ZZLANGU" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZBUKRS_ZBUKRS_unique" UNIQUE("ZBUKRS")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZEKGRP" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZEKGRP_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZEKGRP" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"ZZEKNAM" varchar(36),
+	"ZZEKTEL" varchar(12),
+	"ZZEMPNUM" varchar(10),
+	"ZZSINGLE" varchar(241),
+	"ZZTELFX" varchar(31),
+	"ZZTEL_NUM" varchar(30),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZEKGRP_ZEKGRP_unique" UNIQUE("ZEKGRP")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZEKORG" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZEKORG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZEKORG" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"ZZEKOTX" varchar(40),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZEKORG_ZEKORG_unique" UNIQUE("ZEKORG")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZGSBER" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZGSBER_ZGSBER_unique" UNIQUE("ZGSBER")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT" (
+	"ZGSBER" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"LANGU" varchar(10) NOT NULL,
+	"TXTMI" varchar(60),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT_ZGSBER_unique" UNIQUE("ZGSBER")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZLGORT" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZLGORT_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZLGORT" varchar(10) NOT NULL,
+	"ZWERKS" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"ZZLGOBE" varchar(32),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZLGORT_ZLGORT_unique" UNIQUE("ZLGORT")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZSPART" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZSPART_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZSPART" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZSPART_ZSPART_unique" UNIQUE("ZSPART")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKBUR" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKBUR_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CTRY_SOFF" varchar(10),
+	"LANG_SOFF" varchar(10),
+	"ZVKBUR" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZVKBUR_ZVKBUR_unique" UNIQUE("ZVKBUR")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKGRP" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKGRP_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZVKGRP" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZVKGRP_ZVKGRP_unique" UNIQUE("ZVKGRP")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKORG" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVKORG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZVKORG" varchar(10) NOT NULL,
+	"ZZBOAVO" varchar(10),
+	"ZZDELETE" varchar(10),
+	"ZZKUNNR" varchar(10),
+	"ZZVKOKL" varchar(10),
+	"ZZWAERS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZVKORG_ZVKORG_unique" UNIQUE("ZVKORG")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVSTEL" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVSTEL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ALAN_VSTE" varchar(10),
+	"AZON_VSTE" varchar(10),
+	"CTRY_SHPT" varchar(10),
+	"LANG_SHPT" varchar(10),
+	"ZVSTEL" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"ZZFABKL" varchar(10),
+	"ZZLAZBS" varchar(10),
+	"ZZRIZBS" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZVSTEL_ZVSTEL_unique" UNIQUE("ZVSTEL")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVTWEG" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZVTWEG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ZVTWEG" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZVTWEG_ZVTWEG_unique" UNIQUE("ZVTWEG")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZWERKS" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."ORGANIZATION_MASTER_HRHMTB_ZWERKS_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"CTRY_PLNT" varchar(10),
+	"LANG_PLNT" varchar(10),
+	"ZWERKS" varchar(10) NOT NULL,
+	"ZZDELETE" varchar(10),
+	"ZZFABKL" varchar(10),
+	"ZZNAME1" varchar(60),
+	"ZZNAME2" varchar(60),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZWERKS_ZWERKS_unique" UNIQUE("ZWERKS")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."PROJECT_MASTER_CMCTB_PROJ_MAST" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."PROJECT_MASTER_CMCTB_PROJ_MAST_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"AS_GRNT_PRD" varchar(10),
+	"BIZCLS" varchar(10),
+	"BIZLOC_CD" varchar(10),
+	"BIZ_DMN" varchar(10),
+	"BP_DL_DT" varchar(10),
+	"CHN_PROJ_TP" varchar(10),
+	"CLS_1" varchar(20),
+	"CLS_2" varchar(20),
+	"CNRT_CNTN_YN" varchar(10),
+	"CNRT_DL_DT" varchar(10),
+	"CNRT_DT" varchar(10),
+	"CNRT_RESV_YN" varchar(10),
+	"CO_CD" varchar(10),
+	"CSTM_PO_NO" varchar(35),
+	"DEL_YN" varchar(10),
+	"DIGT_PDT_GRP" varchar(10),
+	"DIST_PATH" varchar(10),
+	"DL_BF_PROJ_NM" varchar(120),
+	"DL_CSTM_CD" varchar(10),
+	"DOCK_CD" varchar(10),
+	"DSN_CHRGR" varchar(13),
+	"FIN_GRNT_FN_DT" varchar(10),
+	"GENT_CNT" varchar(10),
+	"GOV" varchar(60),
+	"GRNT_STDT" varchar(10),
+	"IF_STAT" varchar(10),
+	"IMO_NO" varchar(10),
+	"INQY_NO" varchar(30),
+	"INQY_SEQ" varchar(10),
+	"IO_GB" varchar(10),
+	"MNG_ACOT_DMN" varchar(10),
+	"MN_ENGN_TP_CD" varchar(30),
+	"MSHIP_NO" varchar(24),
+	"NEW_MC_YN" varchar(10),
+	"NTTP" varchar(10),
+	"ORDR_GRNT_FN_DT" varchar(10),
+	"ORDR_GRNT_PRD" varchar(10),
+	"OWN_1" varchar(10),
+	"OWN_AB" varchar(60),
+	"OWN_NM" varchar(40),
+	"PDT_LVL_4" varchar(14),
+	"PLNT_CD" varchar(10),
+	"PRCTR" varchar(10),
+	"PRGS_STAT" varchar(10),
+	"PROJ_CRTE_REQ_DT" varchar(10),
+	"PROJ_CRTE_REQ_EMPNO" varchar(13),
+	"PROJ_DL_PLN_DT" varchar(10),
+	"PROJ_DL_RT_DT" varchar(10),
+	"PROJ_DSC" varchar(120),
+	"PROJ_DTL_TP" varchar(10),
+	"PROJ_ETC_TP" varchar(10),
+	"PROJ_GB" varchar(10),
+	"PROJ_NO" varchar(24) NOT NULL,
+	"PROJ_PRGS_YN" varchar(10),
+	"PROJ_PROF" varchar(10),
+	"PROJ_SCP" varchar(10),
+	"PROJ_WBS_TP" varchar(10),
+	"PRO_PROJ_NO" varchar(24),
+	"QM_CLS" varchar(10),
+	"REF_NO" varchar(10),
+	"RLTD_PROJ" varchar(24),
+	"RL_DL_DT" varchar(10),
+	"SALE_GRP" varchar(10),
+	"SALE_ORG_CD" varchar(10),
+	"SA_DT" varchar(10),
+	"SERS_NO" varchar(24),
+	"SERS_YN" varchar(10),
+	"SHTYPE" varchar(10),
+	"SHTYPE_CD" varchar(10),
+	"SHTYPE_GRP" varchar(10),
+	"SHTYPE_UOM" varchar(10),
+	"SKND" varchar(10),
+	"SRC_SYS_ID" varchar(10),
+	"STDT" varchar(10),
+	"SYS_ACOT_CLSD_DT" varchar(10),
+	"TOT_CNRT_CNT" varchar(10),
+	"TYPE" varchar(10),
+	"WP_PROJ_TP" varchar(10),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "PROJECT_MASTER_CMCTB_PROJ_MAST_PROJ_NO_unique" UNIQUE("PROJ_NO")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER" (
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"VNDRCD" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "VENDOR_MASTER_BP_HEADER_VNDRCD_unique" UNIQUE("VNDRCD")
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ADR_NO" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"EMAIL_ADR" varchar(241),
+	"REPR_SER" varchar(10) NOT NULL,
+	"VLD_ST_DT" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"FAXNO" varchar(30),
+	"FAX_ETS_NO" varchar(10),
+	"NTN_CD" varchar(10),
+	"REPR_SER" varchar(10) NOT NULL,
+	"VLD_ST_DT" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ADR_1" varchar(190),
+	"ADR_2" varchar(120),
+	"ADR_TMZ" varchar(10),
+	"CITY_ZIP_NO" varchar(10),
+	"ETC_ADR_1" varchar(180),
+	"ETC_ADR_2" varchar(180),
+	"INTL_ADR_VER_ID" varchar(10) NOT NULL,
+	"LANG_KEY" varchar(10),
+	"NTN_CD" varchar(10),
+	"POBX" varchar(10),
+	"POBX_ZIP_NO" varchar(10),
+	"REGN_CD" varchar(10),
+	"TAX_JRDT_ZONE_CD" varchar(15),
+	"TRANS_ZONE" varchar(10),
+	"TTL" varchar(90),
+	"VNDRNM_1" varchar(120),
+	"VNDRNM_2" varchar(120),
+	"VNDRNM_3" varchar(120),
+	"VNDRNM_4" varchar(120),
+	"VNDRNM_ABRV_1" varchar(60),
+	"VNDRNM_ABRV_2" varchar(60),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ETX_NO" varchar(10),
+	"HP_ORDR" varchar(10),
+	"NTN_CD" varchar(10),
+	"REPR_SER" varchar(10) NOT NULL,
+	"TELNO" varchar(30),
+	"VLD_ST_DT" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"REPR_SER" varchar(10) NOT NULL,
+	"URL" varchar(2000),
+	"VLD_ST_DT" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_TAXNUM" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_TAXNUM_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BIZ_PTNR_TX_NO" varchar(20),
+	"TX_NO_CTG" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ACNT_GRP" varchar(10),
+	"ACNT_GRP_TP" varchar(10),
+	"ADR_1" varchar(120),
+	"ADR_2" varchar(512),
+	"AGR_DT" varchar(10),
+	"AGR_R_ID" varchar(13),
+	"AGR_TM" varchar(10),
+	"BIZCON" varchar(30),
+	"BIZR_NO" varchar(10),
+	"BIZTP" varchar(30),
+	"BIZ_UOM_CD" varchar(10),
+	"BIZ_UOM_NM" varchar(40),
+	"CHGR_ID" varchar(13),
+	"CHG_DT" varchar(10),
+	"CHG_TM" varchar(10),
+	"CO_ID" varchar(10),
+	"CO_REG_NO" varchar(18),
+	"CO_VLM" varchar(10),
+	"CSTM_CD" varchar(10),
+	"DEL_HOLD_ORDR" varchar(10),
+	"DEL_ORDR" varchar(10),
+	"DMST_TOP_CD" varchar(10),
+	"DMST_TOP_NM" varchar(120),
+	"DNS_NO" varchar(11),
+	"DOC_NO" varchar(25),
+	"DOC_TP" varchar(10),
+	"DOC_VER" varchar(10),
+	"FIR_NM" varchar(120),
+	"GBL_TOP_CD" varchar(10),
+	"GBL_TOP_NM" varchar(120),
+	"GIRO_VNDR_ORDR" varchar(10),
+	"HOLD_CAUS" varchar(200),
+	"INB_FLAG" varchar(10),
+	"INTL_LCTN_CHK_NUM" varchar(10),
+	"OVLAP_CAUS_CD" varchar(10),
+	"PST_HOLD_ORDR" varchar(10),
+	"PTNT_VNDRCD" varchar(10),
+	"PTN_DOC" varchar(10),
+	"PUR_HOLD_DT" varchar(10),
+	"PUR_HOLD_ORDR" varchar(10),
+	"QLT_CHRGR_EMAIL" varchar(241),
+	"QLT_CHRGR_NM" varchar(20),
+	"QLT_CHRGR_TELNO" varchar(30),
+	"REGR_ID" varchar(13),
+	"REG_DT" varchar(10),
+	"REG_TM" varchar(10),
+	"REPR_NM" varchar(30),
+	"REPR_RESNO" varchar(13),
+	"REP_TEL_NO" varchar(30),
+	"SB_WKA_SEQ" varchar(10),
+	"SRCETX_RP_SEX_KEY" varchar(10),
+	"TTL" varchar(45),
+	"TX_CD_4" varchar(18),
+	"VAT_REG_NO" varchar(20),
+	"VNDRNM_1" varchar(10),
+	"VNDRNO" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"ACOT_CHRGR_FAXNO" varchar(31),
+	"ACOT_CHRGR_TELNO" varchar(30),
+	"AUTH_GRP" varchar(10),
+	"BF_VNDRCD" varchar(10),
+	"CO_CD" varchar(10) NOT NULL,
+	"CSTM_VNDR_CLR_ORDR" varchar(10),
+	"CTL_ACNT" varchar(10),
+	"DEL_ORDR" varchar(10),
+	"FIN_IR_ACT_DT" varchar(10),
+	"FIN_IR_CALC_DT" varchar(10),
+	"IATA_BIC_GB" varchar(10),
+	"LOGST_VNDR_TP" varchar(10),
+	"MEMO" varchar(120),
+	"MIN_ORDR" varchar(10),
+	"MK_CHRGR_EMAIL" varchar(241),
+	"MOFFC_ACNT_NO" varchar(10),
+	"OVLAP_INVC_ORDR" varchar(10),
+	"PLN_GRP" varchar(10),
+	"PST_HOLD_ORDR" varchar(10),
+	"REP_TP" varchar(10),
+	"SPLY_COND" varchar(10),
+	"SPLY_HOLD_ORDR" varchar(10),
+	"SPLY_MTHD" varchar(10),
+	"SPRT_SPLY_ORDR" varchar(10),
+	"SRCE_TX_CD" varchar(10),
+	"SRCE_TX_NTN_CD" varchar(10),
+	"SRT_KEY" varchar(10),
+	"TRD_BANK_SHRT_KEY" varchar(10),
+	"VNDR_ACNT_NO" varchar(12),
+	"VNDR_CHRGR_NM" varchar(45),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"DCHAG_CAUS" varchar(200),
+	"DCHAG_CERT_NO" varchar(15),
+	"DCHAG_ED_DT" varchar(10),
+	"DCHAG_ST_DT" varchar(10),
+	"RECIP_TP" varchar(10),
+	"SRCE_TX_IDENT_NO" varchar(16),
+	"SRCE_TX_NO" varchar(10),
+	"SRCE_TX_REL_ORDR" varchar(10),
+	"SRCE_TX_TP" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"AT_PUR_ORD_ORDR" varchar(10),
+	"CALC_SHM_GRP" varchar(10),
+	"CNFM_CTL_KEY" varchar(10),
+	"DEL_ORDR" varchar(10),
+	"DL_COND_1" varchar(10),
+	"DL_COND_2" varchar(28),
+	"GR_BSE_INVC_VR" varchar(10),
+	"ORD_CNFM_REQ_ORDR" varchar(10),
+	"PUR_HOLD_CAUS" varchar(120),
+	"PUR_HOLD_DT" varchar(10),
+	"PUR_HOLD_ORDR" varchar(10),
+	"PUR_ORD_CUR" varchar(10),
+	"PUR_ORG_CD" varchar(10) NOT NULL,
+	"SALE_CHRGR_NM" varchar(120),
+	"SPLY_COND" varchar(10),
+	"VNDR_TELNO" varchar(30),
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN" (
+	"VNDRCD" varchar(10) NOT NULL,
+	"id" integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (sequence name "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"BSE_PTNR_ORDR" varchar(10),
+	"ETC_REF_VNDRCD" varchar(10),
+	"PLNT_NO" varchar(10) NOT NULL,
+	"PTNR_CNT" varchar(10) NOT NULL,
+	"PTNR_SKL" varchar(10) NOT NULL,
+	"VNDR_SUB_NO" varchar(10) NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE "soap"."soap_logs" (
+	"id" serial PRIMARY KEY NOT NULL,
+	"direction" varchar(20) NOT NULL,
+	"system" varchar(50) NOT NULL,
+	"interface" varchar(100) NOT NULL,
+	"startedAt" timestamp NOT NULL,
+	"endedAt" timestamp,
+	"isSuccess" boolean DEFAULT false NOT NULL,
+	"requestData" text,
+	"responseData" text,
+	"errorMessage" text
+);
+--> statement-breakpoint
+ALTER TABLE "menu_assignments" ADD CONSTRAINT "menu_assignments_manager1_id_users_id_fk" FOREIGN KEY ("manager1_id") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "menu_assignments" ADD CONSTRAINT "menu_assignments_manager2_id_users_id_fk" FOREIGN KEY ("manager2_id") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM" ADD CONSTRAINT "CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM_BP_HEADER_CUSTOMER_MASTER_BP_HEADER_BP_HEADER_fk" FOREIGN KEY ("BP_HEADER") REFERENCES "mdg"."CUSTOMER_MASTER_BP_HEADER"("BP_HEADER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM" ADD CONSTRAINT "DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM_DEPTCD_DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTCD_fk" FOREIGN KEY ("DEPTCD") REFERENCES "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG"("DEPTCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM" ADD CONSTRAINT "DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM_DEPTCD_DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTCD_fk" FOREIGN KEY ("DEPTCD") REFERENCES "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG"("DEPTCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM" ADD CONSTRAINT "DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM_DEPTCD_DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTCD_fk" FOREIGN KEY ("DEPTCD") REFERENCES "mdg"."DEPARTMENT_CODE_CMCTB_DEPT_MDG"("DEPTCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM" ADD CONSTRAINT "EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM_EMPID_EMPLOYEE_MASTER_CMCTB_EMP_MDG_EMPID_fk" FOREIGN KEY ("EMPID") REFERENCES "mdg"."EMPLOYEE_MASTER_CMCTB_EMP_MDG"("EMPID") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME" ADD CONSTRAINT "EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME_GRPCD_EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_GRPCD_fk" FOREIGN KEY ("GRPCD") REFERENCES "mdg"."EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF"("GRPCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EQUP_MASTER_MATL_CHARASGN" ADD CONSTRAINT "EQUP_MASTER_MATL_CHARASGN_MATNR_EQUP_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."EQUP_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EQUP_MASTER_MATL_CLASSASGN" ADD CONSTRAINT "EQUP_MASTER_MATL_CLASSASGN_MATNR_EQUP_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."EQUP_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EQUP_MASTER_MATL_DESC" ADD CONSTRAINT "EQUP_MASTER_MATL_DESC_MATNR_EQUP_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."EQUP_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EQUP_MASTER_MATL_PLNT" ADD CONSTRAINT "EQUP_MASTER_MATL_PLNT_MATNR_EQUP_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."EQUP_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."EQUP_MASTER_MATL_UNIT" ADD CONSTRAINT "EQUP_MASTER_MATL_UNIT_MATNR_EQUP_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."EQUP_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MATERIAL_MASTER_PART_MATL_CHARASGN" ADD CONSTRAINT "MATERIAL_MASTER_PART_MATL_CHARASGN_MATNR_MATERIAL_MASTER_PART_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MATERIAL_MASTER_PART_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MATERIAL_MASTER_PART_MATL_CLASSASGN" ADD CONSTRAINT "MATERIAL_MASTER_PART_MATL_CLASSASGN_MATNR_MATERIAL_MASTER_PART_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MATERIAL_MASTER_PART_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MATERIAL_MASTER_PART_MATL_DESC" ADD CONSTRAINT "MATERIAL_MASTER_PART_MATL_DESC_MATNR_MATERIAL_MASTER_PART_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MATERIAL_MASTER_PART_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MATERIAL_MASTER_PART_MATL_PLNT" ADD CONSTRAINT "MATERIAL_MASTER_PART_MATL_PLNT_MATNR_MATERIAL_MASTER_PART_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MATERIAL_MASTER_PART_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MATERIAL_MASTER_PART_MATL_UNIT" ADD CONSTRAINT "MATERIAL_MASTER_PART_MATL_UNIT_MATNR_MATERIAL_MASTER_PART_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MATERIAL_MASTER_PART_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MODEL_MASTER_MATL_CHARASGN" ADD CONSTRAINT "MODEL_MASTER_MATL_CHARASGN_MATNR_MODEL_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MODEL_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MODEL_MASTER_MATL_CLASSASGN" ADD CONSTRAINT "MODEL_MASTER_MATL_CLASSASGN_MATNR_MODEL_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MODEL_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MODEL_MASTER_MATL_DESC" ADD CONSTRAINT "MODEL_MASTER_MATL_DESC_MATNR_MODEL_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MODEL_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MODEL_MASTER_MATL_PLNT" ADD CONSTRAINT "MODEL_MASTER_MATL_PLNT_MATNR_MODEL_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MODEL_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."MODEL_MASTER_MATL_UNIT" ADD CONSTRAINT "MODEL_MASTER_MATL_UNIT_MATNR_MODEL_MASTER_MATL_MATNR_fk" FOREIGN KEY ("MATNR") REFERENCES "mdg"."MODEL_MASTER_MATL"("MATNR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT" ADD CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT_CCTR_ORGANIZATION_MASTER_HRHMTB_CCTR_CCTR_fk" FOREIGN KEY ("CCTR") REFERENCES "mdg"."ORGANIZATION_MASTER_HRHMTB_CCTR"("CCTR") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT" ADD CONSTRAINT "ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT_ZGSBER_ORGANIZATION_MASTER_HRHMTB_ZGSBER_ZGSBER_fk" FOREIGN KEY ("ZGSBER") REFERENCES "mdg"."ORGANIZATION_MASTER_HRHMTB_ZGSBER"("ZGSBER") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_TAXNUM" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_TAXNUM_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_VENGEN_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "mdg"."VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN" ADD CONSTRAINT "VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN_VNDRCD_VENDOR_MASTER_BP_HEADER_VNDRCD_fk" FOREIGN KEY ("VNDRCD") REFERENCES "mdg"."VENDOR_MASTER_BP_HEADER"("VNDRCD") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+CREATE UNIQUE INDEX "menu_assignments_path_idx" ON "menu_assignments" USING btree ("menu_path");--> statement-breakpoint
+CREATE INDEX "menu_assignments_manager1_idx" ON "menu_assignments" USING btree ("manager1_id");--> statement-breakpoint
+CREATE INDEX "menu_assignments_manager2_idx" ON "menu_assignments" USING btree ("manager2_id");--> statement-breakpoint
+CREATE INDEX "menu_assignments_domain_idx" ON "menu_assignments" USING btree ("domain");
\ No newline at end of file
-- 
cgit v1.2.3

