Link to home
Start Free TrialLog in
Avatar of Panos
PanosFlag for Germany

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.

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

ASKER

Hi Icohan.
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.)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

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.