tables and binary links

Bart Pietercil bart.pietercil at gmail.com
Fri Feb 9 10:53:10 CST 2007


Hi List,

could somebody please confirm that I understood the use of tables and  
binary links correctly in this case

Schema:

Organisations --> cells <----members (personnel)

one additional table "listvalues"

rec_id,list_id,menuvalue


cells in classic db design would have been something like this

cell_id (pk)
cell_name (varchar)
fk_org (fk)
cell_type = alistvalue
cell_status = another listvalue
parent_cell_id --> selfrelation to get a hierarchy structure

in valentina using binary links this (I think) would be

Table cells

cell_name

binary links
lnk_org:organisation 1:M cells
lnk_celltype:listvalues 1:M cells
lnk_cellstatus:listvalues 1:M cells
lnk_parent:cells 1:M cells

So I only have 1 field and 4 binary links

Have I understood this correctly (or is it back to the manual?)

TIA

Bart Pietercil


More information about the Valentina mailing list