No support for Drizzle ORM multi-column foreign keys

[g30r93g]

Self Checks

• This is only for bug report, if you would like to ask a question, please head to Discussions.
• I have searched for existing issues search for existing issues, including closed ones.

Version Type

CLI Version (npm package)

Version (only for Self Hosted)

No response

Steps to reproduce

1. Create a Drizzle ORM schema that uses foreignKey instead of .references()

import { primaryKey, serial, foreignKey, pgTable, text } from "drizzle-orm/pg-core";

export const user = pgTable("user", {
  firstName: text("firstName"),
  lastName: text("lastName"),
}, (table) => [
  primaryKey({ columns: [table.firstName, table.lastName]})
]);
export const profile = pgTable("profile", {
  id: serial("id").primaryKey(),
  userFirstName: text("user_first_name"),
  userLastName: text("user_last_name"),
}, (table) => [
  foreignKey({
    columns: [table.userFirstName, table.userLastName],
    foreignColumns: [user.firstName, user.lastName],
    name: "custom_fk"
  })
]);

2. Run npx @liam-hq/cli erd build --format drizzle --input ./db/sample-schema.ts
3. Observe lack of crows feet denoting relations, and missing relationship properties

It also seems to miss the composite primary key in the user table.

Expected Behavior

1. Detect usage of operators such as foreignKey, primaryKey
2. Apply logic as it otherwise would for .references()

Actual Behavior

No acknowledgement of foreignKey or primaryKey operators

Additional Context

https://orm.drizzle.team/docs/indexes-constraints#foreign-key

[diaz3618]

Implemented support for the foreignKey() table-level operator in the Drizzle parser (applied locally, not yet PR'd).

Types (postgres/types.ts, mysql/types.ts):

• Added CompositeForeignKeyDefinition type with columns, foreignTable, foreignColumns, name, onDelete, onUpdate fields
• Added foreignKeys?: CompositeForeignKeyDefinition[] to DrizzleTableDefinition
• Added isCompositeForeignKey() type guard

Parser (postgres/tableParser.ts, mysql/tableParser.ts):

• Added parseForeignKeyDefinition() to parse foreignKey({ columns: [...], foreignColumns: [...] }) calls
• Added parseForeignKeyWithChain() to handle .onDelete() / .onUpdate() method chains
• Integrated into third-arg parsing for both object syntax (v0) and array syntax (v1)

Converter (postgres/converter.ts, mysql/converter.ts):

• Added composite FK conversion to ForeignKeyConstraint entries with proper column name resolution

Tests: 7 new test cases (run across both PostgreSQL and MySQL = 14 total) covering single-column FK, named constraints, cascade actions, two-column composite FKs, array syntax, and mixed extras.

All 569/569 tests pass (previously 555).