remove unused routes and actions; add authentication and authorization to all actions
add foreign key constraints, remove unused column and table [#83038750]