diff options
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"), |