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.
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.
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.
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?