Announcement Announcement Module
Collapse
No announcement yet.
group_members.username unique index Page Title Module
Move Remove Collapse
This topic is closed
X
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • group_members.username unique index

    Greetings

    Why the table group_members does not have unique index for username column?
    Why should username column be a reference to the table user column username ?
    Is there a reason for this ?
    Thank you, Oscar

  • #2
    Well, a user could be a member of more than one group... I would agree that the combination of user + group could be enforced by a unique constraint, but there's nothing preventing you from tweaking the suggested standard schema to fit your needs.

    Comment


    • #3
      Originally posted by pmularien View Post
      Well, a user could be a member of more than one group... I would agree that the combination of user + group could be enforced by a unique constraint, but there's nothing preventing you from tweaking the suggested standard schema to fit your needs.
      Thank you it make perfect sense.

      Comment

      Working...
      X