Added in Version 8.1
The ActivityATTENDEE table stores additional contacts and leads for Activities. This table was added for multiple attendees per activity functionality.
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ACTIVITYATTENDEEID |
STANDARDID |
NOT NULL |
ACTIVITYATTENDEE_PRIMARY (AK) |
|
|
|
ACTIVITYID (FK) |
STANDARDID |
NOT NULL |
ACTIVITYATTENDEE_ACTIVITYID (IE) |
(Many) to (One) |
ACTIVITY.ACTIVITYID |
|
CREATEUSER |
STANDARDID |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER |
STANDARDID |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ENTITYID |
STANDARDID |
NULLS |
ACTIVITYATTENDEE_ENTITYID (IE) |
||
|
NAME |
varchar (255) |
NULLS |
|
||
|
ISPRIMARY |
varchar (1) |
NULLS |
|
||
|
ROLENAME |
varchar (64) |
NULLS |
|
||
|
STATUS |
varchar (64) |
NULLS |
|
||
|
|
varchar (128) |
NULLS |
|
||
|
PHONENUMBER |
varchar (32) |
NULLS |
|
||
|
STANDARDID |
NULLS |
|
|||
|
ACCOUNTNAME |
varchar (128) |
NULLS |
|
||
|
SLXUSERASSOCIATIONID |
STANDARDID |
NULLS |
|
||
|
NOTE |
Textblob |
NULLS |
|||
|
ENTITYTYPE |
varchar (64) |
NULLS |
|||
|
TIMEZONE |
varchar (64) |
NULLS |
|||
|
TITLE |
varchar (64) |
NULLS |
|||
|
DESCRIPTION |
varchar (255) |
NULLS |
|||
|
APPID (FK) |
char(12) |
NULLS |
(Many) to (One) | ||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|||
|
TICK |
int |
NULLS |
|||
|
ISATTENDEE |
varchar (1) |
NULLS |
|||
|
ATTENDEEFLAG |
varchar (64) |
NULLS |
