Foreign key with a column name that is not "id"

[theunreal]

I have the following expression inside createTable:

item_code: {
            type: 'varchar',
            notNull: true,
            references: '"items"',
            onDelete: 'cascade',
        },

Currently, it doesn't work because it references to items.id instead of items.item_code, after going over all docs - couldn't see any way to sett the name of the target column.

Am I missing something or this is a missing feature?

[mike-usa]

Am I missing something or this is a missing feature?

You can do this by overriding the references value string:

item_code: {
  type: 'varchar',
  notNull: true,
  references: 'items(item_code)',
  onDelete: 'cascade',
}

Note: items.item_code must be a constraint on your items table and share the same datatype; in your case a varchar.

---

Ordinarily, you could also pass a Name object to references:

references: {
  schema: 'public',
  name: 'items'
}

I was perusing the TypeScript code to see if it would accept any other keys, but it doesn't. It looks like expanding the Name object to include column (string)/columns (comma-delimited string or array of strings) may be worthwhile. Then, in a later breaking change, the name key should be renamed to table.