| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
unique identifier assigned by Koha |
|
| host | VARCHAR | 255 | √ | null |
|
|
target’s host name |
|
| port | INT | 10 | √ | null |
|
|
port number used to connect to target |
|
| db | VARCHAR | 255 | √ | null |
|
|
target’s database name |
|
| userid | VARCHAR | 255 | √ | null |
|
|
username needed to log in to target |
|
| password | VARCHAR | 255 | √ | null |
|
|
password needed to log in to target |
|
| servername | LONGTEXT | 2147483647 | null |
|
|
name given to the target by the library |
||
| checked | SMALLINT | 5 | √ | null |
|
|
whether this target is checked by default (1 for yes, 0 for no) |
|
| rank | INT | 10 | √ | null |
|
|
where this target appears in the list of targets |
|
| syntax | VARCHAR | 80 | √ | null |
|
|
marc format provided by this target |
Diagram producer might be missing
No diagrams were produced please see application output for any errors