From 6c11fccc84f4c84fa72ee01f9caad9f76f35cea2 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 16 Sep 2025 09:20:58 +0000 Subject: (대표님, 최겸) 계약, 업로드 관련, 메뉴처리, 입찰, 프리쿼트, rfqLast관련, tbeLast관련 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/bidding.ts | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'db/schema/bidding.ts') diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts index 9015026d..b2b21c33 100644 --- a/db/schema/bidding.ts +++ b/db/schema/bidding.ts @@ -73,9 +73,11 @@ export const awardCountEnum = pgEnum('award_count', [ export const invitationStatusEnum = pgEnum('invitation_status', [ 'pending', // 초대 대기 'sent', // 초대 발송 + 'bidding_invited', // 입찰 초대 'accepted', // 참여 수락 'declined', // 참여 거절 - 'submitted' // 견적 제출 완료 + 'submitted', // 견적 제출 완료 + 'bidding_submitted' // 입찰 제출 완료 ]) // 6. 문서 타입 enum @@ -122,7 +124,8 @@ export const biddings = pgTable('biddings', { biddingNumber: varchar('bidding_number', { length: 50 }).unique().notNull(), // 입찰 No. revision: integer('revision').default(0), // Rev. projectId: integer('project_id').references(() => projects.id), - + //견적에서 넘어온 레코드인지, 자체생산인지, 디폴트는 자체생산, notnull + biddingSourceType: varchar('bidding_source_type', { length: 20 }).notNull().default('manual'), // 기본 정보 projectName: varchar('project_name', { length: 300 }), // 프로젝트명 itemName: varchar('item_name', { length: 300 }), // 품목명 @@ -613,6 +616,7 @@ export const biddingListView = pgView('bidding_list_view').as((qb) => title: biddings.title, description: biddings.description, content: biddings.content, + biddingSourceType: biddings.biddingSourceType, isUrgent: biddings.isUrgent, // ═══════════════════════════════════════════════════════════════ -- cgit v1.2.3