Joke Response System Request—Events

This system is centered on performances of jokes which may be a part of a set of jokes and must be a part of a show.

Performed Jokes
A performed joke is the most granular event to capture. These are performed in sets of jokes within a show. A performed joke is an event, while a joke is an entity that also "lives" separate from the performance in our system. The responses to the joke are critical for analysis. Responses that might be collected include the type of response (laughter, groan, applause, ...), the magnitude of the response, the duration of the response, and responses from hecklers.
  • A joke performance has a starting date/time, although that might not be identifiable by the reviewer who might otherwise indicate when a show "aired" (and might not even know when it first aired) or even the copyright date of a CD they are listening to.
  • The performed joke has exact text, a duration, and several attributes related to the reaction such as a classification of the type of response, size of the response, and the reviewer's thumbs up/down on whether the joke was successful from their perspective.
  • Each joke performance can be uniquely identified by the show, the comedian, (the set), the joke, and the instance of this joke (1 for the first time it is told in the set). The set, by whatever identifier, is not required depending on when you start renumbering instances of a joke -- either within the show or the set. It could also be uniquely identified by the show and the time within the show (offset from the start, for example) that a joke started. Of course the data modeler might opt for a single unique id for each such joke performance.
Show
A show consists of one or more comedic performers performing one or more of the same or different sets of jokes and/or individual jokes at the same venue in a contiguous time period. A show is associated with a single venue.
  • A show has a single starting date/time and either a duration or ending date/time. Again, the exact date of the event is useful information but might not be something the reviewer knows when they enter the data.
  • Just as jokes in a set are ordered, sets and/or individual jokes in a show are delivered in a order. It is a nice-to-have, rather than a must-have that the ordering for shows is captured.
TV Show
A TV Show is a series of shows under a single name.
Set
A performed set consists of an ordered list of joke performances. A show consists of one or more ordered sets. Because we will not capture information about planned sets of jokes, we can use the term "Set" for what HAS happened, ignoring the use of the term as an ordered list of jokes to be told. The ordering of a set is part of the requirements for the system.

Litter Box

Some of this is worth pawing through.