From 8a19a6fa336768d8b6712752c9d713360067ecb0 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Mon, 8 Dec 2025 08:45:20 +0000 Subject: (최겸) 구매 피드백 수정, 안전담당자, pq항목 내 첨부, 내외자 구분, 도로명주소 api 반영(운영기준) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/compliance.ts | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'db/schema/compliance.ts') 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], + }), })); // 타입 정의 -- cgit v1.2.3