Thread: Database link tables to model

Suppose you have an application that stores images in categories. Images can be uploaded, deleted, viewed, ... by users that were given right to view, upload, delete, ... Categories can be nested, and the rights can be set on every level.

Database:

Table category: id, name
Table user: id, name
Table user_category: id, user_id, category_id, view, delete, upload


Should I create a UserCategory object that has a User and a Category object + the view, delete & upload rights?
Fetching the categories for a user will thus result in a List<UserCategory>.
Category.countImages() -> results in a full count of all images in the category
UserCategory.countImages() -> counts images in the categories where the user has right to
Is this a good approach?