network

6 rows where parent = 4

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ parent name
64 4 Airport Touchpoint Dresden
65 4 Airport Touchpoint Hamburg gesamt
66 4 Airport Touchpoint Hannover gesamt
67 4 Airport Touchpoint München gesamt
68 4 Airport Touchpoint Nürnberg gesamt
69 4 Airport Touchpoint Stuttgart gesamt

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);