On 20 Dec 17:33, Jordi Esteve wrote: > On 20/12/13 17:27, Cédric Krier wrote: > >On 20 Dec 16:35, Sergi Almacellas Abellana wrote: > >>El 20/12/13 14:40, Cédric Krier ha escrit: > >>>More over, you even don't consider one of my main concern about the > >>>different organizations that exist for companies. So your solution is > >>>not flexible at all. > >>In major cases organizations follow an hierarchical structure, so a > >>simple solution will be to create a tree (like product's categories) > >>structure for departments and allow to assign employees to one > >>deparment per company. > >I have never seen any such structure in real life. > > You have not seen a tree department structure or a flat department > structure in any organization? > I am surprised because both structures are the more common ones. > > >There are always exception like some employees are part of two or more > >departments. > > Yes, in some organizations employees can belong to several > departments. So I suggest the most common and flexible structure for > departments and employees is the same one used for party categories > and parties: A hierarchical structure (tree) for departments and a > many2many relation between departments and employees.
Which will lead to be not usefull for reporting which is the main purpose invoked here. -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/
pgpFQdeo0JNhP.pgp
Description: PGP signature
