diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-27 12:06:26 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-27 12:06:26 +0000 |
| commit | 7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 (patch) | |
| tree | 8e66703ec821888ad51dcc242a508813a027bf71 /db/schema/bidding.ts | |
| parent | 7eac558470ef179dad626a8e82db5784fe86a556 (diff) | |
(대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련)
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 }), // 업체 담당자 |