While this table does not have a field defined as a primary key, the USERINTEGRATIONMAPID field should be unique and considered a primary key.
Added in Version 8.1
The USERINTEGRATIONMAP table maintains a list of users which have authorized with a particular integration.
|
|
While this table does not have a field defined as a primary key, the USERINTEGRATIONMAPID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERINTEGRATIONMAPID |
STANDARDID |
NOT NULL |
INTEGRATION_PRIMARY (AK) |
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
INTEGRATIONID (FK) |
varchar (12) |
NULLS |
USERINTEGRATIONMAP_INTEGRATION (IE) |
(Many) to (One) |
|
|
APPID (FK) |
varchar (64) |
NULLS |
USERINTEGRATIONMAP_APPPID (IE) |
(Many) to (One) |
|
|
USERID (FK) |
STANDARDID) |
NULLS |
USERINTEGRATIONMAP_USERID (IE) |
(Many) to (One) |
|
|
EXTERNALIDENTIFIER |
varchar (128) |
NULLS |
|
|
|
|
ENABLED |
varchar (1) |
NULLS |
|
|
|
| EMAILADDRESS | varchar(128) | NULLS | |||
| AUTHENTICATION | varchar(255) | NULLS |