diff options
Diffstat (limited to 'db/schema/rfqLast.ts')
| -rw-r--r-- | db/schema/rfqLast.ts | 4 |
1 files changed, 3 insertions, 1 deletions
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 |