public inbox for [email protected]  
help / color / mirror / Atom feed
From: Oleg Bartunov <[email protected]>
To: Joshua D. Drake <[email protected]>
Cc: [email protected]
Subject: Re: Databasing sponsors
Date: Thu, 3 Apr 2008 23:22:53 +0400 (MSD)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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: [email protected], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83



view thread (20+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Databasing sponsors
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox