Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    2

    Redundant tables

    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

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    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.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2010
    Posts
    2
    Was the architect possibly following some template when he designed these tables?
    Best practices for permissions?

  4. #4
    Join Date
    Jul 2009
    Location
    Michigan
    Posts
    125
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •