DB Design

[ferhanz]

i am working on a mobile entertainment portal, i am in a process of building the DB design, kindly help me out in making the table structure for the following Mobile information page

http://www.gsmarena.com/nokia_6680-1045.php

this page is similar to what i have in mind.

[bpat1434]

Well, I see 3 columns already:

1.) Category
[ General, Size, Display, etc.. ]
2.) Sub-Category
[ Network, Announced, Status, Dimensions, Weight, Type, Size, etc... ]
3.) Information/Text
[ UMTS / GSM 900 / GSM 1800 / GSM 1900, etc... ]

So, with that, you know you need an ID for each row, an image for each item, and comments. So I'd have tables like so:

info
id (INT) not null auto_increment
cat (int) not null
subcat (int) not null
information (medText)
image (medtext)

Categories
id (int) not null auto_increment
name (text)

Subcategories
id (int) not null auto_increment
parent (int) not null
name (text)

Comments
id (int) not null auto_increment
itemID (int) not null
user (text)
comment (medText)
added (DATETIME)

Something like that should work. then, just join categories, subcategories, and information tables, and give the results. Then, get all the comments from the comments table that correspond to the current itemID.

~Brett