[This is preliminary documentation and subject to change.]
The Theme table in the Guide database defines information about themes. A theme allows an episode to be associated with multiple genre/subgenre pairs, because genre/subgenre pairs can share the same T Theme ID field.
For example, a motion picture might have a T Theme ID of 2, placed in the E Theme ID field of the Episode table. In the Theme table, the genre/subgenre pair Science Fiction/Movie and the genre/subgenre pair Movie/Action can both share that same T Theme ID of 2.
The Theme table contains the following fields.
| Field | Description |
|---|---|
| T Genre ID | Foreign key from the Genre table. |
| T Sub Genre ID | Foreign key from the Sub-Genre table. |
| T Theme ID | Internally generated unique identifier for this record. |