Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create self-referencing foreign keys during table creation #8221

Open
Jacob-P-Busby opened this issue Dec 2, 2024 · 1 comment
Open

Create self-referencing foreign keys during table creation #8221

Jacob-P-Busby opened this issue Dec 2, 2024 · 1 comment
Labels

Comments

@Jacob-P-Busby
Copy link

Right now, during the creation of a table you can add the foreign key constraint to columns within your table. While this works for foreign keys that reference other tables, you are unable to a column within the table being created. This would be useful for when a parent-child relationship is needed, such as a nested comment or a manager and employees, where different columns would link with each other

Right now you need to create the table and add the constraints afterwards, this would be a simple QOL feature

@yogeshmahajan-1903
Copy link
Contributor

yogeshmahajan-1903 commented Dec 6, 2024

To refer the table that is being created, add dropdown item like <self>.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: No status
Development

No branches or pull requests

2 participants