diff options
Diffstat (limited to 'db/schema/bidding.ts')
| -rw-r--r-- | db/schema/bidding.ts | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts index 02e869b4..723bee32 100644 --- a/db/schema/bidding.ts +++ b/db/schema/bidding.ts @@ -150,6 +150,7 @@ export const biddings = pgTable('biddings', { currency: varchar('currency', { length: 3 }).default('KRW'), // 통화 budget: decimal('budget', { precision: 15, scale: 2 }), // 예산 targetPrice: decimal('target_price', { precision: 15, scale: 2 }), // 내정가 + targetPriceCalculationCriteria: text('target_price_calculation_criteria'), // 내정가 산정 기준 finalBidPrice: decimal('final_bid_price', { precision: 15, scale: 2 }), // 최종입찰가 // PR 정보 @@ -252,10 +253,10 @@ export const prItemsForBidding = pgTable('pr_items_for_bidding', { updatedAt: timestamp('updated_at').defaultNow().notNull(), }) -// 12. 입찰 조건 테이블 (구매자가 제시하는 조건들) +// 12. 입찰 조건 테이블 (SHI 구매자가 제시하는 조건들) export const biddingConditions = pgTable('bidding_conditions', { id: serial('id').primaryKey(), - biddingId: integer('bidding_id').references(() => biddings.id).notNull(), + biddingCompanyId: integer('bidding_company_id').references(() => biddingCompanies.id).notNull(), // 지급조건 paymentTerms: text('payment_terms'), // 지급조건 옵션들 (JSON 배열) @@ -299,7 +300,8 @@ export const biddingCompanies = pgTable('bidding_companies', { finalQuoteAmount: decimal('final_quote_amount', { precision: 15, scale: 2 }), finalQuoteSubmittedAt: timestamp('final_quote_submitted_at'), isWinner: boolean('is_winner').default(false), // 낙찰 여부 - + isAttendingMeeting: boolean('is_attending_meeting'), // 사양설명회 참석 여부 + // 기타 notes: text('notes'), // 특이사항 contactPerson: varchar('contact_person', { length: 100 }), // 업체 담당자 |