Re: [seul-edu] People Resource Fields

[Les Richardson <richl@mail.tfsd.sk.ca>]

At 06:21 PM 12/21/01 -0800, you wrote:
>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 would tend to think that it will be open for people to volunteer and add
a record. But updates/changes/deletions would be by designated manager or
the like. I would also anticipate a moderation process and mailback
verification also.


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

Media Flag is an excellent suggestion. 


Les Richardson
H. Hardcastle School



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