jakob / jakob/Postico

View all multi-column constraints?

Open
#588 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

In the "structure" view of tables, there is a column for showing constraints, but these only show the constraints for that particular row (i.e. attribute). I'm working on a database with more than a few multi-column constraints (foreign keys, mostly), which I can only identify through the "DDL" view. Is there another way to view multi-column constraints that I don't know of? I tried the "help" menu item but couldn't find any more information.
I suppose the same goes for adding multi-column constraints. Perhaps it would make sense to move the constraints down (below "Indexes", for example) and to use references where the constraints are shown now (e.g. colored links that show a symbol or the name of the constraint)?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by comparing the table’s “structure” view with its “DDL” view, focusing on how multi-column foreign keys and other constraints are represented. Determine the intended placement and interaction for viewing and adding these constraints; done means the relevant multi-column constraints are discoverable without relying only on the DDL view.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.