OAUTHPROVIDERSCOPE Table

Added in Version 8.1

The OAUTHPROVIDERSCOPE table stores the set of permissions the provider needs to be asked for. Added for integration functionality.

While this table does not have a field defined as a primary key, the OAUTHPROVIDERSCOPEID field should be unique and considered as a primary key.

Legend

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

OATHPROVIDERSCOPEID

STANDARDID

NOT NULL

OAUTHPROVIDERSCOPE_PRIMARY (AK)

 

 

OAUTHPROVIDERID (FK)

STANDARDID

NOT NULL

 

(Many) to (One)

OAUTHPROVIDER.OAUTHPROVIDERID

CREATEUSER (FK)

STANDARDID

NULLS

 

(Many) to (One)

USERINFO.USERID

CREATEDATE

datetime

NULLS

 

 

 

MODIFYUSER (FK)

STANDARDID

NULLS

 

(Many) to (One)

USERINFO.USERID

MODIFYDATE

datetime

NULLS

 

 

 

 SCOPE

varchar (128)

NULLS