network
4 rows where parent = 41
This data as json, copyable, CSV (advanced)
| id ▼ | parent | name |
|---|---|---|
| 42 | 41 | Mobility Channel Bistro |
| 43 | 41 | Mobility Channel Eingang - Indoor |
| 44 | 41 | Mobility Channel Eingang - Outdoor |
| 45 | 41 | Mobility Channel Kasse |
Advanced export
JSON shape: default, array, newline-delimited, object
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);