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/bRfq.ts | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'db/schema/bRfq.ts') diff --git a/db/schema/bRfq.ts b/db/schema/bRfq.ts index 3cd1e98a..18929b77 100644 --- a/db/schema/bRfq.ts +++ b/db/schema/bRfq.ts @@ -217,6 +217,8 @@ export const bRfqAttachmentRevisions = pgTable( .references(() => users.id, { onDelete: "set null" }) .notNull(), createdAt: timestamp("created_at").defaultNow().notNull(), + + }, (t) => ({ // 첨부파일당 하나의 최신 리비전만 허용 @@ -320,6 +322,14 @@ export const vendorAttachmentResponses = pgTable( createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), + + createdBy: integer("created_by") + .references(() => users.id, { onDelete: "set null" }) + , + + updatedBy: integer("updated_by") + .references(() => users.id, { onDelete: "set null" }) + , }, (t) => ({ // attachmentId + vendorId + rfqType 유니크 vendorResponseIdx: uniqueIndex('vendor_response_idx').on( -- cgit v1.2.3