Re: same sequence as primary key in more than one table

From: student4life <student4lifer_at_gmail.com>
Date: Mon, 15 Jun 2009 09:51:53 -0700 (PDT)
Message-ID: <2acadcc0-07de-4f08-8622-5f2008df613e_at_j9g2000prh.googlegroups.com>

On Jun 15, 6:41 am, DeB <debashish.majum..._at_gmail.com> wrote:
> There wont be any issue as long as the the relationships between the
> tables are maintained. I've not seen such an approach in practice so
> far. You would be doing much better if you have a sequence for each
> table rather than having one.
>
> --
> Cheers
> DeB

Would you know if the common practice of generating a separate sequence number for each table as primary key is the best practice under this scenario? To do it this way, I see that 2 more columns need to be added to the tables (1 for 'buyers' table and 1 for 'sellers' table, for example) as their foreign keys that contain the same value as the primary key in table 'users'? This would free these tables to have their own independent sequence values as primary keys. Thanks. Received on Mon Jun 15 2009 - 11:51:53 CDT