(임수민) 준법 Red Flag 수정

1 files changed, 2 insertions, 0 deletions

diff --git a/db/schema/compliance.ts b/db/schema/compliance.ts
index d878abe1..09d945d1 100644
--- a/db/schema/compliance.ts
+++ b/db/schema/compliance.ts
@@ -52,6 +52,8 @@ export const complianceResponses = pgTable('compliance_responses', {
   reviewedBy: integer('reviewed_by').references(() => users.id), // 검토자
   reviewedAt: timestamp('reviewed_at'),
   reviewNotes: text('review_notes'), // 검토 의견
+  redFlagResolvedAt: timestamp('red_flag_resolved_at'), // RED FLAG 해제 일시
+  redFlagResolutionApprovalId: varchar('red_flag_resolution_approval_id', { length: 255 }), // RED FLAG 해소 합의 결재 ID (knox apInfId)
   createdAt: timestamp('created_at').defaultNow(),
   updatedAt: timestamp('updated_at').defaultNow(),
 });