added entity diagram
modified import script to follow the entity diagram