Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Data (Table) Structure Question
- From: "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com>
- To: "Pgsql-Novice-Owner" <pgsql-novice-owner(at)postgresql(dot)org>
- Subject: Re: Data (Table) Structure Question
- Date: Fri, 24 Nov 2006 10:57:05 -0000
Hi, The second structure is more normalised and it's a good rule of thumb to normalise your data. Does anything else need to be split out? For instance can a person have more than 1 address? Do you need an address history? Regards Duncan
- Prev by Date: Re: Using a serial primary key as a foreign key in a second table
- Next by Date: Re: Using a serial primary key as a foreign key in a second
- Previous by thread: Using a serial primary key as a foreign key in a second table
- Next by thread: Partitioning
- Indexes: