Rough cut of ERD shows only 2 relationships. The code does not respect the relationships however.
table care_user_roles Primary Key 'id' is an INT Foreign Key 'user_role' in table care_users is a Tiny INT If the numebr of anticipated roles is going to be < 256 then a TinyINT would suffice. Keeping it an INT would be better for both. Must now fathom all links for it. -Ap.Muthu ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers