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
different foreign key definitions on one field. If not
I think you are stuck with 3 tables instead of trying to do it in one.
-Original Message-
From: rtroiana [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 12:23 PM
To: mysql@lists.mysql.com
Subject: Database design query
Hi All,
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
Hi All,
I'm trying to get data from Active Directory and storing in database. So I
have the following tables with their corresponding primary keys:
Group (GroupID)
Host (HostID)
User (UserID)
GroupMember(GroupID, MemberID)
The relatio
