lied,
Reema
-Original Message-
From: Gordon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 8:39 AM
To: 'rtroiana'
Subject: RE: Database design query
I know what you are trying to do and I can see the logic advantage of having
a single table that defines the the gr
IF GroupID, HostID and UserID are unique between the three sets then your
GroupMember table will work although I would still be tempted to add a
MemberType in the GroupMember table.
Isn't MemberID the Foreign Key to UserID/HostID/GroupID althugh I don't know
if you can have three different foreig
Hi,
i think you must normalize your table to more than one table.
Users/Groups : N:1
Groups/Groups : N:1
Table Users :
User_id
Host
Group_id
Table Groups :
Group_id
Group_parent_id<- is a another group_id
No data redondancy and robust implementation.
see for example /etc/passwd and
