New tables for our WDTU project

First, we create a Playlist Header table (table number 50002), which will contain one record for each scheduled Radio Show:

Then we will create the associated Playlist Line table (table number 50003). This table will contain child records to the Playlist Header table. Each Playlist Line record represents one scheduled piece of music or advertisement or public service announcement or embedded show within the scheduled Radio Show defined in the Playlist Header table. The Description for each of the Option fields shows the information that needs to be entered into the OptionString, OptionCaption and OptionCaptionML properties for those fields:

Now we'll create our Playlist Item Rate table. These rates include both what we charge for advertising time and what we must pay in royalties for material we broadcast:

An entry table contains the detailed history of processed actpity records. In this case, the data is a detailed history of all the Playlist Line records for previously broadcast shows:

Now we'll create one more entry table to retain data we recepe from the listenership rating service:

Finally, the last new table definition for now, our Publisher table: