The following is a UML class diagram of these entities, prior to physical modeling. The corresponding MySQL is listed on its own page