Re: [seul-edu] People Resource Fields

[William Abernathy <william@inch.com>]

If the database will be privately managed, then 3.33) Address and 3.67) phone 
number. If war dialing or mass-mailing are ever envisioned as future options, 
you might want to keep telephone area codes, international dialing prefixes, and 
zip or postal codes in separate fields as well.

I have some dated (Open Magazine, anyone?) contact information for Linux media 
types which could form the seed crystal of a media database. Whether or not a 
media database should be included in, or kept separate from, the main database I 
leave to the database designer's professional discretion. If it's included, 
though, I would imagine a Media flag (boolean) and comparable flags for other 
envisioned future uses might be appropriate.

--William Abernathy

Les Richardson wrote:

> If one is building a database to track our most valuable
> resource... people, what fields do we need? My list so far is:
> 1) Salutation (Mr., Ms., Sr., etc.)
> 2) First Name
> 3) Last Name
> 4) Email
> 5) Skills
> 6) Help Interests - areas in which help can be given.
> 7) Country - ISO Code
> 8) Location - City, etc.
> 9) Timestamp - (date of initial record entry/last update)
> 10) Project Memberships - xml fields of projects.
> 11) Availability - date that person is available to help out.
> 
> What else?
> 
> Les Richardson
> H. Hardcastle School
> 
> 
> 
>