Re: Best Database Representation of a Chain of Command

2007-06-19 Thread Peter Brawley
>I'd like to represent our organization's chain of command (i.e. who is whose >boss) in a database. For some ideas see http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html PB David T. Ashley wrote: I'd like to represent our organization's chain of command (i.e. who is whose bo

Best Database Representation of a Chain of Command

2007-06-19 Thread David T. Ashley
I'd like to represent our organization's chain of command (i.e. who is whose boss) in a database. The reason is that in some contexts, my database application needs to know who can view whose time and project records (and the rule is that anyone above in the chain of command can, anyone at the sa

Re: Best Database

2004-03-01 Thread Ligaya Turmelle
check into innodb and transactions Respectfully, Ligaya Turmelle ""Paul Higgins"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi everyone, > > I want to create a table that will consistently have data added and removed > from it. Is there anything I should know/consider before

Best Database

2004-02-29 Thread Paul Higgins
Hi everyone, I want to create a table that will consistently have data added and removed from it. Is there anything I should know/consider before doing this? Any information you could provide would be GREATLY appreciated. Thanks, Paul