0 rows


Column Type Size Nulls Auto Default Children Parents Comments
identity_provider_id INT 10 null
identity_provider_domains.identity_provider_id identity_provider_domain_ibfk_1C

unique key, used to identify the provider

code VARCHAR 20 null

Provider code

description VARCHAR 255 null

Description for the provider

protocol enum('OAuth', 'OIDC', 'LDAP', 'CAS') 6 null

Protocol provider speaks

config LONGTEXT 2147483647 null

Configuration of the provider in JSON format

mapping LONGTEXT 2147483647 null

Configuration to map provider data to Koha user

matchpoint enum('email', 'userid', 'cardnumber') 10 null

The patron attribute to be used as matchpoint

icon_url VARCHAR 255 null

Provider icon URL


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identity_provider_id
code Must be unique Asc code
protocol Performance Asc protocol