home / fixtures2 / foreign_key_references

Menu

foreign_key_references

1 row where foreign_key_with_blank_label = 3

Clear filters
View and edit SQL

Export data

foreign_key_references

Filtered rows where foreign_key_with_blank_label = 3

TSV All 1 row
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 1 row
Comma-separated values, for spreadsheets and other tools
  • JSON All 1 row
    Rows inside an object, with extra details
    View Download
  • JSON array All 1 row
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 1 row
    One JSON object per line
    View Download
  • JSON object All 1 row
    Rows keyed by their primary key
    View Download
  • testall All 1 row
    View Download
  • testnone All 1 row
    View Download
  • testresponse All 1 row
    View Download

pk ▼ foreign_key_with_label foreign_key_with_blank_label foreign_key_with_no_label foreign_key_compound_pk1 foreign_key_compound_pk2
1 hello 1 - 3 1 a b
Table schema
CREATE TABLE foreign_key_references (
  pk varchar(30) primary key,
  foreign_key_with_label integer,
  foreign_key_with_blank_label integer,
  foreign_key_with_no_label varchar(30),
  foreign_key_compound_pk1 varchar(30),
  foreign_key_compound_pk2 varchar(30),
  FOREIGN KEY (foreign_key_with_label) REFERENCES simple_primary_key(id),
  FOREIGN KEY (foreign_key_with_blank_label) REFERENCES simple_primary_key(id),
  FOREIGN KEY (foreign_key_with_no_label) REFERENCES primary_key_multiple_columns(id)
  FOREIGN KEY (foreign_key_compound_pk1, foreign_key_compound_pk2) REFERENCES compound_primary_key(pk1, pk2)
);
Powered by Datasette · Queries took 337.444ms