export const appUsers = pgTable('app_users', {
id: bigint('id', { mode: 'number' })
.generatedByDefaultAsIdentity()
.primaryKey(),
user_id: uuid('user_id')
.references(() => authUsers.id, { onDelete: 'cascade' })
.notNull(),
phone: varchar('phone'),
email: varchar('email'),
phone_number_consented: boolean('phone_number_consented')
.notNull()
.default(false),
email_consented: boolean('email_consented').notNull().default(false),
created_at: timestamp('created_at').notNull().defaultNow(),
updated_at: timestamp('updated_at').notNull().defaultNow(),
user_initial_onboarding_complete: boolean('user_initial_onboarding_complete')
.notNull()
.default(false),
});
export const appUsers = pgTable('app_users', {
id: bigint('id', { mode: 'number' })
.generatedByDefaultAsIdentity()
.primaryKey(),
user_id: uuid('user_id')
.references(() => authUsers.id, { onDelete: 'cascade' })
.notNull(),
phone: varchar('phone'),
email: varchar('email'),
phone_number_consented: boolean('phone_number_consented')
.notNull()
.default(false),
email_consented: boolean('email_consented').notNull().default(false),
created_at: timestamp('created_at').notNull().defaultNow(),
updated_at: timestamp('updated_at').notNull().defaultNow(),
user_initial_onboarding_complete: boolean('user_initial_onboarding_complete')
.notNull()
.default(false),
});