screen

10 rows where building = "RSG-HH002"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building
10014084 10014084 - Cardio Screen 1 (links) Cardio Screen 1 (links) RSG-HH002
10014085 10014085 - Cardio Screen 2 (mitte) Cardio Screen 2 (mitte) RSG-HH002
10014086 10014086 - Cardio Screen 3 (mitte) Cardio Screen 3 (mitte) RSG-HH002
10014087 10014087 - Cardio Screen 4 (rechts) Cardio Screen 4 (rechts) RSG-HH002
10014088 10014088 - Infoscreen Infoscreen RSG-HH002
10014089 10014089 - Geräte Screen 1 (Links) Geräte Screen 1 (Links) RSG-HH002
10014090 10014090 - Geräte Screen 2 (mitte) Geräte Screen 2 (mitte) RSG-HH002
10014091 10014091 - Geräte Screen 3 (rechts) Geräte Screen 3 (rechts) RSG-HH002
10014092 10014092 - Power Screen Power Screen RSG-HH002
10014093 10014093 - Training Training RSG-HH002

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, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id)
);
CREATE INDEX ix_screen_building ON screen (building);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);