diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/bidding.ts | 1 | ||||
| -rw-r--r-- | db/schema/rfqLast.ts | 20 |
2 files changed, 21 insertions, 0 deletions
diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts index cc79f482..c08ea921 100644 --- a/db/schema/bidding.ts +++ b/db/schema/bidding.ts @@ -156,6 +156,7 @@ export const biddings = pgTable('biddings', { biddingSourceType: varchar('bidding_source_type', { length: 20 }).notNull().default('manual'), // 기본 정보 projectName: varchar('project_name', { length: 300 }), // 프로젝트명 + projectCode: varchar('project_code', { length: 100 }), // 프로젝트 코드 (새로 추가) itemName: varchar('item_name', { length: 300 }), // 품목명 title: varchar('title', { length: 300 }).notNull(), // 입찰명 description: text('description'), diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts index 2f2a6710..325942f4 100644 --- a/db/schema/rfqLast.ts +++ b/db/schema/rfqLast.ts @@ -83,6 +83,13 @@ export const rfqsLast = pgTable( rfqType: varchar("rfq_type", { length: 255 }), rfqTitle: varchar("rfq_title", { length: 255 }), + // 입찰 사전견적 추가 필드 + biddingNumber: varchar("bidding_number", { length: 50 }), + contractStartDate: date("contract_start_date", { mode: "date" }) + .$type<Date | null>(), + contractEndDate: date("contract_end_date", { mode: "date" }) + .$type<Date | null>(), + //ITB 추가 필드 projectCompany: varchar("project_company", { length: 255 }), projectFlag: varchar("project_flag", { length: 255 }), @@ -309,6 +316,11 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => { rfqType: sql<string | null>`${rfqsLast.rfqType}`.as("rfq_type"), rfqTitle: sql<string | null>`${rfqsLast.rfqTitle}`.as("rfq_title"), + // 입찰 사전견적 추가 필드 + biddingNumber: sql<string | null>`${rfqsLast.biddingNumber}`.as("bidding_number"), + contractStartDate: sql<Date | null>`${rfqsLast.contractStartDate}`.as("contract_start_date"), + contractEndDate: sql<Date | null>`${rfqsLast.contractEndDate}`.as("contract_end_date"), + // ITB 관련 필드 projectCompany: sql<string | null>`${rfqsLast.projectCompany}`.as("project_company"), projectFlag: sql<string | null>`${rfqsLast.projectFlag}`.as("project_flag"), @@ -480,6 +492,11 @@ export const rfqLastDetailsView = pgView("rfq_last_details_view").as((qb) => { rfqType: sql<string | null>`${rfqsTable.rfqType}`.as("rfq_type"), rfqTitle: sql<string | null>`${rfqsTable.rfqTitle}`.as("rfq_title"), + // 입찰 사전견적 추가 필드 + biddingNumber: sql<string | null>`${rfqsTable.biddingNumber}`.as("bidding_number"), + contractStartDate: sql<Date | null>`${rfqsTable.contractStartDate}`.as("contract_start_date"), + contractEndDate: sql<Date | null>`${rfqsTable.contractEndDate}`.as("contract_end_date"), + // ITB 관련 정보 projectCompany: sql<string | null>`${rfqsTable.projectCompany}`.as("project_company"), projectFlag: sql<string | null>`${rfqsTable.projectFlag}`.as("project_flag"), @@ -677,6 +694,9 @@ export const prItemsLastView = pgView("pr_items_last_view").as((qb) => { rfqCode: rfqsLast.rfqCode, rfqType: rfqsLast.rfqType, rfqTitle: rfqsLast.rfqTitle, + biddingNumber: rfqsLast.biddingNumber, + contractStartDate: rfqsLast.contractStartDate, + contractEndDate: rfqsLast.contractEndDate, itemCode: rfqsLast.itemCode, itemName: rfqsLast.itemName, prNumber: rfqsLast.prNumber, |