From: Alejandro Dubrovsky (Alejandro.Dubrovsky@isholding.com)
Date: Thu Feb 17 2000 - 22:29:59 MST
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 2.1.5 : Fri Nov 01 2002 - 15:26:53 MST