spotset_medias

38 rows where spotset_id = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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