diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-08 10:29:19 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-08 10:29:19 +0000 |
| commit | f93493f68c9f368e10f1c3379f1c1384068e3b14 (patch) | |
| tree | a9dada58741750fa7ca6e04b210443ad99a6bccc /db/schema | |
| parent | e832a508e1b3c531fb3e1b9761e18e1b55e3d76a (diff) | |
(대표님, 최겸) rfqLast, bidding, prequote
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/bidding.ts | 7 | ||||
| -rw-r--r-- | db/schema/rfqLast.ts | 5 | ||||
| -rw-r--r-- | db/schema/rfqVendor.ts | 4 |
3 files changed, 9 insertions, 7 deletions
diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts index 710fb60d..9c623232 100644 --- a/db/schema/bidding.ts +++ b/db/schema/bidding.ts @@ -296,11 +296,14 @@ export const biddingCompanies = pgTable('bidding_companies', { preQuoteSubmittedAt: timestamp('pre_quote_submitted_at'), isPreQuoteSelected: boolean('is_pre_quote_selected').default(false), // 본입찰 대상 선정 여부 - // 본입찰 정보 + // 본입찰 정보 + isBiddingInvited: boolean('is_bidding_invited').default(false), // 본입찰 초대 여부 + isBiddingParticipated: boolean('is_bidding_participated'),//본입찰 참여 여부 finalQuoteAmount: decimal('final_quote_amount', { precision: 15, scale: 2 }), finalQuoteSubmittedAt: timestamp('final_quote_submitted_at'), - isWinner: boolean('is_winner').default(false), // 낙찰 여부 + isWinner: boolean('is_winner'), // 낙찰 여부 isAttendingMeeting: boolean('is_attending_meeting'), // 사양설명회 참석 여부 + awardRatio: decimal('award_ratio', { precision: 5, scale: 2 }), // 발주비율 // 기타 notes: text('notes'), // 특이사항 diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts index 95d2cc9b..56cc0c35 100644 --- a/db/schema/rfqLast.ts +++ b/db/schema/rfqLast.ts @@ -125,13 +125,12 @@ export const rfqLastDetails = pgTable( incotermsDetail: varchar("incoterms_detail", { length: 255 }), deliveryDate: date("delivery_date", { mode: "date" }) - .$type<Date>() - .notNull(), + .$type<Date>(), contractDuration: varchar("contract_duration", { length: 255 }), - taxCode: varchar("tax_code", { length: 255 }).default("VV"), + taxCode: varchar("tax_code", { length: 255 }), placeOfShipping: varchar("place_of_shipping", { length: 255 }), placeOfDestination: varchar("place_of_destination", { length: 255 }), remark: text("remark"), diff --git a/db/schema/rfqVendor.ts b/db/schema/rfqVendor.ts index e92b1e10..9d7b5fa8 100644 --- a/db/schema/rfqVendor.ts +++ b/db/schema/rfqVendor.ts @@ -30,9 +30,9 @@ export const rfqLastVendorResponses = pgTable( // 응답 상태 status: varchar("status", { length: 30 }) - .$type<"작성중" | "제출완료" | "수정요청" | "최종확정" | "취소">() + .$type<"초대됨" | "작성중" | "제출완료" | "수정요청" | "최종확정" | "취소">() .notNull() - .default("작성중"), + .default("초대됨"), // 제출 정보 submittedAt: timestamp("submitted_at"), |