Documentation  |   Table of Contents   |  < Previous   |  Next >   |  Index

3    Address Book Schemas

Palm OS® File Formats

Exploring Palm OS®

This chapter describes the format of the Address Book schemas. For more information on working with schema databases, see Exploring Palm OS: Memory, Databases, and Files.

The Address Book schema is split in 5 parts:

  • Home information (Personal Group):
  • Business information (Business Group):
  • Other information (Other Group):
  • Address Book information:
  • Locale information:

Home Information ^TOP^

The Home information (Personal Group) of the AddressBookDBSchema database encompasses the reserved ID range of 100 - 2900.

The column ID ranges are defined in this way:

  • Range 0 - 15999 reserved for PalmSource
  • Range 16000 - 19999 reserved for developers
  • Range 20000 - 32735 reserved for licensees

Subranges should be defined by licensees

Table 3.1  AddressBookDBSchema Home Information  

Column Name

Col ID

Description

Type

Size

Title

100

Name Prefix

VarChar

256

Last Name

200

Last Name

VarChar

256

Middle Name

300

Middle Name

VarChar

256

First Name

400

First Name

VarChar

256

Suffix

500

Name Suffix

VarChar

256

Nickname

600

Nickname

VarChar

256

Profession

700

Profession of the person

VarChar

256

Phone

800

Home phone number

VarChar

256

Mobile

900

Personal mobile phone number

VarChar

256

Fax

1000

Personal fax number

VarChar

256

Email 1

1100

First personal email

VarChar

256

Email 2

1200

Second personal email

VarChar

256

Email 3

1300

Third personal email

VarChar

256

Street

1400

Personal address: Street Name

VarChar

256

City

1500

Personal address: City Name

VarChar

256

State

1600

Personal address: State Name

VarChar

256

ZipCode

1700

Personal address: Zip code number

VarChar

256

Country

1800

Personal address: Country Name

VarChar

256

Anniversary

1900

Anniversary date

Date

-

Birthday

2000

Birthday of the person

Date

-

Business Information ^TOP^

The Business information (Business Group) of the AddressBookDBSchema database encompasses the reserved ID range of 3000 - 5900.

The column ID ranges are defined in this way:

  • Range 0 - 15999 reserved for PalmSource
  • Range 16000 - 19999 reserved for developers
  • Range 20000 - 32735 reserved for licensees

Subranges should be defined by licensees

Table 3.2  AddressBookDBSchema Business Information  

Column Name

Col ID

Description

Type

Size

Company

3000

Company Name

VarChar

256

Title

3100

Title/Role in the company

VarChar

256

Street

3200

Business address: Street Name

VarChar

256

City

3300

Business address: City Name

VarChar

256

State

3400

Business address: State Name

VarChar

256

ZipCode

3500

Business address: Zip code number

VarChar

256

Country

3600

Business address: Country Name

VarChar

256

Phone

3700

Business phone number

VarChar

256

Mobile

3800

Business mobile phone number

VarChar

256

Fax

3900

Business fax number

VarChar

256

Email

4000

Business email address

VarChar

256

Assistant Name

4100

Assistant Name

VarChar

256

Assistant Phone

4200

Assistant phone number

VarChar

256

Other Information ^TOP^

The Other information (Other Group) of the AddressBookDBSchema database encompasses the reserved ID range of 6000 - 8900.

The column ID ranges are defined in this way:

  • Range 0 - 15999 reserved for PalmSource
  • Range 16000 - 19999 reserved for developers
  • Range 20000 - 32735 reserved for licensees

Subranges should be defined by licensees

Table 3.3  AddressBookDBSchema Other Information

Column Name

Col ID

Description

Type

Size

Street

6000

Other address: Street Name

VarChar

256

City

6100

Other address: City Name

VarChar

256

State

6200

Other address: State Name

VarChar

256

ZipCode

6300

Other address: Zip code number

VarChar

256

Country

6400

Other address: Country Name

VarChar

256

Phone

6500

Other phone number

VarChar

256

Mobile

6600

Other mobile phone number

VarChar

256

Fax

6700

Other fax number

VarChar

256

Pager

6800

Pager number

VarChar

256

Custom 1

6900

Custom field 1

VarChar

256

Custom 2

7000

Custom field 2

VarChar

256

Custom 3

7100

Custom field 3

VarChar

256

Custom 4

7200

Custom field 4

VarChar

256

ICQ

7500

ICQ identifier

VarChar

256

AIM

7600

AIM identifier

VarChar

256

Yahoo

7700

Yahoo identifier

VarChar

256

MSN

7800

MSN identifier

VarChar

256

Jabber

7900

Jabber identifier

VarChar

256

URL

8500

URL

VarChar

256

Address Book Information ^TOP^

The Address Book information of the AddressBookDBSchema database encompasses the reserved ID range of 9000 - 9900.

The column ID ranges are defined in this way:

  • Range 0 - 15999 reserved for PalmSource
  • Range 16000 - 19999 reserved for developers
  • Range 20000 - 32735 reserved for licensees

Subranges should be defined by licensees

Table 3.4  AddressBookDBSchema Address Book Information

Column Name

Col ID

Description

Type

Size

Note

9000

Note

VarChar

256

Display Phone

9100

Column ID of the default phone

UInt32

-

Last Viewed Tab ID

9200

Last visited tab

UInt32

-

Locale Information ^TOP^

The Locale information of the AddressBookDBSchema database encompasses the reserved ID range of 10000 - 12000.

The column ID ranges are defined in this way:

  • Range 0 - 15999 reserved for PalmSource
  • Range 16000 - 19999 reserved for developers
  • Range 20000 - 32735 reserved for licensees

Subranges should be defined by licensees

Table 3.5  AddressBookDBSchema Locale Information

Column Name

Col ID

Description

Type

Size

Yomi Last Name

10000

Japanese Yomi Last Name

VarChar

256

Yomi First Name

10100

Japanese Yomi First Name

VarChar

256

Yomi Company

10200

Japanese Yomi Company Name

VarChar

256

English Name

11000

Chinese English Name

VarChar

256

Application Information Block ^TOP^

The AddressBookDBSchema database also has an appInfo block in which information specific to the Address Book is stored.

Table 3.6  AddressBookAppInfo

Column

Col ID

Description

Type

Size

Country

100

User choice of the device country

UInt16

-