From 2acf5f8966a40c1c9a97680c8dc263ee3f1ad3d1 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 2 Jul 2025 00:45:49 +0000 Subject: (대표님/최겸) 20250702 변경사항 업데이트 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/evaluationCriteria.ts | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'db/schema/evaluationCriteria.ts') 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], -- cgit v1.2.3