Shiba Bop
Shiba Bop
Explore posts from servers
SSolidJSDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Shiba Bop on 6/23/2024 in #help
Drizzle Kit studio error
When I visit studio page, it keeps showing the spinner and the console has There is not enough information to infer relation "__public__.users_table.sessions_tables_user_id" error. my schema: 
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()
});
2 replies