Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Need database structure help.

    Hi,

    For the website, www.somethingspecialgiftbaskets.com I am going to rebuild it using a database to handle the content. I am going to be using coldfusion mx as my databasing language. It will be through mysql

    Problem I am running into is setting up a database structure for something like this. I will be honest, I have never put a database together in terms of mysql, access, or whatever.

    I plan on making it so that the owner of the site can edit content through forms on the web, rather then making me change it every other week.

    Currently, the menu on that site is being pulled with SSI, but if I go to a database, i think I am able to just do this using database tables, I am not sure. This is where I need some help.

    The basic structure of the site is as follows

    Main Page - Description and a featured content section and menu

    Sub Menu selection - Meaning, when someone picks a basket category, they are taken to a page with the available style baskets for that category, but still keeping the menu where its at. This is done for every category

    Basket Content page - This is where an image of the basket is shown, along with a brief description, contents, and a price. This page in particular will be one of the reasons for allowing the owner to use a form.

    I believe thats all, because the other pages, PRIVACY POLICY, CONTACT, etc.. don't have much dynamic stuff going on.

    So I should have 3 template pages (mentioned above) and the rest of the site which is PRIVACY POLICY, etc..

    When I say I am struggling with the structure, I mean I am not really sure how the tables should be setup and related to each other.

    Here is so far what I have in mind

    DATABASE: giftbaskets
    TABLES:

    BASKETS

    basketid
    basketname
    summary
    smallimagepath
    largeimagepath
    price
    size

    MENU

    anyoccasion
    baby
    birthday
    congratulations
    getwell
    gourmet
    graduation
    housewarming
    junkfood
    pamperher
    pamperhim
    overthehill
    retirement
    sports
    thankyou
    wedding
    custom
    links

    FEATURED

    basketID
    imagepath
    basketname

    MAINPAGE

    description

    obviously the capital letters are the table names.

    If you feel you are able to help me in improving this current structure, and/or completely changing it, I would really appreciate it.

    Thank you
    Bryan

    I am also using Mysql-front 2.5, and I am running into problems when I try picking data types for certain fields.

    I am not sure what to put for data types such as blob (like default value, etc..) for something like field summary. Then for a price, would I use float (5,2) or something like that, to represent 5 digits, 2 decimals?
    Last edited by jag5311; 09-19-03 at 10:59.

  2. #2
    Join Date
    Sep 2003
    Posts
    3

    data dictionary

    Can you help me...
    I need the data dictionary for my sql,...

    do you know about ALL_TABLES / ALL_CONSTRAINTS for my sql the same way oracle has???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •