diff options
| author | rlaks5757 <rlaks5757@gmail.com> | 2025-03-27 17:48:36 +0900 |
|---|---|---|
| committer | rlaks5757 <rlaks5757@gmail.com> | 2025-03-27 17:48:36 +0900 |
| commit | 773918229ccb14c0d00798fbbf2b2be0130a8251 (patch) | |
| tree | ab9e200e65cc471ec139cd8482bde70a3b0a105f /db/schema/rfq.ts | |
| parent | 92ddb4f13d48cbf344dc2bf63df4457b3c713608 (diff) | |
| parent | 34bbeb86c1a8d24b5f526710889b5e54d699cfd0 (diff) | |
merge complete
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(), |