updated data model relation diagram, and updated parsing file to provide more datal.