Unique constraint on multiple fields/columns

export const subgroups = mysqlTable("subgroup", {
  id: serial("id").primaryKey(),
  groupId: text("groupId").notNull(),
  slug: text("slug").notNull(), // I'd like this to be unique, but not in the entire table, only unique within the subgroups related to `groupId`
});

export const subgroupsRelations = relations(
  subgroups,
  ({ one, many }) => ({
    group: one(groups, {
      fields: [subgroups.groupId],
      references: [groups.id],
    }),
  })
);

export const subgroups = mysqlTable("subgroup", {
  id: serial("id").primaryKey(),
  groupId: text("groupId").notNull(),
  slug: text("slug").notNull(), // I'd like this to be unique, but not in the entire table, only unique within the subgroups related to `groupId`
});

export const subgroupsRelations = relations(
  subgroups,
  ({ one, many }) => ({
    group: one(groups, {
      fields: [subgroups.groupId],
      references: [groups.id],
    }),
  })
);

const validResult = [ // ✅
  {
    id: '123',
    groupId: '456', // Different group ID
    slug: 'abc', // Same slug
  },
  {
    id: '123',
    groupId: '789', // Different group ID
    slug: 'abc', // Same slug
  }
]

const invalidResult = [ // ❌
  {
    id: '123',
    groupId: '456', // Same group ID
    slug: 'abc', // Same slug
  },
  {
    id: '123',
    groupId: '456', // Same group ID
    slug: 'abc', // Same slug
  }
]

const validResult = [ // ✅
  {
    id: '123',
    groupId: '456', // Different group ID
    slug: 'abc', // Same slug
  },
  {
    id: '123',
    groupId: '789', // Different group ID
    slug: 'abc', // Same slug
  }
]

const invalidResult = [ // ❌
  {
    id: '123',
    groupId: '456', // Same group ID
    slug: 'abc', // Same slug
  },
  {
    id: '123',
    groupId: '456', // Same group ID
    slug: 'abc', // Same slug
  }
]