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.