From ba30be6035f1a5e3afc4d1d8b1e346c4db18537a Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Sun, 2 Nov 2025 14:25:36 +0900
Subject: (김준회) DOLCE 변경사항 검출로직 공통함수로 추출,
 DetailDwgReceiptMgmt에서 OFDC_NO 고려하도록 변경
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/vendorDocu.ts | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'db/schema/vendorDocu.ts')

diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts
index de9dc7fb..304fe5ae 100644
--- a/db/schema/vendorDocu.ts
+++ b/db/schema/vendorDocu.ts
@@ -203,7 +203,10 @@ export const revisions = pgTable(
     registerId: varchar("register_id", { length: 50 }),
 
     serialNo: varchar("serial_no", { length: 50 }), 
-    registerSerialNoMax: varchar("register_serial_no_max", { length: 50 }), 
+    registerSerialNoMax: varchar("register_serial_no_max", { length: 50 }),
+    
+    // OFDC Number for document identification
+    ofdcNo: varchar("ofdc_no", { length: 100 }),
 
   },
   (table) => {
-- 
cgit v1.2.3