complex_foreign_keys

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

1 row where f3 = 1

✖
✖

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

pk ▼ f1 f2 f3
1 hello 1 world 2 hello 1

Advanced export

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

CSV options: 

CREATE TABLE "complex_foreign_keys" (
  pk varchar(30) primary key,
  f1 text,
  f2 text,
  f3 text,
  FOREIGN KEY ("f1") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f2") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f3") REFERENCES [simple_primary_key](id)
);