group_members.username unique index

[luistrigueiros]

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

[pmularien]

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.

[luistrigueiros]

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.