Prisma

Is there a way to set constraints on a model?

Given the following model
```model Follows {
  createdAt   DateTime @default(now())
  follower    User     @relation("follower", fields: [followerId], references: [id])
  followerId  Int
  following   User     @relation("following", fields: [followingId], references: [id])
  followingId Int

  @@id([followerId, followingId])
}```
I want make sure followerId and followingId can never be the same.

<@UL4GS5J7J> :wave:
You cannot set them on the model at the moment, but you can set them in your migration files.

It would be great if you could add a :thumbsup: to <https://github.com/prisma/prisma/issues/1604|this> request so that we can know the priority :slightly_smiling_face:

<@UESADRKMY> So edit the migration file that was just generated? `20211116063937_init/migration.sql`

No that would already have been applied. You would ideally do this in the following steps:
1. Create a migration using `prisma migrate dev --create-only`
2. Edit the generated `.sql` file and add the constraint
3. Apply the migration using `prisma migrate dev`

```ALTER TABLE follows
ADD CHECK (follower_id &lt;&gt; following_id);```
Works perfectly, thanks for the help <@UESADRKMY>