From 74843fe598702a9a55f914f2d2d291368a5abb13 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Wed, 1 Oct 2025 10:31:23 +0000
Subject: (대표님) dolce 수정, spreadjs 수정 등
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

(limited to 'db')

diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts
index 1c634f64..aa6eb946 100644
--- a/db/schema/vendorDocu.ts
+++ b/db/schema/vendorDocu.ts
@@ -201,7 +201,8 @@ export const revisions = pgTable(
 
     registerId: varchar("register_id", { length: 50 }),
 
-    serialNo: varchar("serial_no", { length: 50 }), // 상대 시스템에서 생성한 ID
+    serialNo: varchar("serial_no", { length: 50 }), 
+    registerSerialNoMax: varchar("register_serial_no_max", { length: 50 }), 
 
   },
   (table) => {
@@ -210,6 +211,7 @@ export const revisions = pgTable(
         table.issueStageId,
         table.revision,
         table.usage,
+        table.serialNo,
         sql`COALESCE(${table.usageType}, '')`
       ),
 
-- 
cgit v1.2.3