Re: Databasing sponsors

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 3 Apr 2008 16:15:45 -0700
Josh Berkus <josh@agliodbs.com> wrote:

> Josh,
> 
> > sponsor table:
> >
> > id - serial pk
> > stype - the type of sponsor
> > description - how they sponsor
> name - sponsor name

Doh... I had that on my screen, don't know why I didn't paste.

> link - sponsor link

Sure.

> image - sponsor logo image location

Sure.

> location - sponsor location (of HQ, if appropriate)

If we are doing that, I want full info (address, contact etc.. not
exposed of course).

> source - source of sponsor information

What type of source are we talking about here?

> 
> 
> > sponsor_type:
> >
> > stype: the type of sponsor (pk)
> 

We need to add a sort column here, so we know which one shows first.


> I'd like to expand this system to cover doing the full sponsor
> breakdown we discussed and approved 1.5 years ago but never
> implemented.  So as long as I can stuff giving categories into

Let's not get ahead of ourselves. It was discussed, it was never
approved and as you are fully aware I had reservations about it.
Further later in conversations we discussed a different scenario.
However, this is a technical discussion and we can get into those
details later.

> "stype", I'm good with it.
> 

Which we will be able to do.

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)

iD8DBQFH9YK+ATb/zqfZUUQRAib8AKCraSkCKtnqWbs0dIGTveQwrxnP0QCfWp8i
X6ItZbCP2cY0nA/DOhBnS6U=
=VZp2
-----END PGP SIGNATURE-----