PPS3_Spotconfigs_Screens_Herbst_2025_01

Custom SQL query

Tables

dayOfWeek

weekday_index, weekday_id, weekday_name, order

13 rows

dayPart

daypart_index, daypart_id, daypart_name, range

56 rows

default_bid_configs

bid, daypart_id, weekday_id, spot_length, playouts_per_hour, time_range_weekhours, weekday_weekhours

15,178 rows

playOuts

play_outs_index, play_outs

28 rows

spotLengths

spot_length_index, spot_length

6 rows

spotconfig_publisher

id, spotconfig_id, publisher_id, spotconfig_name

102 rows

spotconfig_publisher_day_part

spotconfig_publisher, day_part

906 rows

spotconfig_publisher_play_outs_per_hour

spotconfig_publisher, playouts_per_hour

295 rows

spotconfig_publisher_spot_length

spotconfig_publisher, spot_length

127 rows

spotconfig_publisher_weekday

spotconfig_publisher, weekday

521 rows

timerange_weekhours

id, timerange, weekhours, daypart_id, daypart_index

1,946 rows

weekday_weekhours

id, weekday, weekhours, weekday_index, weekday_id

1,032 rows