While this table does not have a field defined as a primary key, the APPID field should be unique and considered a primary key.
Added in version 7.5.4
The APPIDMAPPING table stores the GUID and EndPoint URL for integration synchronization.
|
|
While this table does not have a field defined as a primary key, the APPID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
APPID |
varchar(12) |
NOT NULL |
PK_APPID (I E) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
| (One) to (Many) | ACTIVITY.APPID | ||||
| (One) to (Many) | ACTIVITYATTENDEE.APPID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | GLOBALCHANGETRACKING.APPID | ||||
| (One) to (Many) | HISTORY.APPID | ||||
| (One) to (Many) | LEAD.APPID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
NAME |
varchar(128) |
NULLS |
|
|
|
|
ENDPOINTURL |
varchar(256) |
NULLS |
|
|
|
|
USERNAME |
varchar(64) |
NULLS |
|
|
|
|
PWD |
varchar(128) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
ENABLED |
varchar(1) |
NULLS |
|
|
|
|
RESTRICTTOSINGLEACCOUNT |
varchar(1) |
NULLS |
|
|
|
|
ERPMANAGESSO |
varchar(1) |
NULLS |
|
|
|
|
SYNCINTERVAL |
int |
NULLS |
|
|
|
|
ENABLEEMAILAUTH |
varchar(1) |
NULLS |
|
|
|
|
ISSYSTEMENDPOINT |
varchar(1) |
NULLS |
|
|
|
|
INTEGRATIONID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ISUSERENDPOINT |
varchar (1) |
NULLS |
|
|
|
|
OAUTHPROVIDERID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
USERID |
char(12) |
NULLS |
|
|
|