{message: 'Could not find a relationship between chats and user_id in the schema cache', hint: 'If a new foreign key between these entities was cr… in the database, try reloading the schema cache.'}hint: "If a new foreign key between these entities was created in the database, try reloading the schema cache."message: "Could not find a relationship between chats and user_id in the schema cache" Is there anybody who is having this problem on relational tables?

What's the request you're doing? (pls share a code snippet)

I have a realation ship between public and auth schema. Chats table in the public and it has relation with users. Trying to fetch chats with selection users but it gives this error.

The

auth.users

table is not exposed through the API, as it's private.

So should I do create profile table in the public schema?

Some idea here maybe https://egghead.io/lessons/supabase-add-relationships-between-tables-in-supabase-using-foreign-keys