PuP_PoC_v1

building

id, name_publisher, publisher

765 rows

building_networks

building, network_id

Many rows

meta_infos

id, key, value

4 rows

network

id, name

38 rows

publisher

id, name

20 rows

screen

id, title, name_publisher, building

2,755 rows

screen_calc

id, name, screen, weekhour, count_plays_per_hour, length_spot_sec, raw_sample

0 rows

timerange

id, name

25 rows

timerange_weekhours

timerange, weekhours

336 rows

weekday

id, name

8 rows

weekday_weekhours

weekday, weekhours

336 rows

weekhour

id

168 rows