diff options
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( |