Re: Databasing sponsors

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