Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||
| name | VARCHAR | 50 | 'ils' |
|
|
|||
| driver | VARCHAR | 50 | null |
|
|
|||
| loginConfiguration | enum('barcode_pin', 'name_barcode', 'barcode_lastname') | 16 | null |
|
|
|||
| authenticationMethod | enum('ils', 'sip2', 'db', 'ldap', 'sso') | 4 | √ | NULL |
|
|
||
| vendorOpacUrl | VARCHAR | 100 | null |
|
|
|||
| patronApiUrl | VARCHAR | 100 | null |
|
|
|||
| recordSource | VARCHAR | 50 | null |
|
|
|||
| weight | INT | 10 | null |
|
|
|||
| databaseHost | VARCHAR | 100 | √ | NULL |
|
|
||
| databaseName | VARCHAR | 75 | √ | NULL |
|
|
||
| databaseUser | VARCHAR | 50 | √ | NULL |
|
|
||
| databasePassword | VARCHAR | 50 | √ | NULL |
|
|
||
| sipHost | VARCHAR | 100 | √ | NULL |
|
|
||
| sipPort | VARCHAR | 50 | √ | NULL |
|
|
||
| sipUser | VARCHAR | 50 | √ | NULL |
|
|
||
| sipPassword | VARCHAR | 50 | √ | NULL |
|
|
||
| databasePort | VARCHAR | 5 | √ | NULL |
|
|
||
| databaseTimezone | VARCHAR | 50 | √ | NULL |
|
|
||
| oAuthClientId | VARCHAR | 36 | √ | NULL |
|
|
||
| oAuthClientSecret | VARCHAR | 50 | √ | NULL |
|
|
||
| ils | VARCHAR | 20 | √ | 'koha' |
|
|
||
| apiVersion | VARCHAR | 10 | √ | '' |
|
|
||
| staffUsername | VARCHAR | 100 | √ | NULL |
|
|
||
| staffPassword | VARCHAR | 50 | √ | NULL |
|
|
||
| workstationId | VARCHAR | 10 | √ | '' |
|
|
||
| domain | VARCHAR | 100 | √ | '' |
|
|
||
| libraryForRecordingPayments | TINYINT | 3 | √ | 1 |
|
|
||
| ssoSettingId | TINYINT | 3 | √ | -1 |
|
|
||
| iiiLoginConfiguration | enum('', 'barcode_pin', 'name_barcode', 'name_barcode_pin') | 16 | '' |
|
|
|||
| overrideCode | VARCHAR | 50 | √ | '' |
|
|
||
| carlXViewVersion | enum('', 'v', 'v2') | 2 | '' |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| account_profiles_s_pk | Primary key | Asc | id |
| name | Must be unique | Asc | name |
| PRIMARY | Must be unique | Asc | id |
Relationships
Close relationships within degrees of separation
