Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | id | 18 | null |
|
|
Label: Activity ID |
||||||||
| WhoId | reference | 18 | null |
|
|
Label: Name ID |
||||||||
| WhatId | reference | 18 | null |
|
|
Label: Related To ID |
||||||||
| Subject | combobox | 255 | null |
|
|
Label: Subject |
||||||||
| Location | string | 255 | null |
|
|
Label: Location |
||||||||
| IsAllDayEvent | boolean | 0 | null |
|
|
Label: All-Day Event |
||||||||
| ActivityDateTime | datetime | 0 | null |
|
|
Label: Due Date Time |
||||||||
| ActivityDate | date | 0 | null |
|
|
Label: Due Date Only |
||||||||
| DurationInMinutes | int | 8 | null |
|
|
Label: Duration |
||||||||
| StartDateTime | datetime | 0 | null |
|
|
Label: Start Date Time |
||||||||
| EndDateTime | datetime | 0 | null |
|
|
Label: End Date Time |
||||||||
| Description | textarea | 32000 | null |
|
|
Label: Description |
||||||||
| AccountId | reference | 18 | null |
|
|
Label: Account ID |
||||||||
| OwnerId | reference | 18 | null |
|
|
Label: Assigned To ID |
||||||||
| IsPrivate | boolean | 0 | null |
|
|
Label: Private |
||||||||
| ShowAs | picklist | 40 | null |
|
|
Label: Show Time As |
||||||||
| IsDeleted | boolean | 0 | null |
|
|
Label: Deleted |
||||||||
| IsChild | boolean | 0 | null |
|
|
Label: Is Child |
||||||||
| IsGroupEvent | boolean | 0 | null |
|
|
Label: Is Group Event |
||||||||
| GroupEventType | picklist | 40 | null |
|
|
Label: Group Event Type |
||||||||
| CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||||||
| CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||||||
| LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||||||
| LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
||||||||
| SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
||||||||
| IsArchived | boolean | 0 | null |
|
|
Label: Archived |
||||||||
| RecurrenceActivityId | reference | 18 | null |
|
|
Label: Recurrence Activity ID |
||||||||
| IsRecurrence | boolean | 0 | null |
|
|
Label: Create Recurring Series of Events |
||||||||
| RecurrenceStartDateTime | datetime | 0 | null |
|
|
Label: Recurrence Start |
||||||||
| RecurrenceEndDateOnly | date | 0 | null |
|
|
Label: Recurrence End |
||||||||
| RecurrenceTimeZoneSidKey | picklist | 40 | null |
|
|
Label: Recurrence Time Zone |
||||||||
| RecurrenceType | picklist | 40 | null |
|
|
Label: Recurrence Type |
||||||||
| RecurrenceInterval | int | 9 | null |
|
|
Label: Recurrence Interval |
||||||||
| RecurrenceDayOfWeekMask | int | 9 | null |
|
|
Label: Recurrence Day of Week Mask |
||||||||
| RecurrenceDayOfMonth | int | 9 | null |
|
|
Label: Recurrence Day of Month |
||||||||
| RecurrenceInstance | picklist | 40 | null |
|
|
Label: Recurrence Instance |
||||||||
| RecurrenceMonthOfYear | picklist | 40 | null |
|
|
Label: Recurrence Month of Year |
||||||||
| ReminderDateTime | datetime | 0 | null |
|
|
Label: Reminder Date/Time |
||||||||
| IsReminderSet | boolean | 0 | null |
|
|
Label: Reminder Set |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FakeIndex75 | Must be unique | Asc | Id |