From 60382940bac4ac8309be64be16f4774b6820df22 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 19 Nov 2025 17:44:48 +0900
Subject: (김준회) PR 데이터 수신시 Spec 정보도 넣어주도록 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/bidding.ts | 1 +
 db/schema/rfqLast.ts | 4 +++-
 2 files changed, 4 insertions(+), 1 deletion(-)

(limited to 'db')

diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts
index 1d1fe50a..8f9f8d84 100644
--- a/db/schema/bidding.ts
+++ b/db/schema/bidding.ts
@@ -336,6 +336,7 @@ export const prItemsForBidding = pgTable('pr_items_for_bidding', {
   
   // SPEC 파일 정보
   hasSpecDocument: boolean('has_spec_document').default(false),
+  specification: varchar('specification', { length: 2000 }), // Specification
   
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(),
diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 7ab03c30..10ec888a 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -1,4 +1,4 @@
-import {bigint, jsonb, decimal, json,index, pgTable, pgView, serial, varchar, text, timestamp, boolean, integer, numeric, date, alias, check, uniqueIndex, unique } from "drizzle-orm/pg-core";
+import {bigint, jsonb, decimal, json,index, pgTable, pgView, serial, varchar, text, timestamp, boolean, integer, numeric, date, alias, uniqueIndex, unique } from "drizzle-orm/pg-core";
 import { eq, sql, relations } from "drizzle-orm";
 import { projects } from "./projects";
 import { users } from "./users";
@@ -273,6 +273,7 @@ export const rfqPrItems = pgTable(
 
         specNo: varchar("spec_no", { length: 255 }),
         specUrl: varchar("spec_url", { length: 255 }),
+        specification: varchar("specification", { length: 2000 }),
         trackingNo: varchar("tracking_no", { length: 255 }),
 
         majorYn: boolean("major_yn").default(false),
@@ -657,6 +658,7 @@ export const prItemsLastView = pgView("pr_items_last_view").as((qb) => {
             // Specification
             specNo: rfqPrItems.specNo,
             specUrl: rfqPrItems.specUrl,
+            specification: rfqPrItems.specification,
             trackingNo: rfqPrItems.trackingNo,
 
             // Major flag
-- 
cgit v1.2.3