Mediaset Infinity fields in every export
The title record covers the title, original title, content type, genre, release year, duration, maturity rating, synopsis, cast and crew where published, and series or episode identifiers.
Offer type sits on every row: free with advertising, included with subscription, or rental and purchase with the price where published. Where a title is offered on more than one basis, each is its own row rather than a merged flag, because that is what it actually is.
Availability windows are recorded for catch-up material, with the broadcast date and the expiry where published, so the temporary part of the catalogue can be separated from the permanent part rather than being averaged with it.
The originating channel is kept for broadcast material. A programme from a general entertainment channel and one from a news channel are different editorial products and the field costs nothing to carry.
Every row carries the collection timestamp and the section it came from.