PPS3_Spotconfigs_2025_04

Custom SQL query

Tables

dayOfWeek

weekday_index, weekday_id, weekday_name, order

13 rows

dayPart

daypart_index, daypart_id, daypart_name, range

54 rows

default_bid_configs

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

Many rows

playOuts

play_outs_index, play_outs

27 rows

spotLengths

spot_length_index, spot_length

6 rows

spotconfig_publisher

id, spotconfig_id, publisher_id, spotconfig_name

67 rows

spotconfig_publisher_day_part

spotconfig_publisher, day_part

460 rows

spotconfig_publisher_play_outs_per_hour

spotconfig_publisher, playouts_per_hour

157 rows

spotconfig_publisher_spot_length

spotconfig_publisher, spot_length

82 rows

spotconfig_publisher_weekday

spotconfig_publisher, weekday

320 rows

timerange_weekhours

id, timerange, weekhours, daypart_id, daypart_index

1,904 rows

weekday_weekhours

id, weekday, weekhours, weekday_index, weekday_id

1,032 rows