ALESSIO
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
@Nurul
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
If you want we can arrange a discord call and discuss about this, this might be a not so rare case
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
the id of contents table is different for every row, this means that the same challenge must have more records for the same same challenge in order to reference a different content id every time.
With the non unique content _id i can have multiple languages for the same text and only get the text based by the client locale
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
And may i asked to be pinged when replied? I will reply back much faster, thank you for your help anyway
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
So that i can query the correct text by content_id and the client's language
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
@Nurul (Prisma) content_id is not unique, because the same content_id has more languages like this:
id content_id language content
1 1 en hello
2 1 it ciao
3 1 es hola
14 replies
PPrisma
•Created by ALESSIO on 4/24/2025 in #help-and-questions
Relations on non unique fields
Prisma AI, i can't use both solution 1 or 2
14 replies