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

4    Date Book Schemas

Palm OS® File Formats

Exploring Palm OS®

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

Table 4.1  DateBookDBSchema  

Column Name

Col ID

Description

Type

Size

Repeating Event

10

True if this is a repeating event.

Boolean

-

Untimed Event

20

True if this is an untimed event. (The start time is then 12:00 am in device time zone.)

Boolean

-

Start date & time

30

START time & date in posix epoch time. (UTC seconds since 1/1/1970.)

Int32 *

-

End date & time

40

END time & date in posix epoch time. (UTC seconds since 1/1/1970.)

Int32 *

-

Timezone

50

Timezone name ("US/Central" for example)

VarChar

32

Time advance

100

Advance in next unit (if set to 0xFF => no advance set)

Int8

-

Time advance unit

110

Advance unit (AlarmUnitType)

UInt8

-

Repeat type

200

Among repeatNone, repeatDaily, repeatWeekly, repeatMonthlyByDay, repeatMonthlyByDate, repeatYearly

UInt8

-

Repeat end date

210

END repeat date in posix epoch time. (UTC seconds since 1/1/1970.)

Int32 *

-

Repeat frequency

220

Frequency (for example, every 2 days if repeatType daily)

UInt8

-

Repeat On

230

monthlyByDay and repeatWeekly only (the days in week, or the day number in month)

UInt8

-

Repeat start of week

240

repeatWeekly only (Sunday / Monday)

UInt8

-

Exceptions dates

300

Exception dates in posix epoch time. (UTC seconds since 1/1/1970.) Only the day is extracted to get the exception day, the time in day is then discarded but is used for time zone computations.

UInt32 Vector

64Kb

Description string

400

Description

VarChar

256

Location string

410

Location

VarChar

32

Note string

420

Note

VarChar

64Kb

* Will be modified by the new DateTimeType column data type.