(김준회) 구매그룹코드를 users 테이블의 userCode 컬럼에 업데이트하도록 cronjob 등록

1 files changed, 3 insertions, 0 deletions

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),