Re: Table Relationships

On 10/31/06, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
>
> am Tue, dem 31.10.2006, um 21:08:24 +0100 mailte A. Kretschmer folgendes:
> > am Tue, dem 31.10.2006, um 13:32:59 -0600 mailte Aaron Bono folgendes:
> > > I would go further by adding a type table like this:
> > >
> > > operation_type (
> > > operation_type_id bigserial (PK),
> >
> > You are sure, that you need bigserial?
>
> Hey, your idea is okay, but i think, we don't need *BIG*serial for this.
> Okay?
>
>
> Andreas

Sorry, just force of habbit. Serial works or you can just drop the id and
use the code as the primary key. You should at the very least put a unique
constraint on the code field.

--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================