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