While this table does not have a field defined as a primary key, the OAUTHPROVIDERID field should be unique and considered as a primary key.
Added in Version 8.1
The OAUTHPROVIDER table stores the set of OAuth providers available to the system and to users. Added for integration functionality.
|
|
While this table does not have a field defined as a primary key, the OAUTHPROVIDERID field should be unique and considered as a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OAUTHPROVIDERID |
STANDARDID |
NOT NULLS |
OAUTHPROVIDER_PRIMARY (AK) |
(Many) to (One) |
|
|
(One) to (Many) |
|||||
|
(Many) to (One) |
|||||
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
|
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
CLIENTID |
varchar (128) |
NULLS |
|
|
|
|
SECRET |
varchar (32) |
NULLS |
|
|
|
|
PROVIDERNAME |
varchar (32) |
NULLS |
|
|
|
|
USERAPPROVALURL |
varchar (128) |
NULLS |
|
|
|
|
REFRESHTOKENURL |
varchar (128) |
NULLS |
|
|
|
|
HOST |
varchar (64) |
NULLS |
|
|
|
|
USERAPPROVALMETHOD |
varchar (10) |
NULLS |
|
|
|
|
USERAPPROVALDATA |
varchar (256) |
NULLS |
|
|
|
|
ACCESSTOKENURL |
varchar (64) |
NULLS |
|
|
|
|
ACCESSTOKENMETHOD |
varchar (10) |
NULLS |
|
|
|
|
ACCESSTOKENDATA |
varchar (256) |
NULLS |
|
|
|
|
REFRESHTOKENMETHOD |
varchar (10) |
NULLS |
|
|
|
|
REFRESHTOKENDATA |
varchar (256) |
NULLS |
|
|
|
|
REQUIRESACCESSTOKEN |
char (1) |
NULLS |
|
|
|
|
REQUIRESREFRESHTOKEN |
char (1) |
NULLS |
|
|
|
|
ACTIVE |
char (1) |
NULLS |
|
|
|
|
PROVIDERKEY |
varchar (32) |
NULLS |
|
|
|
|
ENDPOINTURL |
varchar (256) |
NULLS |
|
|
|
|
OATHVERSION |
varchar (5) |
NULLS |
|
|
|
|
REQUESTTOKENMETHOD |
varchar (10) |
NULLS |
|
|
|
|
REQUESTTOKENURL |
varchar (128) |
NULLS |
|
|
|
|
SUPPORTSCALLBACK |
varchar (1) |
NULLS |
|
|
|
|
STANDARDID |
NULLS |
OAUTHPROVIDER_INTEGRATIONID (IE) |
(Many) to (One) |
||
|
SYNCHANDLER |
varchar (128) |
NULLS |
|
|
|
|
SCOPES |
varchar (255) |
NULLS |
|
|
|