I have added sql file in db_design i.e. dande database design 101, the initial design, see inline comments and also refer to the google docs dande DB design