(Prisma Dashboard) Error adding foreign key: foreign key constraint "category_category_fkey" cannot be implemented

[borngraced]

I can't seem to add an array column to table with foreign key from prisma dashboard. it return the error

Error adding foreign key: foreign key constraint "category_category_fkey" cannot be implemented

and if I try to use do it through Prisma the output on supabase is worse.

Please advice. thanks