0 rows


Column Type Size Nulls Auto Default Children Parents Comments
identity_provider_domain_id INT 10 null

unique key, used to identify providers domain

identity_provider_id INT 10 null
identity_providers.identity_provider_id identity_provider_domain_ibfk_1C

Reference to provider

domain VARCHAR 100 null

Domain name. If null means all domains

auto_register BIT 0 0

Allow user auto register

update_on_auth BIT 0 0

Update user data on auth login

default_library_id VARCHAR 10 null
branches.branchcode identity_provider_domain_ibfk_2C

Default library to create user if auto register is enabled

default_category_id VARCHAR 10 null
categories.categorycode identity_provider_domain_ibfk_3C

Default category to create user if auto register is enabled

allow_opac BIT 0 1

Allow provider from opac interface

allow_staff BIT 0 0

Allow provider from staff interface


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identity_provider_domain_id
allow_opac Performance Asc allow_opac
allow_staff Performance Asc allow_staff
domain Performance Asc domain
identity_provider_domain_ibfk_2 Performance Asc default_library_id
identity_provider_domain_ibfk_3 Performance Asc default_category_id
identity_provider_id Must be unique Asc/Asc identity_provider_id + domain