export const appSchema = pgSchema(process.env.SECURE_DB_SCHEMA);
export const userTable = pgTable('users_table', {
id: text('id').notNull().primaryKey(),
name: text('name').notNull(),
email: text('email').notNull().unique(),
password_hash: text('password_hash').notNull()
});
export const sessionTable = appSchema.table('sessions_table', {
id: text('id').primaryKey(),
userId: text('user_id')
.notNull()
.references(() => userTable.id),
expiresAt: timestamp('expires_at', {
withTimezone: true,
mode: 'date'
}).notNull()
});
export const appSchema = pgSchema(process.env.SECURE_DB_SCHEMA);
export const userTable = pgTable('users_table', {
id: text('id').notNull().primaryKey(),
name: text('name').notNull(),
email: text('email').notNull().unique(),
password_hash: text('password_hash').notNull()
});
export const sessionTable = appSchema.table('sessions_table', {
id: text('id').primaryKey(),
userId: text('user_id')
.notNull()
.references(() => userTable.id),
expiresAt: timestamp('expires_at', {
withTimezone: true,
mode: 'date'
}).notNull()
});