RE: Extropian finder service?

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 2b29 : Thu Jul 27 2000 - 14:03:53 MDT