diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-02 00:45:49 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-02 00:45:49 +0000 |
| commit | 2acf5f8966a40c1c9a97680c8dc263ee3f1ad3d1 (patch) | |
| tree | f406b5c86f563347c7fd088a85fd1a82284dc5ff /db/schema/bRfq.ts | |
| parent | 6a9ca20deddcdcbe8495cf5a73ec7ea5f53f9b55 (diff) | |
(대표님/최겸) 20250702 변경사항 업데이트
Diffstat (limited to 'db/schema/bRfq.ts')
| -rw-r--r-- | db/schema/bRfq.ts | 10 |
1 files changed, 10 insertions, 0 deletions
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( |