how can i make a relationship between a column in a table and $id in auth.users?

i want to relate the $id from users auth table in appwrite with other column in my table user_profile.
because is the same user...

how can i have exactly the same id for both tables?

We cant do this actually
One of the easiest ways would be via auth events

Whenever a new user is created, shoot a function that copies the data into the table

Or one more way , since we support transactions now and we know transactions are atomic

So I would follow this but can be counter intuitive as well but db and auth would be totally in sync

1. transaction block
2. db operation with a custom id for the user table
3. Use the same id in the auth creation
4. If auth fails db will not commit your result since inside a transaction block

A bit counter intuitive as auth should be the source of truth and not database but we are doing db operation first. But it will work reliably

nice!!!, well at least there's a way to achieve that.

because the problem with auth.users is that assume a solid shape for users.
and in the other hand, if you create your own user table, you lose built-in features of auth.users table :p