Hi is there any existing solution/workaround for this issue https://github.com/prisma/prisma/issues/6974
I have implemented soft delete functionality using deletedAt column(if deleted adds timestamp). Now I have unique key in the table. I need to add unique index only if deletedAt column is null
r
Ryan
09/06/2021, 5:19 AM
@Logesh Kumar Rajkumar 👋
You cannot define it in
schema.prisma
but I think Migrate should allow this. Have you tried adding it to the migration
.sql
file and check?
l
Logesh Kumar Rajkumar
09/06/2021, 7:25 AM
Hey Rayan, Thank you for replying. Yes currently I am achieving this via migration.