proper primary key, removed redundant data collection