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".
Easy question that should be a sticky!
Moderator: General Moderators
- DaveTheAve
- Forum Contributor
- Posts: 385
- Joined: Tue Oct 03, 2006 2:25 pm
- Location: 127.0.0.1
- Contact:
- DaveTheAve
- Forum Contributor
- Posts: 385
- Joined: Tue Oct 03, 2006 2:25 pm
- Location: 127.0.0.1
- Contact:
Re: Easy question that should be a sticky!
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!
Though I would like it if someone can post a least a few exceptional database schemes that they've seen.
Though I would like it if someone can post a least a few exceptional database schemes that they've seen.