Title: [Feature]: Support composite foreign keys when editing table definition in the UI · Issue #4100 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: [Feature]: Support composite foreign keys when editing table definition in the UI · Issue #4100 · sqlitebrowser/sqlitebrowser
X Title: [Feature]: Support composite foreign keys when editing table definition in the UI · Issue #4100 · sqlitebrowser/sqlitebrowser
Description: Describe the new feature Hello, SQLite supports composite foreign keys if the destination table's columns form a composite key or have a uniqueness constraint applied. When creating a table through the UI, I'm surprised that I can't set ...
Open Graph Description: Describe the new feature Hello, SQLite supports composite foreign keys if the destination table's columns form a composite key or have a uniqueness constraint applied. When creating a table through...
X Description: Describe the new feature Hello, SQLite supports composite foreign keys if the destination table's columns form a composite key or have a uniqueness constraint applied. When creating a table thr...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/4100
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Feature]: Support composite foreign keys when editing table definition in the UI","articleBody":"### Describe the new feature\n\nHello,\n\nSQLite supports [composite foreign keys](https://sqlite.org/foreignkeys.html#fk_composite) if the destination table's columns form a composite key or have a uniqueness constraint applied.\n\nWhen creating a table through the UI, I'm surprised that I can't set up this relationship, and can only choose single columns when creating a foreign key, especially when I can pick multiple columns from my source table.\n\nIt would be nice to support this in the UI, and to not be misleading when editing an existing composite foreign key relationship in the UI.\n\nMy screenshots use version 3.13.1 on Windows.\n\nThanks.\n\n### Does this feature exist in another product or project? Please provide a link\n\n_No response_\n\n### Do you have a screenshot? Please add screenshots to help explain your idea.\n\nCreating a `Parent` table (all fine here):\n\n\u003cimg width=\"996\" height=\"785\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/cff608c6-e6ce-45c3-ae94-1b3870e9c92f\" />\n\nCreating a `Child` table and attempting to add a composite foreign key, but you can only pick one column:\n\n\u003cimg width=\"999\" height=\"781\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/24087eeb-d869-4120-ba16-bcbb561db5d8\" />\n\nEditing a `Child` table that was created with a composite foreign key through SQL, where it gets in a muddle on editing:\n\n\u003cimg width=\"994\" height=\"781\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/ceb21d00-6636-4496-8927-6bd06d502d77\" />","author":{"url":"https://github.com/TomReddington","@type":"Person","name":"TomReddington"},"datePublished":"2026-02-28T13:47:06Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/4100"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:ade9a76f-b889-2440-41cf-1e9f171daf6b |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9242:1F8AF1:3D9CFC:54F6C1:6AFCB20B |
| html-safe-nonce | dcbf696de88fda4686aa40c3149283ef5f391453d4f76ca49233d0e7b950d907 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5MjQyOjFGOEFGMTozRDlDRkM6NTRGNkMxOjZBRkNCMjBCIiwidmlzaXRvcl9pZCI6IjMyOTMyNDgxNDAxMzM0NjMxNSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | b08c48fcc7cb31d32b9d080c3e7632d897b6f075f8e7e025419d985052fa27f5 |
| hovercard-subject-tag | issue:4004689927 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/4100/issue_layout |
| twitter:image | https://opengraph.githubassets.com/2eefdda5d8b8017577c7923b210fcb1bd810445fad3afee13ac1fc1be450e7e9/sqlitebrowser/sqlitebrowser/issues/4100 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/2eefdda5d8b8017577c7923b210fcb1bd810445fad3afee13ac1fc1be450e7e9/sqlitebrowser/sqlitebrowser/issues/4100 |
| og:image:alt | Describe the new feature Hello, SQLite supports composite foreign keys if the destination table's columns form a composite key or have a uniqueness constraint applied. When creating a table through... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | TomReddington |
| hostname | github.com |
| expected-hostname | github.com |
| None | e3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5410e4bebd3e45b138c853ecef3992279d86d5af |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width