Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
Here is my preliminary table schema. Tomorrow we will probe into how my assumptions influenced its design.