[This is preliminary documentation and subject to change.]
The Guide database schema contains the following tables.
| Table | Description |
|---|---|
| AdTrack | Stores information about rotating advertisements such as the name of the file containing the ad and how often to display it. |
| Broadcast Property | Provides names for various broadcast properties, such as closed captioning. |
| Channel | Describes channels that can be tuned to. |
| Channel Property | Specifies properties associated with individual channels. |
| Channel Stream | Lists the data streams available for a specific channel. |
| Enhancement | Contains information used by Microsoft WebTV for Windows to link shows to their enhancements. |
| Episode | Describes television program episodes for which the database has information. |
| Episode Property | Specifies properties associated with individual show episodes. |
| Genre | Provides names for categories of show episodes, for example movies, television series, and so on. |
| Network | Defines the broadcast networks in use, such as ABC, CBS, NBC, and so on. |
| Rating | Defines names for individual ratings used in the various rating systems in use. |
| Rating System | Identifies the rating systems in use, such as the Motion Picture Association of America (MPAA) system. |
| Station | Defines the current set of individual broadcast content providers. |
| Stream Type | Provides names for all data streams available on a specific channel. The data streams can provide information such as stock and sports updates, or data for the Program Guide. |
| Sub-Genre | Provides names for subcategories within a genre. |
| Theme | Defines unique pairs of genres and subgenres to help classify show episodes. |
| Theme ID Mapping | Maps genres and subgenres information in the data sent by broadcast content providers to the genre-subgenre pairs in the Theme table. |
| Time Slot | Defines time slot and channel information for show episodes. |
For information on how to examine the Guide database schema, see Using the Guide Database Schema. The following sections show the database schema. For information on the terms used in the reference section, see the Microsoft® Access documentation.