screen

15 rows where building = "RSG-HH008"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network
10014143 10014143 - Cardio Screen 1 Cardio Screen 1 RSG-HH008 37
10014144 10014144 - Cardio Screen 2 Cardio Screen 2 RSG-HH008 37
10014145 10014145 - Cardio Screen 3 Cardio Screen 3 RSG-HH008 37
10014146 10014146 - Cardio Screen 4 Cardio Screen 4 RSG-HH008 37
10014147 10014147 - Cardio Screen 5 Cardio Screen 5 RSG-HH008 37
10014148 10014148 - Cardio Screen 6 Cardio Screen 6 RSG-HH008 37
10014149 10014149 - Infoscreen Infoscreen RSG-HH008 37
10014150 10014150 - Power Screen 1 Power Screen 1 RSG-HH008 37
10014151 10014151 - Poweer Screen 2 Poweer Screen 2 RSG-HH008 37
10014152 10014152 - Power Screen 3 Power Screen 3 RSG-HH008 37
10014153 10014153 - Geräte Screen 1 Reihe 1 Geräte Screen 1 Reihe 1 RSG-HH008 37
10014154 10014154 - Geräte Screen 2 Reihe 1 Geräte Screen 2 Reihe 1 RSG-HH008 37
10014155 10014155 - Geräte Screen 3 Reinhe 1 Geräte Screen 3 Reinhe 1 RSG-HH008 37
10014156 10014156 - Geräte Screen 1 Reihe 2 Geräte Screen 1 Reihe 2 RSG-HH008 37
10014157 10014157 - Geräte Screen 2 Reihe 2 Geräte Screen 2 Reihe 2 RSG-HH008 37

Advanced export

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

CSV options: 

CREATE TABLE screen (
	id VARCHAR(8) NOT NULL, 
	title VARCHAR(250), 
	name_publisher VARCHAR(250), 
	building VARCHAR, 
	network VARCHAR, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network) REFERENCES network (id)
);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);
CREATE INDEX ix_screen_building ON screen (building);