diff options
Diffstat (limited to 'db/migrations/0170_curved_chimera.sql')
| -rw-r--r-- | db/migrations/0170_curved_chimera.sql | 1661 |
1 files changed, 1661 insertions, 0 deletions
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 |