AW: need some DB design coaching

Robert Brenstein rjb at robelko.com
Fri Mar 4 05:25:02 CST 2011


On 04.03.2011 at 8:53 Uhr +0100 Tiemo Hollmann TB apparently wrote:
>
>Just because I have never done it before J
>

I would suggest to actually have options list in another table and 
option value list in yet another table, so nothing is hardwired so to 
speak. Such lists tend to change upon time, so better to have more 
flexibility to start with than put extra work later.

table 1 - options
table 2 - option value + pointer to option
table 3 - items
table 4 - pointer to item + pointer to option value

Robert


More information about the Valentina mailing list