complex_foreign_keys

1 row where f2 = 2

View and edit SQL

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)
);
Powered by Datasette · Query took 12.825ms