Page 1 of 1

Easy question that should be a sticky!

Posted: Fri Jun 11, 2010 3:56 pm
by DaveTheAve
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".

Re: Easy question that should be a sticky!

Posted: Sat Jun 12, 2010 12:55 am
by DaveTheAve
Looking at a few Database's from sourceforge's CRM projects, I find that they're databases are not any more complex or thought out as mine are. So I guess I must be doing something right. lol! :drunk:

Though I would like it if someone can post a least a few exceptional database schemes that they've seen.