Hello all, Sorry about the slightly off-topic request, but table designs structures are not my strong point as of yet! :) I have a project we are working on, and have a rough draft put together before actually starting. I would greatly appreciate some feedback if improvements, changes or addition are needed. Referral Add Form: http://jyt.com/jyt/rs/add.html and Mock Search Results desired: http://jyt.com/jyt/rs/results.html Search Form: http://jyt.com/jyt/rs/search.html Basically a person fills out a referral form to add a company listing to the database for other to search on. The searches will be performed on Stats or Zipcodes using the business categories selected. All searches are done with the criteria on States or Zip codes and selecting a Business Category Referral Table which stores the info about the person filling out the form and only the refer_comments column will be included in the search result display from the contact and business_location table. All other referral info is for administration purpose only. Tables -------------- Referral info referral table: refer_id auto_increment primary key refer_fname refer_lname refer_email Business info business table: bus_id auto_increment primary key category_id INDEX busindex1 (category_id) bus_cfname bus_clname bus_name bus_address bus_hours bus_days bus_keywords bus_email bus_url bus_phone bus_comments (all fields will be included in the search results display if not empty(NULL) Business Location info busniess_location table: category_id city state zip INDEX busindex1(category_id) INDEX busindex2 (zip,category_id) INDEX busindex3 (state,category_id) (to store redundant data for all companies as there will be various companies with the same city or state or zip) All search queries are done on city or state by choosing a Business category Business Category category table: category_id PRIMARY KEY NOT NULL pricat seccat addcat (this table will be pre-loaded with all current categories/sub categories) then when a referral is added from the add form the category_id is pulled and entered into the business table. the Pri/Sec/Add columns are used for display purposes only: Arts>>Music>>Radio for the search display results when the search display is presented depending on the search criteria) Example +------------+------------+-------------+-------------+ category_id primcat seccat addcat +------------+------------+-------------+-------------+ AR Arts NULL NULL ARD Arts Dance NULL ARF Arts Fine Art NULL ARG Arts Galleries NULL ARM Arts Movies NULL ARMU Arts Music NULL ARMUO Arts Music Opera ARMUR Arts Music Radio ================================================ Again, appreciate any feedback from the list. Mickalo Mike(mickalo)Blezien ======================================== Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 ========================================= --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
