i'll give the tables' structure a shot. criticise/modify at will
(Notes:
I = identity
N = Not null
)
Members table
Member id - N I
Name - N
Date Joined
Email
Phone
Address
Interests Table
Interest id - N I
Name - N
Description
Member's Interest Tabe
Member ID - N I (linked to members table) -\ Joint Identity
Interest ID - N I ( linked to interests table) -/
Interests Relationship table
InterestParent ID - N I (both linked to interest table) -\ Joint identity
InterestChild ID - N I -/
Interests linked in a hierarchical many to many so that you can get to a
specific interest through many paths
(eg Nanotech investment through Nanotech -> Nanotech Investment and
through Investment->Nanotech Investment)
This archive was generated by hypermail 2b29 : Thu Jul 27 2000 - 14:03:53 MDT