[OOTW] Entity-Relationship Diagram of the Database

Entity-Relationship diagram of the most relevant tables in the project relational database.

Key entities in the model are rendered with a colored header.

• Work: an abstraction of a play, independent from its representation.
• Text: a textual representation of a play, whether it is in the original language or a translation.
• Text Sample: a short excerpt from a Text.
• Production: performance(s) of a Work or particular Text of that Work.
• Person: an author of a Work or Text.

Other entities are used to connect the main entities together or to further characterise them.

Conventions: the fields ending in _id are foreign keys pointing to the id field of the entity with the same name.