foreign_key_references

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

1 row where foreign_key_with_label = 1

descending

pk ▼	foreign_key_with_label	foreign_key_with_no_label
1	hello 1	1

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE foreign_key_references (
  pk varchar(30) primary key,
  foreign_key_with_label varchar(30),
  foreign_key_with_no_label varchar(30),
  FOREIGN KEY (foreign_key_with_label) REFERENCES simple_primary_key(id),
  FOREIGN KEY (foreign_key_with_no_label) REFERENCES primary_key_multiple_columns(id)
);