diff options
| author | joonhoekim <26rote@gmail.com> | 2025-11-19 17:44:48 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-11-19 17:44:48 +0900 |
| commit | 60382940bac4ac8309be64be16f4774b6820df22 (patch) | |
| tree | 976909a239b0712de59131ee10055735568447fc /db/schema | |
| parent | ec74a7862eb33a9da1e3d6ba2877d5b9662dbfca (diff) | |
(김준회) PR 데이터 수신시 Spec 정보도 넣어주도록 수정
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/bidding.ts | 1 | ||||
| -rw-r--r-- | db/schema/rfqLast.ts | 4 |
2 files changed, 4 insertions, 1 deletions
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 |