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