import {
pgTable,
text,
uuid,
boolean,
timestamp,
pgEnum,
varchar,
} from 'drizzle-orm/pg-core';
export const userRoleEnum = pgEnum('user_role', [
'user',
'admin',
'branch_manager',
'restaurant_owner',
]);
export const users = pgTable('users', {
id: uuid('id').notNull().defaultRandom().primaryKey(),
email: varchar('email', { length: 255 }).unique(),
phone: varchar('phone', { length: 20 }).notNull().unique(),
first_name: varchar('first_name', { length: 50 }),
last_name: varchar('last_name', { length: 50 }),
email_verified: boolean('email_verified').default(false),
phone_verified: boolean('phone_verified').default(false),
created_at: timestamp('created_at').notNull().defaultNow(),
role: userRoleEnum('role').notNull().default('user'),
password_hash: text('password_hash').notNull(),
});
import {
pgTable,
text,
uuid,
boolean,
timestamp,
pgEnum,
varchar,
} from 'drizzle-orm/pg-core';
export const userRoleEnum = pgEnum('user_role', [
'user',
'admin',
'branch_manager',
'restaurant_owner',
]);
export const users = pgTable('users', {
id: uuid('id').notNull().defaultRandom().primaryKey(),
email: varchar('email', { length: 255 }).unique(),
phone: varchar('phone', { length: 20 }).notNull().unique(),
first_name: varchar('first_name', { length: 50 }),
last_name: varchar('last_name', { length: 50 }),
email_verified: boolean('email_verified').default(false),
phone_verified: boolean('phone_verified').default(false),
created_at: timestamp('created_at').notNull().defaultNow(),
role: userRoleEnum('role').notNull().default('user'),
password_hash: text('password_hash').notNull(),
});