Re: [SQL] Table Relationships

[Curtis Scheer]

Thanks for the help.   From: Aaron Bono [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 31, 2006 2:44 PM To: A. Kretschmer Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Table Relationships   On 10/31/06, A. Kretschmer <[EMAIL PROTECTED]> 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 ==================================================================