Better AuthBA
Better Auth•9mo ago
Maqed

How to make two unique fields in a schema

So I'm trying to make a plugin with many to many relationship. I want it to have teamId and branchId columns. the combination of teamId & branchId must be unqiue, how can I achieve that?
schema: {
teamOnBranch: {
        fields: {
          teamId: {
            type: "string",
            required: true,
            references: {
              model: "team",
              field: "id",
            },
          },
          branchId: {
            type: "string",
            required: true,
            references: {
              model: "branch",
              field: "id",
            },
          },
          assignedAt: {
            type: "date",
            required: true,
          },
        },
      },
}

So I want the code snippet that results to the output in the prisma schema I sent (or any other ORM)
image.png
Was this page helpful?