import { pgEnum, pgTable as table } from "drizzle-orm/pg-core";
import * as t from "drizzle-orm/pg-core";
import { createInsertSchema, createSelectSchema } from "drizzle-zod";
export const customers = table(
"customers",
{
id: t.bigint({ mode: "number" }).primaryKey().generatedAlwaysAsIdentity(),
email: t.text("email").notNull().unique(),
firstName: t.text("first_name"),
lastName: t.text("last_name"),
state: t.text("state"),
verifiedEmail: t.boolean("verified_email"),
phone: t.text("phone"),
tags: t.text("tags"),
currency: t.text("currency"),
createdAt: t.timestamp("created_at").defaultNow(),
updatedAt: t.timestamp("updated_at").defaultNow(),
},
(tble) => {
return {
emailIndex: t.uniqueIndex("email_idx").on(tble.email),
};
}
);
import { pgEnum, pgTable as table } from "drizzle-orm/pg-core";
import * as t from "drizzle-orm/pg-core";
import { createInsertSchema, createSelectSchema } from "drizzle-zod";
export const customers = table(
"customers",
{
id: t.bigint({ mode: "number" }).primaryKey().generatedAlwaysAsIdentity(),
email: t.text("email").notNull().unique(),
firstName: t.text("first_name"),
lastName: t.text("last_name"),
state: t.text("state"),
verifiedEmail: t.boolean("verified_email"),
phone: t.text("phone"),
tags: t.text("tags"),
currency: t.text("currency"),
createdAt: t.timestamp("created_at").defaultNow(),
updatedAt: t.timestamp("updated_at").defaultNow(),
},
(tble) => {
return {
emailIndex: t.uniqueIndex("email_idx").on(tble.email),
};
}
);