Custom SQL query

frequency

id, frequency_code, frequency_per_hour

28 rows

infos_media_variants

media_variant_id, media_variant_infos_id

41,150 rows

media

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

131 rows

media_variant

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

35,562 rows

media_variant_infos

id, key, value

82 rows

media_variant_standard

id, variant, media

129 rows

meta_infos

id, key, value

6 rows

publisher

id, name, publisher_id

20 rows

spotset

id, name, publisher, extern

64 rows

spotset_frequencies

spotset_id, frequency_id

159 rows

spotset_medias

spotset_id, media_id

254 rows

spotset_timeranges

spotset_id, timerange_id

891 rows

spotset_weekdays

spotset_id, weekdays_id

274 rows

time_range

id, name, range_id, hours

44 rows

touchpoint

id, name

Many rows

weekday

id, name, weekdays, days

7 rows