How does supabase retrieve foreign table relationships?

I am using supabase nextjs stripe payments project and I came across this line of code:

  const { data, error } = await supabase
    .from('products')
    .select('*, prices(*)')
    .eq('active', true)
    .eq('prices.active', true)
    .order('metadata->index')
    .order('unit_amount', { foreignTable: 'prices' });

  const { data, error } = await supabase
    .from('products')
    .select('*, prices(*)')
    .eq('active', true)
    .eq('prices.active', true)
    .order('metadata->index')
    .order('unit_amount', { foreignTable: 'prices' });

  const { data, error } = await supabase
    .from('products')
    .select('*, prices(*)')
    .eq('active', true)
    .eq('prices.active', true)
    .order('metadata->index')
    .order('unit_amount', { foreignTable: 'prices' });

  const { data, error } = await supabase
    .from('products')
    .select('*, prices(*)')
    .eq('active', true)
    .eq('prices.active', true)
    .order('metadata->index')
    .order('unit_amount', { foreignTable: 'prices' });

Everything works, but how does it connect products with matching rows in the prices table? Products table itself has no

prices

prices

prices

prices column. Prices table do have

product_id

product_id

product_id

product_id column, but how does it know automatically what to connect since we only wrote

.select('*, prices(*)')

.select('*, prices(*)')

.select('*, prices(*)')

.select('*, prices(*)') .

I would have imagined that we had to write something like

connect('prices').where('product_id).eq('id')

connect('prices').where('product_id).eq('id')

connect('prices').where('product_id).eq('id')

connect('prices').where('product_id).eq('id'), but it seems like it does this automatically?

How does supabase retrieve foreign table relationships?

Similar Threads

Similar Threads

Similar Threads