(임수민) S-ERP 스키마 업데이트 요청 처리

1 files changed, 5 insertions, 5 deletions

diff --git a/db/schema/S_ERP/s_erp.ts b/db/schema/S_ERP/s_erp.ts
index 5a9ca36c..fc3bc59e 100644
--- a/db/schema/S_ERP/s_erp.ts
+++ b/db/schema/S_ERP/s_erp.ts
@@ -524,7 +524,7 @@ export const technicalGuidanceInvestment = sErpSchema.table("Technical_Guidance_
   FUMNR: varchar({ length: 10 }), // pk

   FUMIT: bigint({ mode: 'number' }), // pk

   DESCR: varchar({ length: 50 }),

-  FU_APPDATE: varchar({ length: 8 }),

+  FU_APPDATE: varchar({ length: 10 }),

   COST_INVEST: varchar({ length: 15 })

 }, (table) => ({

   // FUMNR, FUMIT 복합 PK에 UNIQUE 인덱스 추가

@@ -535,17 +535,17 @@ export const technicalGuidanceOrder = sErpSchema.table("Technical_Guidance_Order
   id: serial().primaryKey(),

   AUFNR: varchar({ length: 12 }), // pk (Order)

   VORNR: varchar({ length: 4 }), // pk (Operation)

-  ORD_ERDAT: varchar({ length: 50 }),

+  ORD_ERDAT: varchar({ length: 10 }),

   FUMNR: varchar({ length: 10 }),

   FUMIT: bigint({ mode: 'number' }),

   DESCR: varchar({ length: 50 }),

-  FU_APPDATE: varchar({ length: 50 }),

+  FU_APPDATE: varchar({ length: 10 }),

   BANFN: varchar({ length: 10 }),

   BNFPO: bigint({ mode: 'number' }),

-  BADAT: varchar({ length: 50 }),

+  BADAT: varchar({ length: 10 }),

   EBELN: varchar({ length: 10 }),

   EBELP: bigint({ mode: 'number' }),

-  PO_ERDAT: varchar({ length: 50 }),

+  PO_ERDAT: varchar({ length: 10 }),

   AUART: varchar({ length: 4 }),

   STTXT: varchar({ length: 40 }),

   EQUNR: varchar({ length: 18 }),