Composite foreign keys don't show up anywhere in the table structure.
Open
enhancement
- Dominant language
- Python
- Stars
- 486
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
Taking the following tables:
```
create table a (id1 int, id2 int, primary key (id1, id2));
create table b (id1 int, id2 int, foreign key (id1, id2) references a (id1, id2));
```
Looking at table `b` structure in postico doesn't show the foreign key that references table a.
Contributor guide
No contributing guide indexed for this repository
Research direction
Reproduce the report using the SQL for tables a and b, then inspect table b's structure view and the code that gathers and displays foreign keys. Done means the composite foreign key from b(id1, id2) to a(id1, id2) appears in Postico's table structure.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100