Re: Schema

On Thu, 2002-02-14 at 00:01, Robert Mibus wrote:
> Just to get the ball rolling, here's a starting point for a contact
> manager:
>
> id int primary key
> fn text
> ln text
> company text
> phone_mobile_home text
> phone_mobile_work text
> phone_home text
> phone_work text
> fax_home text
> fax_work text
> email_home text
> email_work text

While we're at it why not try to be compatible with other major
contact-software. In my world that means evolution.

You would have
NAMES:
prefix (mr, mrs, dr ....)
given_name (first)
additional_name (middle)
family_name (last)
suffix (Sr, Jr, Esq ....)

File as
Job title
Organization

primary email
email2
email3

webpage

PHONE:
business
home
business fax
mobile
assistant
business2
callback
car
company
home2
home fax
isdn
other
other fax
pager
primary
radio
telex
TTY/TDD

(wow.. that's alot of phone-numbers.. let's not take all of them)

ADDRESSES
home, business, other
they each hold:

address
address2
po box
city
zip code
state/province
country

(this is really stupid for lot's of countries. In sweden for example
addresses are not arranged in the same way as it is in the US. But
that's ok anyway I think

Department
Office
Profession
Nickname
Birthday
Notes.

Apart from this you have "manager's name, assistant's name spouse,
anniversary" but I really don't think they are important...

Of course you should also be able to put them in categories.

I'm not saying gpe needs to support EVERYTHING that evolution does but
at least some of it.

/Erik
 

-- 
Erik Bågfors               | erik_at_bagfors.nu
Supporter of free software | GSM +46 733 279 273
fingerprint: 6666 A85B 95D3 D26B 296B 6C60 4F32 2C0B 693D 6E32