DT
Drizzle Team•12mo ago
Gabriel

disambiguate foreign key relations

Help, I need to understand something: 
export const team = mysqlTable(
  "Team",
  {
    id: varchar("id", { length: 191 }).notNull().primaryKey(),
    ownerId: varchar("ownerId", { length: 191 })
      .notNull()
      .references(() => user.id),
  },
  (table) => {
    return {
      ownerIdIdx: index("Team_ownerId_idx").on(table.ownerId),
    };
  },
);

export const user = mysqlTable("User", {
  id: varchar("id", { length: 191 }).notNull().primaryKey(),
  activeTeamId: varchar("activeTeamId", { length: 191 })
    .notNull()
    .references(() => team.id),
});
export const team = mysqlTable(
  "Team",
  {
    id: varchar("id", { length: 191 }).notNull().primaryKey(),
    ownerId: varchar("ownerId", { length: 191 })
      .notNull()
      .references(() => user.id),
  },
  (table) => {
    return {
      ownerIdIdx: index("Team_ownerId_idx").on(table.ownerId),
    };
  },
);

export const user = mysqlTable("User", {
  id: varchar("id", { length: 191 }).notNull().primaryKey(),
  activeTeamId: varchar("activeTeamId", { length: 191 })
    .notNull()
    .references(() => team.id),
});
This is giving me an error on team.id references and user.id references. I need to somehow disambiguate these relations I think but couldnt figure out how to do it. Drizzle has some info about disambiguation here: https://orm.drizzle.team/docs/rqb#disambiguating-relations But this is mainly for relations() functions where we dont specify actual fk constraints.
No description
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?