Folks,

I have situation in which a row might have a relationship other rows. I am sure someone has had this scenario - An example would be better to clarify:


Lets say we have a club object. A club has person as member and a person has family members that are also automatically part of the club.

Club
|
+- List of person (club members)


Person
|
+ List of person (family members)

How could I annotate that scenario ?

Class Club
{
List<Person> member;

@What is the annotation ?
g/set(){}
}

Class Person
{

List<Person> familyMembers;

g/set(List<Person> familyMembers){}
}

how about using a third table to store the relationship between person and person?

The person table already contain a column that is the value of the "parent" person on the relationship.

Person
+--------------------------------+
| id | pid | name <etc> |
+--------------------------------+
| 1 | 0 | Daddy |
+--------------------------------+
| 2 | 1 | Son |
+--------------------------------+
| 3 | 1 | daughter |
+--------------------------------+


Thanks for the reply, though.


harringf

It looks like a many-to-one relationship but I kinda feel creepy with this design. Consider using a relationship table if you have the option.

Fazard,

Thanks for the quick reply. Unfortunately, that is not an option.

harringf

I'm completely confused by this. Harringf, what is the issue you are encountering? I can't think of an issue here. What is your question? Could you explain it better so maybe I can provide better feedback? You can map a given type to itself, that should not be an issue.