Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id F1E102E00B1 for ; Thu, 3 Apr 2008 16:23:05 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87693-09 for ; Thu, 3 Apr 2008 16:22:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sn.sai.msu.ru (sn.sai.msu.ru [195.208.220.215]) by developer.postgresql.org (Postfix) with ESMTP id 44DEE2E0049 for ; Thu, 3 Apr 2008 16:23:00 -0300 (ADT) Received: from sn.sai.msu.ru (localhost [127.0.0.1]) by sn.sai.msu.ru (8.14.1/8.12.8) with ESMTP id m33JMrG1004258; Thu, 3 Apr 2008 23:22:53 +0400 Received: from localhost (megera@localhost) by sn.sai.msu.ru (8.14.1/8.12.8/Submit) with ESMTP id m33JMrKW004255; Thu, 3 Apr 2008 23:22:53 +0400 X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs Date: Thu, 3 Apr 2008 23:22:53 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@sn.sai.msu.ru To: "Joshua D. Drake" cc: pgsql-www@postgresql.org Subject: Re: Databasing sponsors In-Reply-To: <20080403101150.56301a10@commandprompt.com> Message-ID: References: <20080403101150.56301a10@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.575 tagged_above=0 required=5 tests=AWL=-1.550, DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: X-Archive-Number: 200804/20 X-Sequence-Number: 14768 On Thu, 3 Apr 2008, Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > > I am in the process of databasing the /sponsors page. These are my > initial thoughts: > > sponsor table: > > id - serial pk > stype - the type of sponsor > description - how they sponsor > > sponsor_type: > > stype: the type of sponsor (pk) > > developer_to_sponsor: > > developer_id, key to developers.id > sponsor_id, key to sponsors.id > > Anybody see any problem with this? you forget about 'what they sponsored'. > > Sincerely, > > Joshua D. Drake > > > > > - -- > The PostgreSQL Company since 1997: http://www.commandprompt.com/ > PostgreSQL Community Conference: http://www.postgresqlconference.org/ > United States PostgreSQL Association: http://www.postgresql.us/ > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFH9Q/ZATb/zqfZUUQRAqVwAJ4u2PUuBcYyfLh11yyfTrf0znD6KwCfUOWn > DJKUFVKItqUyKU5Bb6SHs5Q= > =hd7/ > -----END PGP SIGNATURE----- > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83