From edc0eabc8f5fc44408c28023ca155bd73ddf8183 Mon Sep 17 00:00:00 2001 From: joonhoekim <26rote@gmail.com> Date: Wed, 23 Jul 2025 05:55:31 +0000 Subject: (김준회) Knox 임직원 기준으로 users 테이블 upsert 처리 (cron-job과 동기식 처리) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/users.ts | 1 + 1 file changed, 1 insertion(+) (limited to 'db/schema/users.ts') diff --git a/db/schema/users.ts b/db/schema/users.ts index ae97da6f..bf5d41de 100644 --- a/db/schema/users.ts +++ b/db/schema/users.ts @@ -13,6 +13,7 @@ export const users = pgTable("users", { id: integer("id").primaryKey().generatedAlwaysAsIdentity(), name: varchar("name", { length: 255 }).notNull(), email: varchar("email", { length: 255 }).notNull().unique(), + deptCode: varchar("deptCode", { length: 50 }), deptName: varchar("deptName", { length: 255 }), companyId: integer("company_id") -- cgit v1.2.3