Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 6FFBF9FB3A5
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Oct 2006 16:43:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 22790-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Oct 2006 16:43:34 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174])
	by postgresql.org (Postfix) with ESMTP id 4BD3E9FB1E1
	for <pgsql-sql@postgresql.org>; Tue, 31 Oct 2006 16:43:34 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id 30so1366208ugc
	for <pgsql-sql@postgresql.org>; Tue, 31 Oct 2006 12:43:33 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=sES6cf+/RGSfQp5d/h6wa3PxWoSiWxlmo+dnrS1QkfFKBDMEKV1IawaeM05y2w01KM57ifRBkqtnJpxhCf+nBEB0d4XufxYkJg/Bp2NdnUTTjMq/gUJY+1SWmdWTwGxVCMWFdZ7aognDH4lTRHiW61ESLBEa/zW9kfTQN32nqkM=
Received: by 10.78.97.7 with SMTP id u7mr7445658hub;
	Tue, 31 Oct 2006 12:43:32 -0800 (PST)
Received: by 10.78.136.6 with HTTP; Tue, 31 Oct 2006 12:43:31 -0800 (PST)
Message-ID: <bf05e51c0610311243u6a1c05f7n263de118da4d2037@mail.gmail.com>
Date: Tue, 31 Oct 2006 14:43:31 -0600
From: "Aaron Bono" <postgresql@aranya.com>
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Subject: Re: Table Relationships
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20061031201344.GA13860@a-kretschmer.de>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_8735_17243317.1162327411979"
References: <031936836C46D611BB1B00508BE7345D04C02E82@gatekeeper.daycos.com>
	<20061031184843.GA12767@a-kretschmer.de>
	<bf05e51c0610311132w3bb1bb80i876750c9c5d8aee8@mail.gmail.com>
	<20061031200824.GA13785@a-kretschmer.de>
	<20061031201344.GA13860@a-kretschmer.de>
X-Google-Sender-Auth: 4c7b349e218858be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200610/255
X-Sequence-Number: 26644

------=_Part_8735_17243317.1162327411979
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 10/31/06, A. Kretschmer <andreas.kretschmer@schollglas.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
==================================================================

------=_Part_8735_17243317.1162327411979
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 10/31/06, <b class="gmail_sendername">A. Kretschmer</b> &lt;<a href="mailto:andreas.kretschmer@schollglas.com">andreas.kretschmer@schollglas.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
am&nbsp;&nbsp;Tue, dem 31.10.2006, um 21:08:24 +0100 mailte A. Kretschmer folgendes:<br>&gt; am&nbsp;&nbsp;Tue, dem 31.10.2006, um 13:32:59 -0600 mailte Aaron Bono folgendes:<br>&gt; &gt; I would go further by adding a type table like this:<br>
&gt; &gt;<br>&gt; &gt; operation_type (<br>&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; operation_type_id bigserial (PK),<br>&gt;<br>&gt; You are sure, that you need bigserial?<br><br>Hey, your idea is okay, but i think, we don't need *BIG*serial for this.
<br>Okay?<br><br><br>Andreas</blockquote></div><br>Sorry, just force of habbit.&nbsp; Serial works or you can just drop the id and use the code as the primary key.&nbsp; You should at the very least put a unique constraint on the code field.
<br clear="all"><br>-- <br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>&nbsp;&nbsp; 
<a href="http://codeelixir.com">http://codeelixir.com</a><br>==================================================================

------=_Part_8735_17243317.1162327411979--