export const authUser = sqliteTable("auth_user", {
id: text("id").notNull().primaryKey(),
email: text("email").notNull().unique(),
firstName: text("first_name").notNull(),
lastName: text("last_name").notNull(),
role: text("role").notNull(), // unassigned, office, construction
verified: integer("verified", { mode: "boolean" }).notNull(),
manager: text("user_id").references(() => authUser.id),
});
export const authUser = sqliteTable("auth_user", {
id: text("id").notNull().primaryKey(),
email: text("email").notNull().unique(),
firstName: text("first_name").notNull(),
lastName: text("last_name").notNull(),
role: text("role").notNull(), // unassigned, office, construction
verified: integer("verified", { mode: "boolean" }).notNull(),
manager: text("user_id").references(() => authUser.id),
});