diff options
Diffstat (limited to 'db/schema/rfqLast.ts')
| -rw-r--r-- | db/schema/rfqLast.ts | 7 |
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, |