While this table does not have a field defined as a primary key, the USEROAUTHPROVIDERID field should be unique and considered as a primary key.
Added in Version 8.1
The USER_OAUTHTOKEN table stores user authorization tokens for each OAuth provider for whom the user has approved access. Added for integration functionality.
|
|
While this table does not have a field defined as a primary key, the USEROAUTHPROVIDERID field should be unique and considered as a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USEROAUTHPROVIDERID |
STANDARDID |
NOT NULL |
USER_OAUTHTOKEN_PRIMARY (AK) |
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
USERID |
STANDARDID |
NULLS |
|
|
|
|
OAUTHPROVIDERID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
REFRESHTOKEN |
varchar (128) |
NULLS |
|
|
|
|
PARENTACCOUNTUUID |
varchar (36) |
NULLS |
|
|
|
|
ACCOUNTLOGINNAME |
varchar (128) |
NULLS |
|
|
|
|
APPID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
ACCESSTOKEN |
varchar (255) |
NULLS |
|
|
|
|
ACCESSTOKENSECRET |
varchar (255) |
NULLS |
|
|
|
|
EXPIRATIONDATE |
datetime |
NULLS |
|
|
|