spot_config
24 rows where publisher = 271
This data as json, copyable, CSV (advanced)
Suggested facets: count_plays, weekday, is_standard
| config_id ▼ | length_spot | length_loop | count_plays | weekday | time_range | publisher | published | is_standard |
|---|---|---|---|---|---|---|---|---|
| 329 | 10 | 20 | Woche 1 | 1 1 | None 271 | 1 | 0 | |
| 330 | 10 | 20 | Mo 2 | 1 1 | None 271 | 1 | 0 | |
| 331 | 10 | 20 | Di 3 | 1 1 | None 271 | 1 | 0 | |
| 332 | 10 | 20 | Mi 4 | 1 1 | None 271 | 1 | 0 | |
| 333 | 10 | 20 | Do 5 | 1 1 | None 271 | 1 | 0 | |
| 334 | 10 | 20 | Fr 6 | 1 1 | None 271 | 1 | 0 | |
| 335 | 10 | 20 | Sa 7 | 1 1 | None 271 | 1 | 0 | |
| 336 | 10 | 20 | So 8 | 1 1 | None 271 | 1 | 0 | |
| 337 | 10 | 30 | Woche 1 | 1 1 | None 271 | 1 | 1 | |
| 338 | 10 | 30 | Mo 2 | 1 1 | None 271 | 1 | 0 | |
| 339 | 10 | 30 | Di 3 | 1 1 | None 271 | 1 | 0 | |
| 340 | 10 | 30 | Mi 4 | 1 1 | None 271 | 1 | 0 | |
| 341 | 10 | 30 | Do 5 | 1 1 | None 271 | 1 | 0 | |
| 342 | 10 | 30 | Fr 6 | 1 1 | None 271 | 1 | 0 | |
| 343 | 10 | 30 | Sa 7 | 1 1 | None 271 | 1 | 0 | |
| 344 | 10 | 30 | So 8 | 1 1 | None 271 | 1 | 0 | |
| 345 | 10 | 60 | Woche 1 | 1 1 | None 271 | 1 | 0 | |
| 346 | 10 | 60 | Mo 2 | 1 1 | None 271 | 1 | 0 | |
| 347 | 10 | 60 | Di 3 | 1 1 | None 271 | 1 | 0 | |
| 348 | 10 | 60 | Mi 4 | 1 1 | None 271 | 1 | 0 | |
| 349 | 10 | 60 | Do 5 | 1 1 | None 271 | 1 | 0 | |
| 350 | 10 | 60 | Fr 6 | 1 1 | None 271 | 1 | 0 | |
| 351 | 10 | 60 | Sa 7 | 1 1 | None 271 | 1 | 0 | |
| 352 | 10 | 60 | So 8 | 1 1 | None 271 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spot_config ( config_id INTEGER NOT NULL, length_spot INTEGER, length_loop INTEGER, count_plays INTEGER, weekday INTEGER, time_range INTEGER, publisher INTEGER, published BOOLEAN, is_standard BOOLEAN, PRIMARY KEY (config_id), UNIQUE (config_id), FOREIGN KEY(weekday) REFERENCES weekday (id), FOREIGN KEY(time_range) REFERENCES time_range (id), FOREIGN KEY(publisher) REFERENCES publisher (id) );