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],