home / MAGMA_2023_I

Menu
  • Log in

filter_item

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filter

id ▼ filter title
1 Größe 1 Groß
2 Größe 1 Klein
3 Größe 1 Mittel
4 Food 2 Food
5 Food 2 Non-Food
6 Branche 3 LEH
7 Branche 3 C+C

Advanced export

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

CSV options:

CREATE TABLE filter_item (
	id INTEGER NOT NULL, 
	filter INTEGER, 
	title VARCHAR(250), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(filter) REFERENCES filter (id), 
	UNIQUE (title)
);
CREATE INDEX ix_filter_item_filter ON filter_item (filter);
Powered by Datasette · Queries took 1.2ms