From bfe354f7633f62350e61eb784cbf1926079339d1 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 3 Sep 2025 09:22:56 +0000
Subject: (김준회) 구매그룹코드를 users 테이블의 userCode 컬럼에 업데이트하도록
 cronjob 등록
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

(limited to 'db')

diff --git a/db/schema/users.ts b/db/schema/users.ts
index 0e8809b7..f01db8db 100644
--- a/db/schema/users.ts
+++ b/db/schema/users.ts
@@ -67,6 +67,9 @@ export const users = pgTable("users", {
   isDeletedOnNonSap: boolean("is_deleted_on_non_sap"), // 퇴직여부 (SHI-API DEL_YN (Y/N))
   isRegularEmployee: boolean("is_regular_employee"), // 정직원여부 (SHI-API REGL_ORORD_GB (S/N))
 
+  // 사용자 코드 (구매그룹코드)
+  userCode: varchar("user_code", { length: 50 }),
+
 }, (table) => {
   return {
     emailIdx: uniqueIndex("users_email_idx").on(table.email),
-- 
cgit v1.2.3