diff options
Diffstat (limited to 'db/schema/rfq.ts')
| -rw-r--r-- | db/schema/rfq.ts | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/db/schema/rfq.ts b/db/schema/rfq.ts index fe5581ce..98c4245c 100644 --- a/db/schema/rfq.ts +++ b/db/schema/rfq.ts @@ -81,6 +81,9 @@ export const rfqAttachments = pgTable("rfq_attachments", { evaluationId: integer("evaluation_id") .references(() => rfqEvaluations.id) .$type<number | null>(), + cbeId: integer("cbe_id") + .references(() => cbeEvaluations.id) + .$type<number | null>(), createdAt: timestamp("created_at").defaultNow().notNull(), commentId: integer("comment_id") .references(() => rfqComments.id) @@ -92,11 +95,15 @@ export const rfqComments = pgTable("rfq_comments", { rfqId: integer("rfq_id").references(() => rfqs.id), vendorId: integer("vendor_id").references(() => vendors.id), commentText: text("comment_text").notNull(), - commentedBy: integer("commented_by").notNull(), + commentedBy: integer("commented_by") + .references(() => users.id) // users 테이블의 id 필드 참조 추가 + .notNull(), // 아래처럼, 평가(TBE/CBE)에 속한 코멘트인지 여부를 구분할 필드 - evaluationId: integer("evaluation_id").references(() => rfqEvaluations.id) + evaluationId: integer("evaluation_id") + .references(() => rfqEvaluations.id) .$type<number | null>(), - cbeId: integer("evaluation_id").references(() => cbeEvaluations.id) + cbeId: integer("cbe_id") + .references(() => cbeEvaluations.id) .$type<number | null>(), createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), |