(최겸) 구매 피드백 수정, 안전담당자, pq항목 내 첨부, 내외자 구분, 도로명주소 api 반영(운영기준)

1 files changed, 6 insertions, 1 deletions

diff --git a/db/schema/compliance.ts b/db/schema/compliance.ts
index 09d945d1..efad9bf0 100644
--- a/db/schema/compliance.ts
+++ b/db/schema/compliance.ts
@@ -82,11 +82,12 @@ export const complianceResponseFiles = pgTable('compliance_response_files', {
   uploadedAt: timestamp('uploaded_at').defaultNow(),
 });
 
-// 7. 레드플래그 담당자 관리
+// 7. 담당자 관리(레드플래그, 준법, 안전)
 export const redFlagManagers = pgTable('red_flag_managers', {
   id: serial('id').primaryKey(),
   purchasingManagerId: integer('purchasing_manager_id').references(() => users.id), // 구매기획 담당자
   complianceManagerId: integer('compliance_manager_id').references(() => users.id), // 준법 담당자
+  hseManagerId: integer('hse_manager_id').references(() => users.id), // 안전(HSE) 담당자
   createdAt: timestamp('created_at').defaultNow(),
   updatedAt: timestamp('updated_at').defaultNow(),
 });
@@ -158,6 +159,10 @@ export const redFlagManagersRelations = relations(redFlagManagers, ({ one }) =>
     fields: [redFlagManagers.complianceManagerId],
     references: [users.id],
   }),
+  hseManager: one(users, {
+    fields: [redFlagManagers.hseManagerId],
+    references: [users.id],
+  }),
 }));
 
 // 타입 정의