Better AuthBA
Better Auth•8mo ago
Kinan

How to configure custom ID column names (e.g., id_user, id_session) ?

Hello everyone,

I'm trying to customize the ID column names in my database schema. By default, better-auth uses 
id
 for the user table, 
id
 for the session table, etc. I'd like to use id_user, id_session, etc., instead.

I attempted to configure this in the 
auth.ts
 file like this :

export const auth = betterAuth({
    database: drizzleAdapter(db, {
        provider: "pg",
        schema: schema,
    }),
    // ... other configurations ...

    /* BA Core schema change */
    user: {
        fields: {
            // Trying to map the internal 'id' field to my 'id_user' column
            id_user: "id_user" // <-- This is where I'm attempting the configuration
        },
        additionalFields: {
            first_name: {
                type: "string",
                required: true,
            },
        },
    },
});


However, I'm getting the following TypeScript error on the id_user: "id_user" line:

Object literal may only specify known properties, and 'id_user' does not exist in type 'Partial<Record<"name" | "email" | "emailVerified" | "createdAt" | "updatedAt" | "image", string>>'.


It seems the fields property only allows mapping predefined fields like 
name
, 
email
, etc., but not the 
id
 field itself.

Is it possible to configure better-auth to use custom ID column names like id_user?

Thanks in advance for your help!
Was this page helpful?