User.ts
For the full content of this gist, refer to https://gist.github.com/CodingAbdullah/19f38c44785add3d42b1bdd2eedd97a2
McMaster. Software Engineer with a keen interest in blockchain and web3.
import { pgTable, serial, text, timestamp } from "drizzle-orm/pg-core";
// Creating and exporting a User table schema
// Utilizing built-in functions for setting the attribute names, column conditions, constraints
export const Users = pgTable("Users", {
id: serial("id").primaryKey(),
name: text("name").notNull(),
email: text("email").notNull().unique(),
createdAt: timestamp("created_at").defaultNow()
});