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