Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: FK -> non PK - bad design?

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@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 Tue Apr 08 2003 - 22:29:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US