updated ER diagram to match current schema