Dear rstrachan,
I am very glad to provide you an innovative database schema for MYSQL technology.
You will get sql scripts to build the database, ER diagrams, and other illustration pictures. If you have powerdesigner software then I can provide you all the framework files of that software.
Look forward to working with you soon.
Best Regards,
Rose Office