r11 - 28 Mar 2004 - 00:47:24 - BrianDouglasSkinnerYou are here: OSAF >  Projects Web  >  DevelopmentHome > ServicesWorkingGroup > ContentModelProject > ContactSchemaNotes

Misc. Notes about the Schema for Contacts


MARC

  • Lots of work has gone into a comprehensive yet standardized format for cataloging various kinds of data and making that catalog useable. For example take a look at the sections on cross references: http://www.loc.gov/marc/classification/eccdtref.html
  • Also you may want to look at the work done in codifying Community (as opposed to bibliographic) data (think of Chandler contacts record format questions): http://www.loc.gov/marc/community/eccitils.html#mrcm270
  • http://www.loc.gov/marc/ -- The MARC 21 formats are widely used standards for the representation and exchange of authority, bibliographic, classification, community information, and holdings data in machine-readable form. They consist of a family of five coordinated formats: MARC 21 Format for Authority Data; MARC 21 Format for Bibliographic Data; MARC 21 Format for Classification Data; MARC 21 Format for Community Information; and MARC 21 Format for Holdings Data. Each of these MARC formats is published separately to provide detailed field descriptions, guidelines for applying the defined content designation (with examples), and identification of conventions to be used to insure input consistency. The MARC 21 Concise Formats provide in a single publication a quick reference guide to the content designators defined in each MARC format. It provides a concise description of each field, each character position of the fixed-length data element fields, and of the defined indicators in the variable data fields. Descriptions of subfield codes and coded values are given only when their names may not be sufficiently descriptive. Examples are included for each field.


FoaF -- Friends of a Friend


vCard Schema notes

Bookmarks

the vCard schema

name field required cardinality type description
FN   required one TEXT full name -- all of the N fields concatenated
N   required one   name
  Family Name optional many TEXT  
  Given Name optional many TEXT  
  Additional Name optional many TEXT  
  Honorific Prefixes optional many TEXT  
  Honorific Suffixes optional many TEXT  
NICKNAME   optional many TEXT  
PHOTO   optional one BINARY or URL  
BDAY   optional one DATE or DATE-TIME birthday
ADR   optional one   postal address
  post office box optional many TEXT  
  extended address optional many TEXT  
  street address optional many TEXT  
  locality (e.g. city) optional many TEXT  
  region (e.g. state or province) optional many TEXT  
  postal code optional many TEXT  
  country name optional many TEXT  
LABEL   optional one TEXT full address -- all of the ADR fields concatenated
LABEL TYPE optional many ENUM values can be: 'dom', 'intl', 'postal', 'parcel', 'home', 'work', pref'
TEL   optional one PHONE-NUMBER example: 1-213-555-1234
TEL TYPE optional many ENUM values can be: 'home', 'msg', 'work', 'pref', 'voice', 'fax', 'cell', 'video', 'pager', 'bbs', 'modem', 'car', 'isdn', 'pcs', 'voice'
EMAIL   optional one TEXT example: foo@bar.com
EMAIL TYPE optional many ENUM values can be: 'internet', 'x400', 'pref'
MAILER   optional one TEXT a MIME X-Mailer value
TZ   optional one UTC-OFFSET example: "-5:00; EST; Raleigh/North America"
GEO   optional one    
  LAT required one FLOAT latitude
  LON required one FLOAT longitude
TITLE   optional one TEXT job title (e.g. "VP of Marketing")
ROLE   optional one TEXT job role (e.g. "Programmer")
LOGO   optional one BINARY or URL business card logo
AGENT   optional one VCARD or TEXT or URI another person who acts as an agent for this one
ORG   optional one   organization
  organization name optional one TEXT  
  organizational unit name optional many TEXT  
CATEGORIES   optional many TEXT app. specific categories (e.g. OSAF, LPFI)
NOTE   optional one TEXT free-form text notes
PRODID   optional one TEXT the product ID of the app that created this vCard object -- an ISO 9070 Formal Public Identifier
REV   optional one DATE or DATETIME like a last modified time
SORT-STRING   optional one TEXT a part of N or FN, used for sorting (e.g. "Smith")
SOUND   optional one BINARY or URI a sound
SOUND TYPE optional one TEXT specifies the audio format (e.g. MP3???)
UID   optional one BINARY or URI the UUID of the person or resource associated with the vCard, NOT the UUID of the vCard object (example: "URL:http://www.swbyps.restaurant.french/~chezchic.html"
UID TYPE optional one TEXT specifies the id format
URL   optional one URI a URL for the thing the vCard is about
VERSION   required one TEXT value must be "3.0" for vCard 3.0 data
CLASS   optional one TEXT an access classification like PUBLIC, PRIVATE, or CONFIDENTIAL
KEY   optional one BINARY or TEXT public key, or authentication certificate
KEY TYPE optional one TEXT specifies the public key format
X-FOO naming convention for adding ad-hoc attributes (in this case, the attribute FOO )
           
NAME   optional one TEXT display name
SOURCE   optional many URI how to find the source of this contact info (e.g. an address of an entry in an LDAP server)
PROFILE   optional one TEXT a "profile name": the type of entry that we're talking about (e.g. "vCard")


Chandler 0.1 Schema notes

ContactTemplate
name cardinality type
Name one string
Contact Method many ContactMethod
Header Attribute many string -- really AttributeDefinition -- ENUM: company, title, occupation, relationship, age, birthday, gender, sharing, reputation, interests
Body Attribute many string -- really AttributeDefinition -- ENUM: company, title, occupation, relationship, age, birthday, gender, sharing, reputation, interests

Contact
name cardinality type
Contact Type one string
Contact Name one ContactName
Contact Method many ContactMethod
Photo URL one string -- really URL
Group many string -- really Group (a Group of Contacts) -- user can add more
Header Attribute many string -- really AttributeDefinition -- ENUM: company, title, occupation, relationship, age, birthday, gender, sharing, reputation, interests
Body Attribute many string -- really AttributeDefinition -- ENUM: company, title, occupation, relationship, age, birthday, gender, sharing, reputation, interests
Company Name one string
Job Title one string
Occupation one string
Relationship one ENUM: friend, coworker, associate, husband, wife, mother, father, son, daughter, aunt, uncle, brother, sister
Age one string
Birthday one string
Gender one ENUM: male, female, unknown -- (user can add more)
Sharing one ENUM: public, private -- (user can add more)
Reputation one ENUM: trustworthy, reliable, honest, secure, unknown
Interests many ???

ContactName
name cardinality type
Full Name one string
Sort Name one string
PersonName
name cardinality type
First Name one string
Middle Name one string
Last Name one string
Nickname one string
Honorific one string
Suffix one string

ContactMethod
name cardinality type
Method Type one string -- ENUM: Cellphone, Home Address, Home Fax, Home Phone, Jabber ID, Main Email, Main Office Address, Main Phone, Note, Website, Work Address, Work Email, Work Fax, Work Phone -- (user can add more)
Description one string
Comment one string
Attributes many string -- really AttributeDefinition

Phone Attributes
name cardinality type
Phone Number one string

Email Attributes
name cardinality type
Email Address one string

Jabber Attributes
name cardinality type
Jabber Address one string

Website Attributes
name cardinality type
URL one string

Note Attributes
name cardinality type
Note one string

Postal Attributes
name cardinality type
street one string
line break one string
city one string
state one string
zip one string


Older MS Outlook contact fields

name type
Title  
FirstName  
MiddleName  
LastName  
Suffix  
Company  
Department  
JobTitle  
BusinessStreet  
BusinessStreet2  
BusinessStreet3  
BusinessCity  
BusinessState  
BusinessPostalCode  
BusinessCountry  
HomeStreet  
HomeStreet2  
HomeStreet3  
HomeCity  
HomeState  
HomePostalCode  
HomeCountry  
OtherStreet  
OtherStreet2  
OtherStreet3  
OtherCity  
OtherState  
OtherPostalCode  
OtherCountry  
AssistantsPhone  
BusinessFax  
BusinessPhone  
BusinessPhone2  
Callback  
CarPhone  
CompanyMainPhone  
HomeFax  
HomePhone  
HomePhone2  
ISDN  
MobilePhone  
OtherFax  
OtherPhone  
Pager  
PrimaryPhone  
RadioPhone  
TTYTDDPhone  
Telex  
Account  
Anniversary  
AssistantsName  
BillingInformation  
Birthday  
Categories  
Children  
DirectoryServer  
EmailAddress  
EmailType  
EmailDisplayName  
Email2Address  
Email2Type  
Email2DisplayName  
Email3Address  
Email3Type  
Email3DisplayName  
Gender  
GovernmentIDNumber  
Hobby  
Initials  
InternetFreeBusy  
Keywords  
Language1  
Location  
ManagersName  
Mileage  
Notes  
OfficeLocation  
OrganizationalIDNumber  
POBox  
Priority  
Private  
Profession  
ReferredBy  
Sensitivity  
Spouse  
User1  
User2  
User3  
User4  
WebPage  

Outlook also lets the user add user-defined fields. New fields can be of any of 11 types, and for each type there are a variety of display formats. Here are the types:

  • Text
  • Number
  • Percent
  • Currency
  • Yes/No
  • Date/Time
  • Duration
  • Keywords
  • Combination
  • Formula
  • Integer

MS Outlook 2002 adds more new contact fields

  • Account
  • ++Address Selected
  • ++Address Selector
  • Anniversary
  • Assistant's Name
  • Assistant's Phone
  • ++Attachment
  • Billing Information
  • Birthday
  • ++Business Address
  • Business Address City
  • Business Address Country
  • ++Business Address PO Box
  • Business Address Postal Code
  • Business Address State
  • Business Address Street
  • Business Fax
  • ++Business Home Page
  • Business Phone
  • Business Phone 2
  • Callback
  • Car Phone
  • Categories
  • Children
  • ++City
  • Company
  • Company Main Phone
  • ++Computer Network Name
  • ++Contacts
  • ++Country/Region
  • ++Created
  • ++Customer ID
  • Department
  • E-mail
  • E-mail 2
  • E-mail 3
  • E-mail Display As
  • E-mail Selected
  • E-mail Selector
  • E-mail2 Display As
  • E-mail3 Display As
  • Email Address Type
  • Email2 Address Type
  • Email3 Address Type
  • ++File As
  • First Name
  • ++Flag Status
  • ++Follow Up Flag
  • ++FTP Site
  • ++Full Name
  • Gender
  • Government ID Number
  • Hobbies
  • ++Home Address
  • Home Address City
  • Home Address Country
  • ++Home Address PO Box
  • Home Address Postal Code
  • Home Address State
  • Home Address Street
  • ++Home Fax
  • ++Home Phone
  • ++Home Phone 2
  • ++Icon
  • ++IM Address
  • ++In Folder
  • Initials
  • Internet Free/Busy Address
  • ISDN
  • Job Title
  • ++Journal
  • Language
  • Last Name
  • Location
  • ++Mailing Address
  • ++Mailing Address Indicator
  • Manager's Name
  • ++Message Class
  • Middle Name
  • Mileage
  • Mobile Phone
  • ++Modified
  • ++Nickname
  • Office Location
  • Organizational ID Number
  • ++Other Address
  • Other Address City
  • Other Address Country
  • ++Other Address PO Box
  • Other Address Postal Code
  • Other Address State
  • Other Address Street
  • Other Fax
  • Other Phone
  • ++Outlook Internal Version
  • ++Outlook Version
  • Pager
  • ++Personal Home Page
  • ++Phone 1 Selected
  • ++Phone 1 Selector
  • ++Phone 2 Selected
  • ++Phone 2 Selector
  • ++Phone 3 Selected
  • ++Phone 3 Selector
  • ++Phone 4 Selected
  • ++Phone 4 Selector
  • ++Phone 5 Selected
  • ++Phone 5 Selector
  • ++Phone 6 Selected
  • ++Phone 6 Selector
  • ++Phone 7 Selected
  • ++Phone 7 Selector
  • ++Phone 8 Selected
  • ++Phone 8 Selector
  • PO Box
  • Primary Phone
  • Private
  • Profession
  • Radio Phone
  • ++Read
  • ++Received Representing Name
  • Referred By
  • ++Reminder
  • ++Reminder Time
  • ++Reminder Topic
  • Sensitivity
  • ++Size
  • Spouse
  • ++State
  • ++Street Address
  • ++Subject
  • Suffix
  • Telex
  • Title
  • TTY/TDD Phone
  • User Field 1
  • User Field 2
  • User Field 3
  • User Field 4
  • Web Page
  • ++ZIP/Postal Code


Contributors

-- BrianDouglasSkinner - 04 Aug 2003, 17 Jan 2004

Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r11 < r10 < r9 < r8 < r7 | More topic actions
 
Open Source Applications Foundation
Except where otherwise noted, this site and its content are licensed by OSAF under an Creative Commons License, Attribution Only 3.0.
See list of page contributors for attributions.