(대표님/최겸) 20250702 변경사항 업데이트

1 files changed, 10 insertions, 1 deletions

diff --git a/db/schema/evaluationCriteria.ts b/db/schema/evaluationCriteria.ts
index 232c4b69..f87b2219 100644
--- a/db/schema/evaluationCriteria.ts
+++ b/db/schema/evaluationCriteria.ts
@@ -10,6 +10,7 @@ import {
   varchar

 } from 'drizzle-orm/pg-core';

 import { eq, relations, sql } from 'drizzle-orm';

+import { users } from './users';

 

 // ----------------------------------------------------------------------------------------------------

 

@@ -54,6 +55,14 @@ const regEvalCriteria = pgTable('reg_eval_criteria', {
   remarks: text('remarks'),

   createdAt: timestamp('created_at').defaultNow().notNull(),

   updatedAt: timestamp('updated_at').defaultNow().notNull(),

+  createdBy: integer("created_by")

+    .notNull()

+    .references(() => users.id, { onDelete: "set null" }),

+

+  updatedBy: integer("updated_by")

+    .notNull()

+    .references(() => users.id, { onDelete: "set null" }),

+

 });

 const regEvalCriteriaDetails = pgTable('reg_eval_criteria_details', {

   id: serial('id').primaryKey(),

@@ -102,7 +111,7 @@ const regEvalCriteriaView = pgView('reg_eval_criteria_view').as((qb) =>
 const regEvalCriteriaRelations = relations(regEvalCriteria, ({ many }) => ({

   details: many(regEvalCriteriaDetails),

 }));

-const regEvalCriteriaDetailsRelations = relations(regEvalCriteriaDetails, ({one}) => ({

+const regEvalCriteriaDetailsRelations = relations(regEvalCriteriaDetails, ({ one }) => ({

   criteria: one(regEvalCriteria, {

     fields: [regEvalCriteriaDetails.criteriaId],

     references: [regEvalCriteria.id],