Advice on a table structure - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Advice on a table structure
Date
Msg-id CAAY=A7-iQkriVmELMrAr7L3ebhkWBgBGqcZyKmxegFxJ2gD0SQ@mail.gmail.com
Whole thread Raw
Responses Re: Advice on a table structure  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Advice on a table structure  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Advice on a table structure  (David Roper <david.roper@me.com>)
Re: Advice on a table structure  (Mark Wallace <m.wallace@alumni.iu.edu>)
List 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 by date:

Previous
From: "Steve Tucknott (TuSol)"
Date:
Subject: Re: LATIN9 - hex in varchar after convert
Next
From: Gavin Flower
Date:
Subject: Re: Advice on a table structure