diff options
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/bidding.ts | 21 |
1 files changed, 13 insertions, 8 deletions
diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts index b2b21c33..fbc620c8 100644 --- a/db/schema/bidding.ts +++ b/db/schema/bidding.ts @@ -137,7 +137,11 @@ export const biddings = pgTable('biddings', { contractType: contractTypeEnum('contract_type').notNull(), // 계약구분 biddingType: biddingTypeEnum('bidding_type').notNull(), // 입찰유형 awardCount: awardCountEnum('award_count').default('single'), // 낙찰수 - contractPeriod: varchar('contract_period', { length: 100 }), // 계약기간 + // contractPeriod: varchar('contract_period', { length: 100 }), // 계약기간 + //시작일 + contractStartDate: date('contract_start_date'), + //종료일 + contractEndDate: date('contract_end_date'), // 일정 관리 preQuoteDate: date('pre_quote_date'), // 사전견적일 @@ -264,22 +268,22 @@ export const biddingConditions = pgTable('bidding_conditions', { biddingId: integer('bidding_id').references(() => biddings.id).notNull(), // 지급조건 - paymentTerms: text('payment_terms'), // 지급조건 옵션들 (JSON 배열) + paymentTerms: text('payment_terms'), // 지급조건 옵션들 // 세금 - taxConditions: text('tax_conditions'), // Tax 옵션들 (JSON 배열) + taxConditions: text('tax_conditions'), // Tax 옵션들 // 계약 및 납기 contractDeliveryDate: date('contract_delivery_date'), // 계약납기일 isPriceAdjustmentApplicable: boolean('is_price_adjustment_applicable'), // 연동제적용 여부 // 무역조건 - incoterms: text('incoterms'), // Incoterms 옵션들 (JSON 배열) + incoterms: text('incoterms'), // Incoterms 옵션들 shippingPort: varchar('shipping_port', { length: 200 }), // 선적지 - destinationPort: varchar('destination_port', { length: 200 }), // 도착지 + destinationPort: varchar('destination_port', { length: 200 }), // 하역지 // 기타 - sparePartOptions: text('spare_part_options'), // Spare part 옵션들 (JSON 배열) + sparePartOptions: text('spare_part_options'), // Spare part 옵션들 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -362,7 +366,7 @@ export const companyConditionResponses = pgTable('company_condition_responses', // 무역조건 응답 incotermsResponse: varchar('incoterms_response', { length: 100 }), // 선택된 Incoterms proposedShippingPort: varchar('proposed_shipping_port', { length: 200 }), // 제안 선적지 - proposedDestinationPort: varchar('proposed_destination_port', { length: 200 }), // 제안 도착지 + proposedDestinationPort: varchar('proposed_destination_port', { length: 200 }), // 제안 하역지 // 기타 응답 sparePartResponse: varchar('spare_part_response', { length: 200 }), // Spare part 응답 @@ -625,7 +629,8 @@ export const biddingListView = pgView('bidding_list_view').as((qb) => contractType: biddings.contractType, biddingType: biddings.biddingType, awardCount: biddings.awardCount, - contractPeriod: biddings.contractPeriod, + contractStartDate: biddings.contractStartDate, + contractEndDate: biddings.contractEndDate, // ═══════════════════════════════════════════════════════════════ // 일정 관리 |