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

timeout INT 10 0

number of seconds before Koha stops trying to access this server

servertype enum('zed', 'sru') 4 zed

zed means z39.50 server

encoding MEDIUMTEXT 16777215 null

characters encoding provided by this target

recordtype enum('authority', 'biblio') 10 biblio

server contains bibliographic or authority records

sru_options VARCHAR 255 null

options like sru=get, sru_version=1.1; will be passed to the server via ZOOM

sru_fields LONGTEXT 2147483647 null

contains the mapping between the Z3950 search fields and the specific SRU server indexes

add_xslt LONGTEXT 2147483647 null

zero or more paths to XSLT files to be processed on the search results

attributes VARCHAR 255 null

additional attributes passed to PQF queries

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id