diff options
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 |