Easy question that should be a sticky!
Posted: Fri Jun 11, 2010 3:56 pm
So I don't mean to sound like a "noobie" or anything, especially with my experience with PHP & MySQL; however, I've been wanting to advance my complexity of database scheming. Not to make it harder to maintain and understand, but I've never gotten all that deep with MySQL - or so I feel.
What I'm really asking for is exceptional database schemes that where designed with future development in mind, are advanced, and performance-optimized.
I'm working on a CRM project (with many other features so it'll actually be worth using), that'll have users linked to client projects, with company's linked to projects, with client's linked to company's, etc. I already have a base scheme but I would like to see how major companies have implemented their databases and perhaps change my accordingly.
Thanks guys!
Like I said perhaps we should make this a sticky with the title "Exceptional Database Schemes to Learn From".
What I'm really asking for is exceptional database schemes that where designed with future development in mind, are advanced, and performance-optimized.
I'm working on a CRM project (with many other features so it'll actually be worth using), that'll have users linked to client projects, with company's linked to projects, with client's linked to company's, etc. I already have a base scheme but I would like to see how major companies have implemented their databases and perhaps change my accordingly.
Thanks guys!
Like I said perhaps we should make this a sticky with the title "Exceptional Database Schemes to Learn From".