summaryrefslogtreecommitdiff
path: root/db/schema/compliance.ts
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema/compliance.ts')
-rw-r--r--db/schema/compliance.ts2
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(),
});