Saturday, June 16, 2012 1:47 PM
Hi, I'm not so experienced in designing database plz help me!
I'm designing a web hosting website.
We ham list of hosting plans in our site including diskspace, bandwidth and price.
Each hosting plan has several packages that will sell to users. Each package has CPanel username and password, start time, end time and …
We have list of domain type like .com, .net and …, and we store 1 year price of each type.
We ham list of submitted domain by our company and we store type of domain, start time and end time.
List of VPS is much the same as list of package and each VPS is owned by a user.
User can renew domain, change domain DNS and …
It can renew package, upgrade it and …
And the same for VPS
Some of this services are free and some not. For each service we make an invoice and we store all the user invoices.
In a nutshell, I want to relate this products (domain, host, VPS), users, services (Change DNS, upgrade) and invoices together in an effective way.
We can have video conference if it’s not clear enough. Email me and tell me the time! (international time) I’ll be online ;)
Thursday, June 28, 2012 10:59 PM
Maybe you should start here:
Monday, July 16, 2012 10:18 PM
It's easier for us to help if you provide a bit more about what you've attempted and what you've had problems with in more detail. Ask specific questions and we can give you some answers to those questions.
Start by listing all the "things" you want to keep data about and model those, with relationships. Don't worry about columns and tables yet. Going right to columns is what gets people in trouble because they get caught up in the details before they've had a chance to think about the bigger picture.
Do that, then come back with some specific questions.
--- Love Your Data @datachick blog.infoadvisors.com
Tuesday, July 17, 2012 12:03 PM
You can view the site below to avoid mistake