import {
pgTable,
text,
timestamp,
uuid,
varchar,
} from 'drizzle-orm/pg-core';
import { PDF_PARSE_STATUS } from '~/types';
export const UserResumeTable = pgTable('user_resumes', {
id: uuid('id').primaryKey().defaultRandom(),
filename: text('filename').notNull().unique(),
content: text('content'),
status: varchar('status')
.$type<PDF_PARSE_STATUS>()
.default(PDF_PARSE_STATUS.PENDING),
notes: text('notes'),
createdAt: timestamp('created_at', { withTimezone: true }).defaultNow(),
});
export const UserResume = UserResumeTable;
export type UserResume = typeof UserResumeTable.$inferSelect;
export type NewUserResume = typeof UserResumeTable.$inferInsert;
import {
pgTable,
text,
timestamp,
uuid,
varchar,
} from 'drizzle-orm/pg-core';
import { PDF_PARSE_STATUS } from '~/types';
export const UserResumeTable = pgTable('user_resumes', {
id: uuid('id').primaryKey().defaultRandom(),
filename: text('filename').notNull().unique(),
content: text('content'),
status: varchar('status')
.$type<PDF_PARSE_STATUS>()
.default(PDF_PARSE_STATUS.PENDING),
notes: text('notes'),
createdAt: timestamp('created_at', { withTimezone: true }).defaultNow(),
});
export const UserResume = UserResumeTable;
export type UserResume = typeof UserResumeTable.$inferSelect;
export type NewUserResume = typeof UserResumeTable.$inferInsert;