Custom SQL query

frequency

id, frequency_code, frequency_per_hour

30 rows

infos_media_variants

media_variant_id, media_variant_infos_id

900 rows

media

id, title, touchpoint, publisher, count_locations, count_screens, extern, order

160 rows

media_variant

id, media, weekdays, timerange, frequency, study_code, source, extern, raw_sample

44,374 rows

media_variant_infos

id, key, value

Many rows

media_variant_standard

id, variant, media

135 rows

publisher

id, name, publisher_id

20 rows

spotset

id, name, publisher, extern

73 rows

spotset_frequencies

spotset_id, frequency_id

176 rows

spotset_medias

spotset_id, media_id

288 rows

spotset_timeranges

spotset_id, timerange_id

1,090 rows

spotset_weekdays

spotset_id, weekdays_id

320 rows

time_range

id, name, range_id, hours

44 rows

touchpoint

id, name

22 rows

weekday

id, name, weekdays, days

7 rows