feat: Add backend for table archive and favorite flag

[juliusknorr]

Resolves #469

• [ ] Backend
  • [x] Adjust database layout
  • [x] Add archived flag to tables ~and views~
  • [x] Add favorites table that stores if a node (table/view) is favorited by a user
  • [x] Expose archived flag as an option to set through existing API endpoints when updating tables/views
  • [x] Add Controller and Favorite service to mark as favorite and remove favorite
  • [x] First working endpoints
  • [x] Cleanup a bit
  • [x] Adapt other api endpoints that have a comment in routes
  • [x] Proper response format for favorites
  • [x] Add capability for favorites api endpoints
  • [x] Check open api spec annotations
  • [x] Write integration tests
• [ ] Frontend
  • [x] Navigation
  • [x] Remove categories from navigation and just show a plain list (sort favorites first, then by last modification time)
  • [x] Hide archived tables/views in a collapsible entry (like in deck)
  • [x] Archiving
  • [x] Add button to archive/unarchive in the edit table and edit view dialogs
  • [x] Favorites
  • [x] Add action to the menu to mark as favorite and remove from favorites
  • [ ] Cypress tests for adding/removing favorites
  • [ ] Cypress test for archiving/unarchiving

[juliusknorr]

@elzody I pushed a few more individual commits here

[juliusknorr]

@blizzz A quick backend review would already be appreciated :)

[juliusknorr]

@elzody I pushed one more fix to also expose the favorite flag on views when they are returned through the API.

[juliusknorr]

Tested what is already there and works like a charm :)

Maybe you can rebase with your next push to latest main branch to resolve the conflict with the merge of #878

[enjeck]

This is really cool :sunglasses:

Not a big deal, but it'll be nice if we eventually indent the views in Archived tables sidebar, so that it's obvious they're part of a specific table:

Here, "view" is a view of "ToDo list", but it's not obvious due to lack of indent:

[juliusknorr]

Good catch @enjeck

I'll merge this for now and file follow up tasks for the open items

[enjeck]

@juliushaertl Not sure if it's important or not, but I find it weird that the occ command tables:update now has the option --archived, but the title argument is still required. So that means if I wanna archive a table, I'm forced to change the title too?