René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:ade9a76f-b889-2440-41cf-1e9f171daf6b
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id9242:1F8AF1:3D9CFC:54F6C1:6AFCB20B
html-safe-noncedcbf696de88fda4686aa40c3149283ef5f391453d4f76ca49233d0e7b950d907
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5MjQyOjFGOEFGMTozRDlDRkM6NTRGNkMxOjZBRkNCMjBCIiwidmlzaXRvcl9pZCI6IjMyOTMyNDgxNDAxMzM0NjMxNSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacb08c48fcc7cb31d32b9d080c3e7632d897b6f075f8e7e025419d985052fa27f5
hovercard-subject-tagissue:4004689927
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/4100/issue_layout
twitter:imagehttps://opengraph.githubassets.com/2eefdda5d8b8017577c7923b210fcb1bd810445fad3afee13ac1fc1be450e7e9/sqlitebrowser/sqlitebrowser/issues/4100
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/2eefdda5d8b8017577c7923b210fcb1bd810445fad3afee13ac1fc1be450e7e9/sqlitebrowser/sqlitebrowser/issues/4100
og:image:altDescribe 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameTomReddington
hostnamegithub.com
expected-hostnamegithub.com
Nonee3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release5410e4bebd3e45b138c853ecef3992279d86d5af
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/4100#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F4100
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F4100
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4100
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4100
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4100
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4100
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4100
[Feature]: Support composite foreign keys when editing table definition in the UIhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4100#top
https://github.com/TomReddington
TomReddingtonhttps://github.com/TomReddington
on Feb 28, 2026https://github.com/sqlitebrowser/sqlitebrowser/issues/4100#issue-4004689927
composite foreign keyshttps://sqlite.org/foreignkeys.html#fk_composite
https://private-user-images.githubusercontent.com/64867832/556375999-cff608c6-e6ce-45c3-ae94-1b3870e9c92f.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NDU4NDgsIm5iZiI6MTc5NDk0NTU0OCwicGF0aCI6Ii82NDg2NzgzMi81NTYzNzU5OTktY2ZmNjA4YzYtZTZjZS00NWMzLWFlOTQtMWIzODcwZTljOTJmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjExMTclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYxMTE3VDE5NTkwOFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTMyMGEzMzQ3ZWI0YjQ0NzUzMDFmMDE2YzgxNzM0YjI0YzIxNzhhZDI0M2JjMTk3MTdmYjQyOTQ2MmMzMjg3NjAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JnJlc3BvbnNlLWNvbnRlbnQtdHlwZT1pbWFnZSUyRnBuZyJ9.BBbDgHkX_l9i9IfOtiI-9aFdYhHS_Go26FEVlALlXpk
https://private-user-images.githubusercontent.com/64867832/556376446-24087eeb-d869-4120-ba16-bcbb561db5d8.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NDU4NDgsIm5iZiI6MTc5NDk0NTU0OCwicGF0aCI6Ii82NDg2NzgzMi81NTYzNzY0NDYtMjQwODdlZWItZDg2OS00MTIwLWJhMTYtYmNiYjU2MWRiNWQ4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjExMTclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYxMTE3VDE5NTkwOFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTgxZjFkZmRlY2FkMzUzZDBmYjRlNTBmNjQ3MjM2MDQ0ZDg2NmU5N2MwM2RjZDZiODQ0NWZmNDM3MjFlMDk1MjMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JnJlc3BvbnNlLWNvbnRlbnQtdHlwZT1pbWFnZSUyRnBuZyJ9.m-xz35a_iHF5fDesh9gmv5uRLon0oL7qrEUD11sq0vY
https://private-user-images.githubusercontent.com/64867832/556377445-ceb21d00-6636-4496-8927-6bd06d502d77.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NDU4NDgsIm5iZiI6MTc5NDk0NTU0OCwicGF0aCI6Ii82NDg2NzgzMi81NTYzNzc0NDUtY2ViMjFkMDAtNjYzNi00NDk2LTg5MjctNmJkMDZkNTAyZDc3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjExMTclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYxMTE3VDE5NTkwOFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA2NzQyODg1ZDA0MmM1MDQzYTk0N2YxYjllZjA5MDhhNWNkYTYyMWRmYTMxNWQwYzg3YzBlOGViMDg4ZDNlYjcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JnJlc3BvbnNlLWNvbnRlbnQtdHlwZT1pbWFnZSUyRnBuZyJ9.q3p3U1SFw0yPXmZpNSkDupoDX9Rr_-JrSeYKTVs-z84
https://github.com/lilygthb
lilygthbhttps://github.com/lilygthb
on Sep 10, 2026https://github.com/sqlitebrowser/sqlitebrowser/issues/4100#issuecomment-5622807696
https://private-user-images.githubusercontent.com/55871606/649636370-9196d98f-3e9b-44e0-ab92-3ce0ed55c25c.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NDU4NDgsIm5iZiI6MTc5NDk0NTU0OCwicGF0aCI6Ii81NTg3MTYwNi82NDk2MzYzNzAtOTE5NmQ5OGYtM2U5Yi00NGUwLWFiOTItM2NlMGVkNTVjMjVjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjExMTclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYxMTE3VDE5NTkwOFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTE2OGVhZWExMGQzZmU2MmFhZDZhNTcyZTM2ZTVhODFmNDQwYWI2N2I2MjRjNTdjM2VhZWUyMDE4YjFmMTU3MjYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JnJlc3BvbnNlLWNvbnRlbnQtdHlwZT1pbWFnZSUyRnBuZyJ9.W37xHmSARyEF8RTCX-DuygDwbVZ_ii4lmbpHVllZn-U
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4100
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4100
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.