Re: Is having an "ID" column bad?
Posted by:
Cat B
Date: February 19, 2020 12:40PM
Peter Brawley Wrote:
-------------------------------------------------------
> > I have heard some people complain that giving
> > every table an ID is a terrible waste of space?!
>
> I disagree with that entirely.
So you see no issue with me giving every table an ID that is an INT AutoNumber?
And what about the two examples I provided above?
Is it okay to have my PK be the ID and then for things like junction tables have a combination UK/FK?
Subject
Written By
Posted
February 18, 2020 12:47PM
February 18, 2020 03:47PM
February 19, 2020 10:50AM
February 19, 2020 12:36PM
Re: Is having an "ID" column bad?
February 19, 2020 12:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.