From 7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 27 Aug 2025 12:06:26 +0000 Subject: (대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/bidding.ts | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'db/schema/bidding.ts') 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 }), // 업체 담당자 -- cgit v1.2.3