network

4 rows where parent = 6

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ parent name
7 6 Autobahn Touchpoint Classic Gesamt
11 6 Autobahn Touchpoint Digitale Spiegel Sanifair
12 6 Autobahn Touchpoint Travelboard
63 6 Airport Touchpoint Düsseldorf Sicherheitsbereich

Advanced export

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

CSV options: 

CREATE TABLE network (
	id INTEGER NOT NULL, 
	parent VARCHAR, 
	name VARCHAR(250), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(parent) REFERENCES network (id)
);
CREATE UNIQUE INDEX ix_network_name ON network (name);
CREATE INDEX ix_network_parent ON network (parent);