RE: Extropian finder service?

From: Alejandro Dubrovsky (
Date: Thu Feb 17 2000 - 22:29:59 MST

i'll give the tables' structure a shot. criticise/modify at will
I = identity
N = Not null

Members table

Member id - N I
Name - N
Date Joined

Interests Table

Interest id - N I
Name - N

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