Databasing sponsors - Mailing list pgsql-www

From Joshua D. Drake
Subject Databasing sponsors
Date
Msg-id 20080403101150.56301a10@commandprompt.com
Whole thread Raw
Responses Re: Databasing sponsors  (Oleg Bartunov <oleg@sai.msu.su>)
Re: Databasing sponsors  (Josh Berkus <josh@agliodbs.com>)
List pgsql-www
-----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?

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-----

pgsql-www by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Mailing list lists
Next
From: Oleg Bartunov
Date:
Subject: Re: Databasing sponsors