an
groups-icon

Database Structure Recommendation for Restaurant Directory

Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    Char Bri
    0 points
    Beginner

    Hi,
    We are planning the database structure for a restaurant directory.

    These are the main fields:
    FoodType (15 different types)
    City (78 cities)
    Setting (casual, elegant, and 5 more)

    We also plan to add the following fields:
    Telephone
    Hours of Operation
    Price Range (4 different ranges)
    Physical location

    Should we create 3 different CATEGORIES for the first three fields listed above (FoodType, City, Setting)?

    Should we create a checkbox custom field named Amenities and include the rest of the items (Telephone, Hours of Operation, Price Range, Physical location) or simply create different fields for (Telephone, Hours of Operation, Price Range, Physical location)?

    What about taxonomies?

    What we plan is to have in the homepage three pulldown menus so that users can choose from the 3 different CATEGORIES for the first three fields listed above (FoodType, City, Setting).

    First select FoodType, then they select City, and then they select Setting and click on Search button.

    Any recommendations will be highly appreciated.

    Thanks.

    September 22, 2013 at 1:13 pm
  • Malgorzata Szalata
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    September 22, 2013 at 2:29 pm
  • Danie Strydom
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    September 22, 2013 at 2:33 pm
  • Danie Strydom
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    September 22, 2013 at 2:35 pm
  • Char Bri
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    September 23, 2013 at 12:17 am
  • Char Bri
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    October 13, 2013 at 1:48 am
  • Malgorzata Szalata
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    October 13, 2013 at 3:59 am
  • Danie Strydom
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    October 13, 2013 at 8:15 am
  • Char Bri
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    October 15, 2013 at 12:41 am
  • Char Bri
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    October 15, 2013 at 12:53 am

304

Views

9

Replies