inverted relations ui

[111100001]

took me a long time to set up a relationship because i wanted to reference the pk of users table as an fk to accounts table. the reason it was confusing is because the ui says "source" which i thought is the source of the reference which is users table and destination is the accounts table,

but that gave me an error and decided maybe i should reverse it and it worked

[aleluff]

So you suggest to invert source and destination? Maybe a reword because majority of users use source as the parent / referencing.

Gemini propose me referencing / parent

What's your opinion about it ?

[111100001]

yes exactly.

On Sat, Nov 16, 2024, 10:47 PM Alexandre Biche @.***> wrote:

So you suggest to invert source and destination? Maybe a reword because majority of users use source as the parent / referencing.

Gemini propose me referencing / parent

What's your opinion about it ?

— Reply to this email directly, view it on GitHub https://github.com/WebDB-App/app/issues/46#issuecomment-2480757301, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFY3LT3BTYJ4VBWYXF42ZRD2A6ONDAVCNFSM6AAAAABR43FIYCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBQG42TOMZQGE . You are receiving this because you authored the thread.Message ID: @.***>

[aleluff]

So which one : referencing or parent The destination would be referenced or child

[aleluff]

I would go for parent / child

The problem with reference(d/ing) is the word is to close and too long

Good for you ?

[111100001]

parent child is more easily understood imo

but i dont know the standard naming in the DB community. i was just doing my school project

[aleluff]

Dam, Postgre use parent child for another feature ... I will go with table, column, referenced table, referenced column This terminology comes from MySQL and is the best compromise in my opinion

[aleluff]

Pushed. I let you close the issue once validated