export const contacts = createTable(
"contacts",
{
email: varchar("email")
//
.primaryKey(),
first_name: varchar("first_name"),
last_name: varchar("last_name"),
phone_number: varchar("phone_number")
//
.unique(),
created_at: timestamp("created_at", { withTimezone: true })
//
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
},
(table) => ({
phone_number: check("phone_number_check", sql`LENGTH(${table.phone_number}) >= 10`),
}),
);
export const contacts = createTable(
"contacts",
{
email: varchar("email")
//
.primaryKey(),
first_name: varchar("first_name"),
last_name: varchar("last_name"),
phone_number: varchar("phone_number")
//
.unique(),
created_at: timestamp("created_at", { withTimezone: true })
//
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
},
(table) => ({
phone_number: check("phone_number_check", sql`LENGTH(${table.phone_number}) >= 10`),
}),
);