From 6f4110be95c83b18e223c8d662d68c675364c74e Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 26 Mar 2025 06:33:14 +0000 Subject: 2025.3.26.1533 --- db/schema/vendorData.ts | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'db/schema/vendorData.ts') diff --git a/db/schema/vendorData.ts b/db/schema/vendorData.ts index f7baa883..92a92c8e 100644 --- a/db/schema/vendorData.ts +++ b/db/schema/vendorData.ts @@ -203,3 +203,23 @@ export const viewTagSubfields = pgTable("view_tag_subfields", { }) export type ViewTagSubfields = typeof viewTagSubfields.$inferSelect + +export const vendorDataReportTemps = pgTable("vendor_data_report_temps", { + id: serial("id").primaryKey(), + contractItemId: integer("contract_item_id") + .notNull() + .references(() => contractItems.id, { onDelete: "cascade" }), + formId: integer("form_id") + .notNull() + .references(() => forms.id, { onDelete: "cascade" }), + fileName: varchar("file_name", { length: 255 }).notNull(), + filePath: varchar("file_path", { length: 1024 }).notNull(), + createdAt: timestamp("created_at", { withTimezone: true }) + .defaultNow() + .notNull(), + updatedAt: timestamp("updated_at", { withTimezone: true }) + .defaultNow() + .notNull(), + }); + + export type VendorDataReportTemps = typeof vendorDataReportTemps.$inferSelect; \ No newline at end of file -- cgit v1.2.3