Concepts for DataModel - OregonShakespeareFestival/captioncast GitHub Wiki
Took a shot at modeling in MySQL workbench the ORM.
Might be totally backwards. But let's see if we can model the data this way.
This will probably also need to include a facility for adding characters to a work.
Elements is meant to describe dialogue vs non-dialogue and assign a color to that type of thing.