diff options
| author | joonhoekim <26rote@gmail.com> | 2025-12-01 19:54:27 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-12-01 19:54:27 +0900 |
| commit | 4b5880064e2362baf85c91f33b2b44baecea3a7f (patch) | |
| tree | 24b48163ecbf205023fcd565b0476a30e3079a9f /db/schema/rfqLast.ts | |
| parent | 44b74ff4170090673b6eeacd8c528e0abf47b7aa (diff) | |
| parent | cd0ce0cbe8af8719a6f542098ec78f2a5c1222ce (diff) | |
Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkim
Diffstat (limited to 'db/schema/rfqLast.ts')
| -rw-r--r-- | db/schema/rfqLast.ts | 20 |
1 files changed, 20 insertions, 0 deletions
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, |