Advice on a table structure

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Advice on a table structure
Дата
Msg-id CAAY=A7-iQkriVmELMrAr7L3ebhkWBgBGqcZyKmxegFxJ2gD0SQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Advice on a table structure
Re: Advice on a table structure
Re: Advice on a table structure
Re: Advice on a table structure
Список pgsql-novice
Hi,

I have one table that stores data about persons with fields like:

---------------------------
PERSONS TABLE
---------------------------  
* Id
* Last name
* First name
* Gender
* Marital status
and other information that relates to a single person.

One person might have a husband if female, or a wife if a male. So I thought about adding a table that associates couples like this:

---------------------------  
COUPLES TABLE
---------------------------  
* Id
* Husband (represents an Id of PERSONS table)
* Wife  ( represents an Id of PERSONS table)

One restriction is that one person cannot have more than one spouse.
I also thought about adding a field to the PERSONS table specifying his/her spouse but it seems to me that this approach represents a kind of "circular" relation between 2 records.

I am writing to ask for advice about an optimal approach to model this situation.

Respectfully,
Jorge Maldonado



Libre de virus. www.avast.com

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Steve Tucknott (TuSol)"
Дата:
Сообщение: Re: LATIN9 - hex in varchar after convert
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: Advice on a table structure