Re: FK -> non PK - bad design?
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 8 Apr 2003 20:29:13 -0700
Message-ID: <6dae7e65.0304081929.34e4f8b2_at_posting.google.com>
Date: 8 Apr 2003 20:29:13 -0700
Message-ID: <6dae7e65.0304081929.34e4f8b2_at_posting.google.com>
otis_usenet_at_yahoo.com (OtisUsenet) wrote in message news:<5606b639.0304072055.29001bfe_at_posting.google.com>...
[...]
>
> CREATE TABLE service_plan
> (
> id SERIAL
> CONSTRAINT pk_service_plan_id PRIMARY KEY ,
> type INTEGER NOT NULL UNIQUE
> ...
> );
>
>
since type is unique, what is the purpose of id?
/Lennart Received on Wed Apr 09 2003 - 05:29:13 CEST