CalendarContract.CalendarAlertsColumns

ALARM_TIME

String ALARM_TIME

The alarm time of the event, in UTC. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "alarmTime"

BEGIN

String BEGIN

The start time of the event, in UTC. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "begin"

CREATION_TIME

String CREATION_TIME

The creation time of this database entry, in UTC. Useful for debugging missed reminders. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "creationTime"

DEFAULT_SORT_ORDER

String DEFAULT_SORT_ORDER

The default sort order for this alerts queries

Constant Value: "begin ASC,title ASC"

END

String END

The end time of the event, in UTC. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "end"

EVENT_ID

String EVENT_ID

The event that the alert belongs to. Column name.

Type: INTEGER (foreign key to the Events table)

Constant Value: "event_id"

MINUTES

String MINUTES

The number of minutes that this alarm precedes the start time. Column name.

Type: INTEGER

Constant Value: "minutes"

NOTIFY_TIME

String NOTIFY_TIME

The time that the notification was created by the Calendar app, in UTC. Useful for debugging missed reminders. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "notifyTime"

RECEIVED_TIME

String RECEIVED_TIME

The time that the alarm broadcast was received by the Calendar app, in UTC. Useful for debugging missed reminders. Column name.

Type: INTEGER (long; millis since epoch)

Constant Value: "receivedTime"

STATE

String STATE

The state of this alert. It starts out as STATE_SCHEDULED, then when the alarm goes off, it changes to STATE_FIRED, and then when the user dismisses the alarm it changes to STATE_DISMISSED. Column name.

Type: INTEGER

Constant Value: "state"

STATE_DISMISSED

int STATE_DISMISSED

Once the user has dismissed the notification the alert's state should be set to dismissed so it is not fired again.

Constant Value: 2 (0x00000002)

STATE_FIRED

int STATE_FIRED

After a notification for an alert has been created it should be updated to fired.

Constant Value: 1 (0x00000001)

STATE_SCHEDULED

int STATE_SCHEDULED

An alert begins in this state when it is first created.

Constant Value: 0 (0x00000000)