updated schema: removed affiliation table