Panos
asked on
Database structure
Hello experts.
I need help with database structure of a website where a client can insert and sell his car,truck,bike....a.s.o.
(lIke ww.mobile.de)
I have construct this using static cfm pages for all the inputs.
This is not flexible for changes i want to do with styling or validating a.s.o. and i don't know if this is the right way. That s why i desided to handle this with Database tables.
I post here a structure i have tried.
Please tell me your opinion and your suggestion.
I need help with database structure of a website where a client can insert and sell his car,truck,bike....a.s.o.
(lIke ww.mobile.de)
I have construct this using static cfm pages for all the inputs.
This is not flexible for changes i want to do with styling or validating a.s.o. and i don't know if this is the right way. That s why i desided to handle this with Database tables.
I post here a structure i have tried.
Please tell me your opinion and your suggestion.
Database tables
1.attributes
attr_id attr_type attr_pagetype subcategoryof attr_label attr_class attr_inputtype attr_validation
1 MAIN INSERT 0 NULL NULL NULL NULL
2 SUB INSERT 1 (label_of_input) Text (some_validation)
3 SUB INSERT 1 f.e. COLOUR Select (some_validation)
4 SUB INSERT 1 (label_of_input) Checkbox (some_validation)
6 MAIN INSERT 0 NULL NULL NULL NULL
7 SUB INSERT 6 (label_of_input) (Text/Select/Checkbox) (some_validation)
8 SUB INSERT 6 (label_of_input) (Text/Select/Checkbox) (some_validation)
....
45 MAIN SEARCH 0 NULL NULL NULL NULL
46 SUB SEARCH 45 (label_of_input) (Text/Select/Checkbox) (some_validation)
........
2.attributes_text
attr_id attr_text language
1 General attributes EN
1 Allgemeine Eigenschaften DE
......
3.attributes_options (for the selects)
attr_id option_value option_text language
3 1 Black EN
3 1 Schwarz DE
3 2 Red EN
3 2 Rot DE
......
4.mobiles
mobile_id mobile_text
1 car
2 truck
.......
5.mobiles_attributes
mobile_id attr_id attr_pagetype
1 1 INSERT
1 2 INSERT
1 3 INSERT
......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi David Johnson
Thank you for your comment.
It seems that either i'm going on with my structure or i have to hire some one.
Thank you for your comment.
It seems that either i'm going on with my structure or i have to hire some one.
ASKER
Sorry i could t check your comment earlier.
The posted link is a very simple example of a database structure as you allready have noticed.
If you take a look at the example page i posted (www.mobile.de) maybe you will iunderstand why i'm asking for help for the database structure. I'm not 100% sure that i'm doing it in the right way. (i'm thinking also for problems with hierarchcal data a.s.o.)