Platform SDK: Broadcast Architecture |
To investigate and print out the details of the Guide database schema, including field descriptions, field sizes, and referential integrity rules, you can make a copy of the empty database installed by the broadcast client installation program. You can then examine the copy using Microsoft® Access, as described in the following procedure.
To examine the Guide database schema in detail
For improved performance and ease of navigation, many of the tables in the Guide database schema are referentially linked with automatically generated counters. The referential integrity of these counter fields is guaranteed by:
You can use these automatically generated identifier (ID) fields in queries and code that navigate among the tables. However, you should never store these identifier fields externally to the database, because their values are subject to ongoing change when the database loaders add and delete records as part of updating the database. If an application must save an external reference to an item in the database, it must use one of the key fields flagged as external to do so.