summaryrefslogtreecommitdiff
path: root/db/schema/users.ts
diff options
context:
space:
mode:
authorjoonhoekim <26rote@gmail.com>2025-07-23 05:55:31 +0000
committerjoonhoekim <26rote@gmail.com>2025-07-23 05:55:31 +0000
commitedc0eabc8f5fc44408c28023ca155bd73ddf8183 (patch)
tree8469a2d932008f2fb5aae9be854cba436b9f807b /db/schema/users.ts
parente1b1b57b6bfcd18ba4daa44230e8a915b4e93a15 (diff)
(김준회) Knox 임직원 기준으로 users 테이블 upsert 처리 (cron-job과 동기식 처리)
Diffstat (limited to 'db/schema/users.ts')
-rw-r--r--db/schema/users.ts1
1 files changed, 1 insertions, 0 deletions
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")