spotset_medias
6 rows where spotset_id = 7
This data as json, copyable, CSV (advanced)
| Link | spotset_id | media_id |
|---|---|---|
| 7,DB_0_000 | Edgar Ambient Media Group GmbH 7 | Campus TV DB_0_000 |
| 7,DD_0_000 | Edgar Ambient Media Group GmbH 7 | Cinema Channel DD_0_000 |
| 7,DE_0_000 | Edgar Ambient Media Group GmbH 7 | Public Video Scene DE_0_000 |
| 7,DG_0_000 | Edgar Ambient Media Group GmbH 7 | Media Markt DG_0_000 |
| 7,DH_0_000 | Edgar Ambient Media Group GmbH 7 | Saturn DH_0_000 |
| 7,DJ_0_000 | Edgar Ambient Media Group GmbH 7 | Retail TV Food Neo DJ_0_000 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );