partially created db architecture

haven't created all the relationships yet