2025.3.26.1533

1 files changed, 20 insertions, 0 deletions

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