(대표님) rfq-last 작업, vendorDocu 스키마 변경, 벤더 문서 관련 변경

1 files changed, 6 insertions, 1 deletions

diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 34cb7bf3..34c61cd0 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -169,9 +169,12 @@ export const rfqPrItems = pgTable(
         //   .references(() => items.id, { onDelete: "set null" }),
 
         materialCode: varchar("material_code", { length: 255 }),
-        materialCategory: varchar("material_category", { length: 255 }),
+        materialCategory: varchar("material_category", { length: 255 }),//자재그룹코드
+        
         acc: varchar("acc", { length: 255 }),
         materialDescription: varchar("material_description", { length: 255 }),
+
+
         size: varchar("size", { length: 255 }),
         deliveryDate: date("delivery_date", { mode: "date" })
             .$type<Date>(),
@@ -696,6 +699,8 @@ export type RfqsLastView = typeof rfqsLastView.$inferSelect;
 export type PrItemsLastView = typeof prItemsLastView.$inferSelect;
 export type RfqLastDetailsView = typeof rfqLastDetailsView.$inferSelect;
 
+export type RfqLastAttachments = typeof rfqLastAttachments.$inferSelect;
+
 
 export const rfqLastRelations = relations(
     rfqsLast,