(김준회) Knox 임직원 기준으로 users 테이블 upsert 처리 (cron-job과 동기식 처리)

4 files changed, 8 insertions, 7 deletions

diff --git a/db/schema/index.ts b/db/schema/index.ts
index db449616..19470fca 100644
--- a/db/schema/index.ts
+++ b/db/schema/index.ts
@@ -30,6 +30,9 @@ export * from './history';
 export * from './notification';
 export * from './templates';
 
+// 부서별 도메인 할당 관리
+export * from './departmentDomainAssignments';
+
 // MDG SOAP 수신용
 export * from './MDG/mdg'
 
diff --git a/db/schema/knox/organization.ts b/db/schema/knox/organization.ts
index 48b13254..8d540562 100644
--- a/db/schema/knox/organization.ts
+++ b/db/schema/knox/organization.ts
@@ -1,7 +1,5 @@
-import { pgSchema, varchar, jsonb, timestamp, index, primaryKey } from "drizzle-orm/pg-core";
-
-// Knox 전용 스키마 네임스페이스 재사용
-export const knoxSchema = pgSchema("knox");
+import { varchar, jsonb, timestamp, index, primaryKey } from "drizzle-orm/pg-core";
+import { knoxSchema } from "./employee";
 
 export const organization = knoxSchema.table(
   "organization",
diff --git a/db/schema/knox/titles.ts b/db/schema/knox/titles.ts
index 338ba79b..6fdf7329 100644
--- a/db/schema/knox/titles.ts
+++ b/db/schema/knox/titles.ts
@@ -1,6 +1,5 @@
-import { pgSchema, varchar, jsonb, timestamp, index, primaryKey } from "drizzle-orm/pg-core";
-
-export const knoxSchema = pgSchema("knox");
+import { varchar, jsonb, timestamp, index, primaryKey } from "drizzle-orm/pg-core";
+import { knoxSchema } from "./employee";
 
 export const title = knoxSchema.table(
   "title",
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")