MySQL Forums :: Newbie :: Portal Database design help


Advanced Search

Portal Database design help
Posted by: Shine Jones ()
Date: April 27, 2009 12:12AM

I am developing a portal using php and mysql. I am facing a problem in the database design because my database is going to take million of records. I am not very much experienced in database design. So I request some experienced people to come forward for my help. I am not sure my database design is correct or not and is this database schema capable to take millions of records.
My portal basically consists of three types of search.
1. Business or category search
2. Company’s name search
3. Person’s name search.
If someone clicks on any of these three, it opens a panel, in which there are two fields,
1. Select city - ( I want to start with at least 20 cities and then extending it to over 200 or more)
2. Enter query. - ( As you type a character it starts showing hints. )
My database schema is like this.
Categories Table
1. Category Id
2. Category Name
3. Related Companies (companies id).
Companies Table
1. Company Id
2. Company Name
3. Address 1
4. Address 2
5. Address 3
6. Address 4
( I am thinking to split city pin and state in different tables as these fields are going to repeat. )
7. City
8. Pin
9. State
10. Phone 1
11. Phone 2
12. Mobile 1
13. Mobile 2
14. Fax 1
15. Fax 2
16. Email 1
17. Email 2
18. Website 1
19. Website 2
20. Contact person 1
21. Contact person 2
22. Designation
23. Business details
So the problem lies in business or category search as I want to relate companies with the categories in which they fall, when user makes a business search it shows hints from the category list and the user can either select from the hints or type in his own query, after which the search function tries to find out the companies related to that particular category, display them and moreover it shows the related categories list.
What I am doing is I am putting the ids of the companies related to a particular category in the related companies fields.
For example:
Category Id | Category Name | Related Companies
1 | Web development | 1 2 3 12 10
So problem is the hints which appears when user types includes categories which doesn’t contains companies of that particular city but have companies from other cities. i mean i user selects city 'abc' and enters category computer but there is no company in abc city in realtion with computer, so i want hint shall not show, if the category don't have a company from the city abc.

Options: ReplyQuote


Subject Written By Posted
Portal Database design help Shine Jones 04/27/2009 12:12AM
Re: Portal Database design help Rick James 04/30/2009 01:19AM
Re: Portal Database design help Shine Jones 04/30/2009 04:50AM
Re: Portal Database design help Rick James 04/30/2009 11:12PM
Re: Portal Database design help Shine Jones 05/01/2009 01:14AM
Re: Portal Database design help Rick James 05/01/2009 09:39PM
Re: Portal Database design help Shine Jones 05/01/2009 11:20PM
Re: Portal Database design help Rick James 05/02/2009 12:47PM
Re: Portal Database design help Shine Jones 05/03/2009 10:52PM
Re: Portal Database design help Shine Jones 05/07/2009 11:21PM
Re: Portal Database design help Rick James 05/07/2009 11:52PM
Re: Portal Database design help Shine Jones 05/08/2009 01:08AM
Re: Portal Database design help Shine Jones 05/08/2009 01:09AM
Re: Portal Database design help Rick James 05/08/2009 08:51AM
Re: Portal Database design help Shine Jones 05/08/2009 11:43PM
Re: Portal Database design help Rick James 05/09/2009 12:50AM
Re: Portal Database design help Shine Jones 05/09/2009 02:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.