!Original post
Rank 1: Thread
How do I create a relation from table y to an others x.$id.
in my example I have a users table where I use Appwrites unique User IDs
and I want other tables for other tasks, where every row needs to belong to one user ID
normally those type of relations should be supported simply so I could for example have an inbuilt on cascade,
but I couldn't explain myself how to use the database for that
Summary
Developers are having trouble creating relationships between tables in the database. They are struggling with the concept of column keys and how to represent related tables effectively. The developer also mentions limitations in using only letters for the column key. The recommended solution is to refer to the documentation provided by Appwrite on creating relationships in databases. Furthermore, the developer expresses confusion about creating a relation from table Y to table X.$id, specifically relating to using Appwrite's unique User IDs. They express a need for every row in other tables to belong to a user ID. The developer is looking for a way to simplify this process, ideally with support for features like