[refactor] made join column names a constant
[fix] removed relationships to user
[fix] removed now unnecessary "foreign key setting"