Posted by M A Srinivas on 06/08/07 11:57

On Jun 8, 4:12 pm, Michael_Burgess <m...@marsh-hall-studios.co.uk>
wrote:
> 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.

This is the way to store data , Otherwise you may require as many
tables as there are levels . You have to build a hierarchy column
for easy retrieval of child and parent

[Back to original message]