diff options
Diffstat (limited to 'db/schema/bidding.ts')
| -rw-r--r-- | db/schema/bidding.ts | 8 |
1 files changed, 6 insertions, 2 deletions
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, // ═══════════════════════════════════════════════════════════════ |