network

3 rows where parent = 7

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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