1
Foreign key relations page
Source: supabase/supabase#636 · opened by @mbos2
Hello. While adding a foreign key relations between 2 tables, I get the message that FK relations will be added between those 2 tables. But, when I go to the schema I don't see any data about existing relation. It's like it doesn't exist, while in the background it might be there. UPDATE on upper part: I see that relations are currently not added between table 2 column and table 1 column that is not a primary key. In addition, could you add an index attribute for all other table columns (that would be optional) so those could be used for foreign key relations? Also, along with that, it would be nice to have whole section of a list of all FK relations between all tables. It could be as simple as this: Relations: table_one<column> - table_two<column> Those could also be links to open those columns for editing if needed. Furthermore there could be a button to add new relations, a form which would contain 4 fields. Same like when you add FK re…
No pledges yet. Be the first to back this.
Comments
Similar requests
Improve table editor UI for arrays of foreign keys (they aren't supported)
2 votes · 0 comments
postgrest-js: Need a way to identify one-to-one relation for better return-type deduction
2 votes · 0 comments
Default schema for Foreign Keys
1 vote · 0 comments
Have good support for Views with non-nullable foreign key relationships
1 vote · 0 comments
Improve Foreign Key Constraint Error UX in Table Editor
0 votes · 0 comments
No comments yet.