|
|
Posted by Michael_Burgess on 06/08/07 11:12
Hi there,
I'm fairly new to database design, having only really worked with
existing tables etc in the past.
Simple question this really...........
In a users table, is it wise to have a ManagerID column that is
effectively pointing to another user in the same table, with the
theory being that if that person is top dog, they will just have a
null entry in ManagerID.
I will check for circular references before entering the data.
Is there a better way of storing the data, or is this the only way?
Thanks,
Michael.
Navigation:
[Reply to this message]
|