sso_setting

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
name VARCHAR 50 null
service VARCHAR 75 null
clientId VARCHAR 255 √ NULL
clientSecret VARCHAR 255 √ NULL
oAuthGateway VARCHAR 75 √ NULL
ssoName VARCHAR 255 √ NULL
ssoXmlUrl VARCHAR 255 √ NULL
ssoUniqueAttribute VARCHAR 255 √ NULL
ssoMetadataFilename VARCHAR 255 √ NULL
ssoIdAttr VARCHAR 255 √ NULL
ssoUsernameAttr VARCHAR 255 √ NULL
ssoFirstnameAttr VARCHAR 255 √ NULL
ssoLastnameAttr VARCHAR 255 √ NULL
ssoEmailAttr VARCHAR 255 √ NULL
ssoDisplayNameAttr VARCHAR 255 √ NULL
ssoPhoneAttr VARCHAR 255 √ NULL
ssoPatronTypeAttr VARCHAR 255 √ NULL
ssoPatronTypeFallback VARCHAR 255 √ NULL
ssoAddressAttr VARCHAR 255 √ NULL
ssoCityAttr VARCHAR 255 √ NULL
ssoLibraryIdAttr VARCHAR 255 √ NULL
ssoLibraryIdFallback VARCHAR 255 √ NULL
ssoCategoryIdAttr VARCHAR 255 √ NULL
ssoCategoryIdFallback VARCHAR 255 √ NULL
loginOptions BOOLEAN 3 √ 0
loginHelpText VARCHAR 255 √ NULL
oAuthButtonBackgroundColor CHAR 7 √ '#232323'
oAuthButtonTextColor CHAR 7 √ '#ffffff'
oAuthGatewayLabel VARCHAR 75 √ NULL
oAuthAuthorizeUrl VARCHAR 255 √ NULL
oAuthAccessTokenUrl VARCHAR 255 √ NULL
oAuthResourceOwnerUrl VARCHAR 255 √ NULL
oAuthGatewayIcon VARCHAR 255 √ NULL
oAuthScope VARCHAR 255 √ NULL
ssoEntityId VARCHAR 255 √ NULL
oAuthLogoutUrl VARCHAR 255 √ NULL
oAuthGrantType BOOLEAN 3 √ 0
oAuthPrivateKeys VARCHAR 255 √ NULL
samlMetadataOption VARCHAR 30 √ NULL
samlBtnIcon VARCHAR 255 √ NULL
samlBtnBgColor CHAR 7 √ '#de1f0b'
samlBtnTextColor CHAR 7 √ '#ffffff'
samlStaffPTypeAttr VARCHAR 255 √ NULL
samlStaffPTypeAttrValue VARCHAR 255 √ NULL
samlStaffPType VARCHAR 30 √ NULL
oAuthStaffPTypeAttr VARCHAR 255 √ NULL
oAuthStaffPTypeAttrValue VARCHAR 255 √ NULL
oAuthStaffPType VARCHAR 30 √ NULL
staffOnly BOOLEAN 3 √ 0
bypassAspenLogin BOOLEAN 3 √ 0
ssoUseGivenUserId BOOLEAN 3 √ 1
ssoUseGivenUsername BOOLEAN 3 √ 1
ssoUsernameFormat BOOLEAN 3 √ 0
ssoSPLogoutUrl VARCHAR 255 √ NULL
ssoILSUniqueAttribute VARCHAR 255 √ NULL
ldapHosts VARCHAR 500 √ NULL
ldapUsername VARCHAR 75 √ NULL
ldapPassword VARCHAR 75 √ NULL
ldapBaseDN VARCHAR 500 √ NULL
ldapIdAttr VARCHAR 75 √ NULL
ldapOrgUnit VARCHAR 225 √ NULL
ldapLabel VARCHAR 75 √ NULL
ssoAuthOnly BOOLEAN 3 √ 0
bypassAspenPatronLogin BOOLEAN 3 √ 0
samlStudentPTypeAttr VARCHAR 255 √ NULL
samlStudentPTypeAttrValue VARCHAR 255 √ NULL
samlStudentPType VARCHAR 30 √ NULL
forceReAuth BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc name

Relationships