i can't understand how relationships are supposed ...
# helpm
Muphet
12/13/2021, 4:45 PMi can't understand how relationships are supposed to work. how do i make a table rows reference user? i can't make foregin key because it requires to be unique, but it cannot be unique in my case
Muphet
12/13/2021, 5:08 PMmy problem is that i am trying to reference user's identity but it cannot be referenced. sure i can reference user.id but i want to pull user's oauth profile
Muphet
12/13/2021, 5:08 PMwhich already is saved in auth.identities
Muphet
12/13/2021, 5:09 PMeven if i set it as unique,
Muphet
12/13/2021, 5:13 PMor is it simply not possible to reference identities?
t
TremalJack
12/13/2021, 5:34 PMbio column is signed like primary?
m
Muphet
12/13/2021, 5:34 PMbio doesnt exist, i cannot even create column that references identities
Muphet
12/13/2021, 5:35 PMi found some info on github that identities are accessible only to logged in users so cannot even be accessed by 3rd party users, but i had no idea that supabase would lock it from itself
t
TremalJack
12/13/2021, 5:36 PMoh yes
TremalJack
12/13/2021, 5:36 PMsorry I saw now
TremalJack
12/13/2021, 5:36 PMu are wrong the way
TremalJack
12/13/2021, 5:36 PMI explain, the user_id column into identities is a text field not uuid
m
Muphet
12/13/2021, 5:36 PMi didnt set type, it was autofilled
t
TremalJack
12/13/2021, 5:37 PMif you want make a foreign key using uuid type then u have to use auth.users.id
TremalJack
12/13/2021, 5:37 PMbio
-type: uuid
foreign key on auth.users.id
m
Muphet
12/13/2021, 5:37 PMyeah but i dont want to reference user.id
Muphet
12/13/2021, 5:37 PMi need identities info
Muphet
12/13/2021, 5:38 PMlike github username and avatar
Muphet
12/13/2021, 5:38 PMfor example
Muphet
12/13/2021, 5:38 PMthat info is available in auth.identities
Muphet
12/13/2021, 5:38 PMbut it cannot be referenced
t
TremalJack
12/13/2021, 5:39 PMinside the table where u are trying to make the column bio do you have already some rows?
m
Muphet
12/13/2021, 5:39 PMnope
Muphet
12/13/2021, 5:39 PMim creating new table
t
TremalJack
12/13/2021, 5:42 PMok the error is the primary option on id
m
Muphet
12/13/2021, 5:42 PMbut if i do same on new column, its same error
t
TremalJack
12/13/2021, 5:43 PMyou have to disable the primary option if you want the id column has foreign key
m
Muphet
12/13/2021, 5:43 PMand also that
t
TremalJack
12/13/2021, 5:43 PMpersonally I don't make it on creation table, usually I made the table with columns I need and then I set the foreign keys
m
Muphet
12/13/2021, 5:43 PMi had no luck on existing tables either
Muphet
12/13/2021, 5:46 PMguess i will go different route - create profile, trigger function on insert, call api, fetch info, save to profile table.
but imo there really should be a way to reference identities
Muphet
12/13/2021, 6:54 PMbut this can be closed~