Hello

In this relationship diagram,

the tables permission_lookups and permission_objects appear to my mind redundant.

Any comments on the design of this database?

Thanks
D

It looks like someone has tried to create a sub type - super type design but not quite cracked it. For example, I would expect owner_id to be removed from documents and folders and placed in permission_lookups. Then there would be a single relationship to user for that column instead of the two that there are currently.

Admittedly I'm a little less clear on the role of permission_objects.

pootle flump ur codings are working excelent.

Was the architect possibly following some template when he designed these tables?
Best practices for permissions?

The table and column names aren't consistent which makes me suspect this was designed by somebody who didn't know what they were doing. Certainly they weren't following a best practice.