schema.ts
For the full content of this gist, refer to https://gist.github.com/CodingAbdullah/e727d9dd1832c7e7daa0ced47cdc1608
McMaster. Software Engineer with a keen interest in blockchain and web3.
import { pgTable, text, timestamp, uuid } from 'drizzle-orm/pg-core';
// Exporting a table containing user properties
export const users = pgTable('users', {
id: uuid('id').primaryKey().defaultRandom(),
clerkUserId: text('clerk_user_id').notNull().unique(),
email: text('email').notNull().unique(),
firstName: text('first_name'),
lastName: text('last_name'),
createdAt: timestamp('created_at').defaultNow().notNull(),
updatedAt: timestamp('updated_at').defaultNow().notNull()
})
export type User = typeof users.$inferSelect;
export type NewUser = typeof users.$inferInsert;