diff options
Diffstat (limited to 'db/schema/compliance.ts')
| -rw-r--r-- | db/schema/compliance.ts | 7 |
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], + }), })); // 타입 정의 |