spotset_medias

38 rows where spotset_id = 34

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id media_id
34,BB_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Classic Gesamt BB_0_000
34,BB_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Classic Departure BB_1_000
34,BB_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Classic Arrival BB_2_000
34,BB_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Classic Sicherheitsbereich BB_3_000
34,BB_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Classic Öffentlicher Bereich BB_4_000
34,BB_5_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Düsseldorf Sicherheitsbereich BB_5_000
34,BB_6_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Düsseldorf Departure BB_6_000
34,BB_7_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Düsseldorf Arrival BB_7_000
34,BC_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hamburg Gesamt BC_0_000
34,BC_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hamburg Sicherheitsbereich BC_1_000
34,BC_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hamburg Öffentlicher Bereich BC_2_000
34,BC_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hamburg Departure BC_3_000
34,BC_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hamburg Arrival BC_4_000
34,BD_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hannover Gesamt BD_0_000
34,BD_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hannover Sicherheitsbereich BD_1_000
34,BD_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hannover Öffentlicher Bereich BD_2_000
34,BD_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hannover Departure BD_3_000
34,BD_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Hannover Arrival BD_4_000
34,BE_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint München Gesamt BE_0_000
34,BE_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint München Sicherheitsbereich BE_1_000
34,BE_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint München Öffentlicher Bereich BE_2_000
34,BE_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint München Departure BE_3_000
34,BE_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint München Arrival BE_4_000
34,BF_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Nürnberg Gesamt BF_0_000
34,BF_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Nürnberg Sicherheitsbereich BF_1_000
34,BF_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Nürnberg Öffentlicher Bereich BF_2_000
34,BF_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Nürnberg Departure BF_3_000
34,BF_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Nürnberg Arrival BF_4_000
34,BG_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Stuttgart Gesamt BG_0_000
34,BG_1_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Stuttgart Sicherheitsbereich BG_1_000
34,BG_2_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Stuttgart Öffentlicher Bereich BG_2_000
34,BG_3_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Stuttgart Departure BG_3_000
34,BG_4_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Stuttgart Arrival BG_4_000
34,BH_0_000 Brand Community Network (BCN) (5) 34 Airport Touchpoint Dresden BH_0_000
34,BI_1_000 Brand Community Network (BCN) (5) 34 Autobahn Touchpoint Classic Gesamt BI_1_000
34,BI_2_000 Brand Community Network (BCN) (5) 34 Autobahn Touchpoint Classic Kasse BI_2_000
34,BI_3_000 Brand Community Network (BCN) (5) 34 Autobahn Touchpoint Classic Kühltheke BI_3_000
34,BI_4_000 Brand Community Network (BCN) (5) 34 Autobahn Touchpoint Classic Gondel BI_4_000

Advanced export

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

CSV options: 

CREATE TABLE spotset_medias (
	spotset_id INTEGER NOT NULL, 
	media_id VARCHAR(8) NOT NULL, 
	PRIMARY KEY (spotset_id, media_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(media_id) REFERENCES media (id)
);